Duplicate SQL Server 2005 database

56,485 pts.
Tags:
Backup
Backup and restore
SQL Server 2005
SQL Server 2005 backup
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?
ASKED: July 26, 2010  1:59 PM
UPDATED: July 26, 2010  11:25 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ITKE
    [...] 1. Mr. Denny, Aguacer0 and EmNichs helped out in creating a duplicate SQL Server 2005 database. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following