Solved

Log Shipping Backup with Database in StandBy Mode

Posted on 2014-01-23
1
285 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
1 Comment
 
LVL 142

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Get the latest status 8 32
Query group by data in SQL Server - cursor? 3 33
Deal with apostrophe in stored procedures 8 42
SQL Function NOT ROUND 9 10
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

773 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