Copying Databases to test machine

• Rob DePerno

  Newbie

  Points: 2

  More actions

  November 4, 2006 at 11:14 am

  #367975

  HI, I'm a novice who recently lost his it guy. I have a system in use Win2k server sp4 with sql 2000 @@version:

  Microsoft SQL Server  2000 - 8.00.194 (Intel X86)   Aug  6 2000 00:57:48   Copyright (c) 1988-2000 Microsoft Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

  and want to copy databases over to a test box running Windows 2003 sp1 server with sql 2000 @@version:

  Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

  Any advice would be greatly appreciated,

  Thanks,

  Rob

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  November 6, 2006 at 9:17 am

  #670098

  There are several options.  You can use the Copy Database Wizard, backup and restore, or detach/attach.  This article has the details: http://support.microsoft.com/kb/314546/en-us

  If you definitely want to copy the databses, not move them, I recommend the backup and restore method.  You'd make a full backup of the source database, move the backup file to the destination server, and restore the database from the backup file.  This method leaves the source database operational on the first server and restores it with the same name on the second.

  Greg

  Greg

• Rob DePerno

  Newbie

  Points: 2

  More actions

  November 6, 2006 at 10:05 am

  #670128

  Thanks for the info Greg.

  Rob