Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Location
    BC Canada
    Posts
    61

    Unanswered: Clone a SQL Server

    We are in the process of upgrading from SQL Server 7 to SQL Server 2000.

    Before we do that we want to run our system on our new server in a test environment to iron out any issues which may arrive from the upgrade, and to use for future testing. Is there a way to 'clone' a SQL 7 server onto a 2nd physical machine.

    Thanks

  2. #2
    Join Date
    May 2002
    Posts
    299

    Re: Clone a SQL Server

    You could restore sql7 database on sql2k box and do whatever tests needed.
    --
    -oj
    http://www.rac4sql.net

  3. #3
    Join Date
    Oct 2002
    Location
    BC Canada
    Posts
    61

    Re: Clone a SQL Server

    Originally posted by oj_n
    You could restore sql7 database on sql2k box and do whatever tests needed.
    I need to make sure all of the DTS pacjkages go as well.

  4. #4
    Join Date
    May 2002
    Posts
    299
    Here is a good kb that should help you...

    http://support.microsoft.com/?id=314546
    --
    -oj
    http://www.rac4sql.net

  5. #5
    Join Date
    Dec 2002
    Posts
    1,245

    Re: Clone a SQL Server

    There is a utility called DTSBackup2000 that's available free from SQLDTS.com. It works quite well, though I don't know what impact migrating from 7.0 to 2000 might have.

    Regards,

    Hugh Scott

    Originally posted by GregCrossan
    I need to make sure all of the DTS pacjkages go as well.

Posting Permissions

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