July 28, 2010 at 12:45 am
Hi,
During migration from database server to another database server with good resources(new H/w ...)
Do we need to take the backups prior renaming the old box. This is the current scenario.
Say, i have two database servers "A" and "B". Server "A" is old one. Server "B" is new server with more hardware. So, all the databases will be residing in Server-A originally. All these must be moved to Server-B and finally the server-B will be renamed as Server-A.
During migration, the Server-A will the renamed with Server-B and Server-B will be renamed with Server-A. Now after posting the downtime, i will take backups from Server-B and restore on the server-A.
Finally, the old server is current server B will be switched off.
Now my doubt is while changing and renaming the databse server name (machine name), will have any affect on the databases inside the server? As per my knowledge, we need to be concerned about the Sql server instance name i.e sp_Drop server , jobs , and linked servers (if any).
I really feel their would be no problem if we take the backups of the databases within any sql instance, that does'nt affect the backups rigth?
Is there anything i.e sql instance related information is tagged inside the backup? i dont think so, only .mdf and .ldf will be associated with a database.
Please confirm!
Thanks in Advance.
July 28, 2010 at 12:48 am
I beleive databases are related to only "master" databases and nothing to do with server renaming.
We dont have problem if we take the backups before server migration.
But in the current scenario we are taking the full backups after renaming. Thats the reason, just want to confirm.
July 28, 2010 at 1:15 am
You Need to run Below commands after renaming the Server B to Server A
sp_dropserver 'ServerB'
sp_addserver 'ServerA’, 'local'
select @@servername
Thank You.
Regards,
Raghavender Chavva
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply