Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-07-28 : 02:44:32
|
| 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. |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2010-07-28 : 02:48:17
|
| 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. |
 |
|
|
|
|
|
|
|
database machine/server migration