Post reply

copying old servers info to a new one

  • June 4, 2004 at 2:17 pm

    #85284

    Ok, I have a new server that I will be moving all of our current SQL stuff to, complete with a nice cluster to keep it up and running for me

    What I'd like to know is the steps you guys would take to move all of the data, DTS packages, users, etc... to the new server?

    Thanks

     

  • June 4, 2004 at 3:24 pm

    #509103

    I would use backups/restores to move the databases, and possibly msdb for the DTS packages if there are quite a few.  Otherwise, I would save the DTS packages as vb scripts, copy them to the new server, then save them to msdb.

    I have stored procedures to script out security, which makes that part much easier.  I also have a proc for SQL configuration.

    I generally script out jobs from EM and execute the scripts on the new server.

    All of my utility stored procedures, backups, etc are in a "special" dba database, so I can restore it on the new server and have them ready to go.

    Steve

  • June 5, 2004 at 9:44 am

    #509131

    Backup/restore is my method. sp_help_revlogin from MS's site can get logins. For DTS, I'd save off, open on the new server, you can script the jobs.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply