Application cutover to new server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Application cutover to new server

Hi I have migrated my two database to another server(SQL7.00 to SQL2000) .Now i want to cutover my application from my old server to new server. Unfortunatly i cant do any R&D on this. Does anyone has any Document on Application cutover and things to be taken care. Thanks in advance.
Rajiv
SQL-DBA
Do you mean to tell the application to point to the new Server?
If so, connect the application to the Server through DSN and Modify that DSN if the server changes
Madhivanan Failing to plan is Planning to fail
If you want to make sure that no one connects to the old database , take the old database offline on the old server .. Check if you are using any linked servers in any stored Procedures. if you are changing the name of the server… Venu
]]>