Duplicate SQL Server 2005 database
What is the best way to duplicate a SQL Server 2005 database to another server as a standby machine? Can I do this with another installation and some scripting? I have a separate box with SQL 2005 already installed. Can I backup and restore from one machine to the other using scripts and no human intervention?
Software/Hardware used:
Software/Hardware used:
ASKED:
July 26, 2010 1:59 PM
UPDATED:
July 26, 2010 11:25 PM
Answer Wiki:
There are multiple ways. You can use a 3rd party product like XoSoft or DoubleTake. Another option could be to nightly dump your database within SQL to a centralized location where the spare server can nightly copy to a local volume for "future" use.
+++++++++++++++++++++++++++++++++++
Another option via <a href="http://sqldump.sourceforge.net/ ">Open Source</a>
++++++++++++
You can use database mirroring to keep the backup machine in sync in near real time.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
