October 6, 2009 at 10:29 am
Hi
I am doing migration from SQL Server 2000 to SQL Server 2005. Suppose that the name of SQL Server 2000 instance is SERVER A and the name of the fresh SQL Server 2005 instance is SERVER B.
Now during the cutover, Server A has to be changed to Server C &
Server B has to be changed to Server A.
Now my question is during the cutover
1. Should we rename these servers after migrating all the DB’s and the DB components on to the new server (OR)
Should we rename these servers before migrating all the DB’s and the DB components on to the new server.
Could anyone help me with this?
Thank You,
Best Regards,
SQLBuddy.
October 6, 2009 at 12:20 pm
We did the same thing at our shop. What we did was we set up Log shipping to keep the DBs in sync. Once all traffic was cut off to the old server we did the last log shipping, Renamed the old server and changed the IP and take it down and also made sure that the DNS was clean. Then we renamed the new server to old server and give the IP of the old server, reboot it. Do an sp_dropserver and sp_addserver.
We did it this way because we planned for it and tested it at least 3 times.
Please make sure that you test the sequence right and have scripts ready....
-Roy
October 6, 2009 at 12:51 pm
Make sure you do an update statistics once you've got the data over too
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
October 6, 2009 at 1:55 pm
Hi Roy,
Thank you very much for your help.
According to your message, should I rename the server after migrating all the databases and other components on to the new server?
Actually, I am also of the same opinion. If we rename first and then migrate, I think there will be some problems with the migrated components due to the dependencies of the DB components on the server name.
Thank You,
Best Regards,
SQLBuddy.
October 6, 2009 at 1:57 pm
Hi Andrew,
Thanks a lot for your help.
I will definitely keep that in mind.
Thank You,
Best Regards,
SQLBuddy
October 6, 2009 at 2:37 pm
Once you have copied all the jobs to the new server and renamed the server with a drop and an Add, check what is the server name in the Jobs in MSDB. It might still have the old name. If it is, it will not allow you to edit it. You will have to do an Update on the table.
-Roy
October 6, 2009 at 3:38 pm
Hi Roy,
Thank you very much for your reply.
I really appreciate your help.
Thank you,
Best Regards,
SQLBuddy.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply