Post reply

Changing logical & physical filenames

  • December 12, 2005 at 3:00 pm

    #110494

    Hi everyone, can someone help me with this? Thanks in advance.

    1. How do I change a filename from x.mdf to y.mdf?

    2. How do I change the filename used in SQL Server from X to Y?

  • December 13, 2005 at 5:53 am

    #609177

    To change the physical name, detach the database and rename. Then attach the database.

    As far as I know you cannot change the logical name of a database.

    Wilson

  • December 13, 2005 at 6:20 am

    #609181

    Here's a link with a solution to your problem,

    http://www.ssw.com.au/ssw/kb/KB.aspx?KBID=Q365270

     

     

  • December 15, 2005 at 3:52 pm

    #609916

    From BOL:

     

    ALTER DATABASE database_name

    MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply