SQL Server Performance Forum – Threads Archive

Switching database to another sql server 7.0

My company currently have 2 sql server 7.0 running. Now they would want to only have 1 sql server 7.0 running and either one have to being shut down. How can I copy one of the server to another server? What steps should I follow, backup and restore it, replicate or any better suggestion? Can please also tell the detail steps on perfomring this task? I’m still quite a newbie in this area… Thanks in advance…

Handful KBAs & articles for your reference:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;304692
http://support.microsoft.com/default.aspx?scid=kb;EN-US;240872
http://vyaskn.tripod.com/moving_sql_server.htm
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
http://www.databasejournal.com/features/mssql/article.php/2224361
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

thanks for the information…..

]]>