Duplicate SQL Server 2005 database

352420 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?

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 Open Source.

++++++++++++

You can use database mirroring to keep the backup machine in sync in near real time.

Discuss This Question: 3  Replies

 
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
  • Brijesh
    Hi,

    Try backup the database and restore the database under a new name and/or on another server. Both these operations can be performed from Enterprise Manager (SQL2000) or its replacement SQL Management Studio (SQL2005+), or the TSQL commands BACKUP and RESTORE.

    Note: you can restore a database backed up from SQL2000 on SQL2005 with not issues in most cases, but not the other way around. or 

    Detach the database, copy the .MDF file (and .ldf file) and you can attach both. Or only one, to keep one as a copy for a fast copy later. The "Copy database" command from Mcirosoft SQL Server Management Studio can also work like this. You can automate/script this easily, using PowerShell or just .Cmd files with calls to osql.


    9,870 pointsBadges:
    report
  • Brijesh

    Hi,

    Try backup the database and restore the database under a new name and/or on another server. Both these operations can be performed from Enterprise Manager (SQL2000) or its replacement SQL Management Studio (SQL2005+), or the TSQL commands BACKUP and RESTORE.
    Note: you can restore a database backed up from SQL2000 on SQL2005 with not issues in most cases, but not the other way around. or 

    Detach the database, copy the .MDF file (and .ldf file) and you can attach both. Or only one, to keep one as a copy for a fast copy later. The "Copy database" command from Mcirosoft SQL Server Management Studio can also work like this. You can automate/script this easily, using PowerShell or just .Cmd files with calls to osql.
    9,870 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