Results 1 to 2 of 2

Thread: Backup and Move

  1. #1
    Join Date
    Feb 2004

    Unanswered: Backup and Move

    SQL Nubie need to accomplish two things. 1. backup an SQL2000 db on old hardware. 2. Use backup to build same SQL2000 db onto new hardware, which will replace old hardware as main system. Running Win2000 server standard edition on old server and Win2003 server standard edition on new server. Old server does not have a tape backup, but it has a cd burner and access to a Novell corparate network -without any established Windows domains. Asking for much, hope someone can help. Some source material would go along way. Thanks
    Last edited by Nicholas; 02-06-04 at 08:58.

  2. #2
    Join Date
    Nov 2002
    Dump the databases in a local file on your harddisk, using backup SQL statement.
    Bcp out the main tables of the master DB.
    Copy all these files into your CD and tranfer them in the new hardware.
    Recreate a new MS-SQL server in the new machine

    do you keep the original tree-architecture in your both machines ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts