How can I copy the SQL Server Database Data File (mdf)

• Perry Whittle

  SSC Guru

  Points: 233957

  More actions

  April 8, 2009 at 6:39 am

  #974221

  Krishna Potlakayala (3/28/2009)

  ---

  You can't copy the .mdf file if the server is online.

  "Au contrair mon pere"

  you dont need to shutdown sql server!

  you dont need to detach the database!

  you dont even need to back it up and restore it!

  For the database you wish to retrieve, ensure no users are connected and then issue

  alter database [mydatabase] set offline

  copy the disk files (mdf and ldf) then bring back online using

  alter database [mydatabase] set online

  😉

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉

• tosscrosby

  SSCoach

  Points: 18045

  More actions

  April 9, 2009 at 7:45 am

  #975044

  Perry Whittle (4/8/2009)

  ---

  "Au contrair mon pere"

  😉

  Haven't heard that in "forever". Thanks for the early morning laugh....

  -- You can't be late until you show up.