Home > IT Answers > SQL Server > Copying our disaster recovery database on a S...
SQL Server Ask the Experts
2,585 pts.
 Copying our disaster recovery database on a SQL Server
SQL Server, SQL Server databases, Disaster recovery (DR) testing, Log Shipping, Disaster Recovery, Disaster recovery planning, Disaster Recovery 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?
ASKED: Mar 4, 2009  4:56 PM GMT
UPDATED: March 6, 2009  1:34:48 AM GMT
RELATED QUESTIONS
Mrdenny
63,630 pts.
Answer Wiki:
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.
Last Wiki Answer Submitted:  Mar 6, 2009  1:34 AM (GMT)  by  Mrdenny   63,630 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

[...] Copying our disaster recovery database on a SQL Server [...]

IT Knowledge Exchange Community Update for 03/05/09 - ITKE Community Blog
 0 pts.