?
Solved

Log Shipping Backup with Database in StandBy Mode

Posted on 2014-01-23
1
Medium Priority
?
298 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 2000 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

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

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
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

801 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