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

    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.

    ZYT

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    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
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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