Moving a DB to a new location

• Anders Pedersen

  SSChampion

  Points: 11410

  More actions

  May 8, 2007 at 8:09 am

  #123697

  I need to move two databases to a new hard drive.  In the past I have always used detach/attach method, but in SQL 2005 (and earlier, but just noticed it...) you can now also set the database off line, copy the files, and then alter the database to point to the new location.

  Any idea which is better/safer?

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 8, 2007 at 9:16 am

  #704962

  I think both methods are safe.  The difference is that a detached database can have it's files moved to another SQL Server instance while an offline database cannot.  I've used both methods for moving files to different disks while leaving the database in the same instance.

  Greg

  Greg