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