Restoring Database back to standby (Log Shipping)

[MikeWiz628]

Say that I take a my standby database out of standby and transaction log are still being written from the production server.

Now I want to put the database back into standby. I know the steps to put it back in. The way I've been doing it, is I'm copying a backup from the production server then appplying any transaction logs afterwards.

Is there a way to use the database from the original standby server and apply any transactions and put it back into standby?

I hope that makes sense. Thanks in advance!

 

[MikeWiz628]

Just to clarify things a little.

Say I make a backup of the standy database, after it was taken out of standby, just so I can put it back in to standby.

Would the transaction logs from the production server match up properly to the backup of the standby server?

Basically, in a DR test situation, I would like to take the backup server out of standby, test it, and put it back into standby and apply any transaction logs that had occur.

 

[mrdenny]

Nope. Once it's in read/write mode (aka out of standby) you've got to do a full backup and restore from production to DR. You can't restore logs from one servers backup to a full backup from another server.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[MikeWiz628]

That's what I thought. Thanks for the verification!

 

[mrdenny]

no problem

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com