Post reply

Moving my Database

  • September 23, 2005 at 12:07 pm

    #168867

    I have the need to move my database to a newer faster server. They both will have the same version of SQL, 2000. The new server will be Windows 2003 server, where the old one is 2000 server. Can I load a new copy of SQL on the new server and copy the de-attached database to it and then re-attach?

  • September 23, 2005 at 2:15 pm

    #592769

    Sure.  I use Backup/Restore, but I think dettach/attach will work too.   here's a link that will be helpfull if you have any users to move:  http://support.microsoft.com/kb/246133

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

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