Log Shipping Backup with Database in StandBy Mode

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.
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
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 ...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.