Copying our disaster recovery database on a SQL Server
0
Q:
Copying our disaster recovery database on a SQL Server
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
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Mar 6 2009  1:34 AM GMT by Mrdenny   46795 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

IT Knowledge Exchange Community Update for 03/05/09 - ITKE Community Blog   0 pts.  |   Mar 5 2009  4:02PM GMT

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

 
0