Post reply

Moving a DB to a new location

  • 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?

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

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