Database migration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database migration

Hi, I have 2 sql servers (a, b)with about 20 databases in each. Now I need migrate all the databases from server server b to server to decomission server b.
Please give me the list of feasibility counters to be determined on server a for this purpose. Thanks, Gayathri
Hi,<br />you can do it with :<br /><br />1). Backup / Restore<br />2). Attach / dettach<br /><br />ensure a good hdd space and enough RAM to handle load ,patchup with latest SP and Hot Fix , ensure every user database’s users are also moved , and please refer :<a target="_blank" href=http://vyaskn.tripod.com/moving_sql_server.htm>http://vyaskn.tripod.com/moving_sql_server.htm</a> , for more details.<br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
If you haven’t performed such operations prevously then I suggest to choose a database in test environment and test the information referred in the link by Hemant which is a wholesome operation. Ensure there are no network issues between those 2 SQL SErvers. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks Satya and Hemanth. I’m aware of the method to perform the move. I had also looked up the link.
I’m sorry for not being clear in my question. I just wanted to determine whether the server ‘a’ will be able to handle the load. How do I calculate the important counters like memory etc to make sure that server ‘a’ can be utilized for the move. Thanks Gayathri
This is not a performance issue related as you’re using BACKUP and RESTORE method.
http://www.sql-server-performance.com/backup_restore_tuning.asp and KBAhttp://support.microsoft.com/kb/824430 gives information about backup tips and related issues.
Ensure the service pack level and mDAC level between those 2 servers are similar to avoid any last minute suprise. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Look on this site for performanece counter info. Start by looking at the standard CPU, RAM and disk counters and try to compare the two servers. Other factors like hardware config, disk storage, backup requirements, user access and monitoring can also factor in when evaluating if server B can take over the work from server A.
]]>