Moving my Database

• Joe Orlando

  Valued Member

  Points: 61

  More actions

  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?

• Jpotucek

  SSCoach

  Points: 18583

  More actions

  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