SQL Server Performance Forum – Threads Archive
Switching database to another sql server 7.0My 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:
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
thanks for the information…..