Copying our disaster recovery database on a SQL Server

Tags:
Database Recovery
Disaster Recovery
Disaster recovery planning
Disaster Recovery testing
Log Shipping
SQL Server
SQL Server database
We are using log shipping on our SQL Server as our disaster recovery solution. When we want to test our disaster recovey with a test transaction, not production, we need to use the secondary copy. However, we don't want to stop it and lose consistency between disaster recovery and the production copy. How can we quickly get a copy of our disaster recovery database that will reside on the same server?

Answer Wiki

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

There isn’t really an easy way to do this.

About the easiest way to do it would be to stop the SQL Service on the DR server, and copy the database files. Then restart the datbase serer. Then attach the copied files as another database name. How quick it backs up will depend on how large the database is.

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.
  • IT Knowledge Exchange Community Update for 03/05/09 - ITKE Community Blog
    [...] Copying our disaster recovery database on a SQL Server [...]
    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.

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

Following

Share this item with your network: