Solved

Log Shipping Backup with Database in StandBy Mode

Posted on 2014-01-23
1
288 Views
Last Modified: 2014-02-06
I have a database in Standby mode which is set up as a DR box. This database has logshipping setup on it. I need to take a backup or make a copy of this database for testing purposes on my DR box but I need to keep the same name. The end users need to do some testing. How can this be done without breaking the logshipping chain.

I was thinking to take the database offline and move the mdf and ldf files to another Drive and then recover the database by attaching the datafiles. The issue is I need to keep the same name as my standby Database. Will this create an issue in the master database when I am done with my testing and try to bring the original Standby database back online with the original mdf and ldf files.

Any help would be appreciated.  Thanks in advance.
0
Comment
Question by:VitaminD
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 39804820
I think you should really do the testing on a dedicated services, and not on the actual DR server.

or you create some scripted way to put back everything "from scratch", without trying to "trick" the db. the master db will have some SCN references of what the database was in regards to backup and log shipping ...
0

Featured Post

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question