Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Unanswered: How to copy a SQL Server insntance?

    Hello everyone:

    I have a SQL Server 2000 server in which there are three instance. I want to setup a new SQL Server 2000 server and move one of them to the new one. There are about 30 DTS package and 20 jobs. Does anyone advice what is the best process by which I can move users, logins, jobe and DTS packages to the new server.

    Thanks a lot.


  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    Jobs can be scripted. DTS packages can be saved as files for transfer.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

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