Solved

Log Shipping Backup with Database in StandBy Mode

Posted on 2014-01-23
1
287 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

735 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