Change logical name to DB files

• Mithrandir

  SSCrazy

  Points: 2628

  More actions

  January 13, 2006 at 8:16 am

  #111296

  Hello guys.

  I'm wondering how to change the logical name to a DB. I mean the "name" column in this sentence

  select * from sysfiles

  A clear example is when you have the test and production databases in the same server and restore one of them to the other; the name column will keep the old DB name.

  I've reviewed sp_rename% or sp_change% SP's but none of them seem to be helpful.

  Any clue?

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  January 13, 2006 at 8:55 am

  #614671

  When you restore your test db you should use the

  WITH MOVE option to rename your files.

  You cannot rename the files of a database.

   

• Mithrandir

  SSCrazy

  Points: 2628

  More actions

  January 13, 2006 at 4:28 pm

  #614770

  And what about taking dettach-rename-reattach? As far as I understand this will leave us with the old "name" too, but without a way to change it :-

  I know to lurk in systables is not recomended, but maybe is this a way?

• Jo Pattyn

  SSC-Dedicated

  Points: 32408

  More actions

  January 14, 2006 at 10:20 am

  #614800

  Isn't this done using

  ALTER DATABASE X

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

• Mithrandir

  SSCrazy

  Points: 2628

  More actions

  January 16, 2006 at 8:02 am

  #614924

  Yes, that works!

  Thank you!