Change .mdf & .ldf after restoration

• Andrew J

  Mr or Mrs. 500

  Points: 507

  More actions

  February 3, 2006 at 2:46 pm

  #111466

  Hi All,

  I know that this question is like a "newbie" question, but please help me on this.

  How can I rename/change the .mdf & .ldf file name after I attach(restore) the database.

  for example, the file name is old.mdf and old.ldf, I attach it as database: new.

  then, I want to change the filename to be new.mdf & new.ldf

  Is there any sql querry to do this?

  Thank you very much for your answers

   

  Cheers,

  Andy J

• homebrew01

  SSC Guru

  Points: 55549

  More actions

  February 5, 2006 at 3:22 pm

  #618885

  Pretty simple

  1) Detach the database

  2) Rename the files.

  3) Attach the database. You'll probably have to put the path & file name in the "attch" screen.

  4) all done

• Raghu Pyapili

  SSC Enthusiast

  Points: 119

  More actions

  February 6, 2006 at 9:52 pm

  #619153

  Hi Andrew,

  If renaming the database is your only concern then, u can try this query,

  sp_renamedb 'Olddbname','Newdbname'

  Cheers,

  Raghu Pyapili

• Jason Hall

  Hall of Fame

  Points: 3906

  More actions

  February 7, 2006 at 7:45 am

  #619275

  That will just rename the database.  If you need to rename the files making up the database you must do that when the database is offline whether through a detatch or restore.

• Andrew J

  Mr or Mrs. 500

  Points: 507

  More actions

  February 10, 2006 at 9:11 am

  #620186

  It Works

  Thanks for the advise, guys

   

  Best Regards,

  Andrew J.