May 3, 2006 at 10:10 am
Hi everyone,
I have 2 database servers that run on old Dell servers. We just bought a new Dell server to replace both of these servers. How do I go about merging the data in the master/msdb databases? Thanks for your help.
May 4, 2006 at 12:21 am
What you need to do is
1) Backup all User Databases restore them to the new SQL Server.
2) Script all the Jobs from the other SQL Servers and run on new SQL Server.
3) Obtain the script sp_helprevlogin from the Microsoft web site. This will script all logins and you will be able to apply this script to your new SQL Server.
4) If you have applications accessing this new SQL Server, you will need to modify the Applications to look at a the NETBIOS Name of the new SQL Server. Alternativley, rename the SQL Server after you do the migration steps.
5) If you have Replication configured, Drop the Replication before doing any of the above steps.
This is the way I would do it but you will have to test it first before taking my word for it although I have done this twice before. I may have the steps the wrong way around above but it gives you a starting point to work form.
May 4, 2006 at 9:47 am
Check out this link: http://www.wardyit.com/blog/blog/archive/2006/04/26/101.aspx
The sp_helprevlogin broke with an update to ss2k5, so if you are using ss2k, be sure you keep this around.
Good advice above for moving.
May 4, 2006 at 9:55 am
Don't forget any DTS packages you may have on the original servers; as well as any necessary modifications.
Best of luck,
Mark
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply