warm standby rollback

Question

warm standby rollback

anel3

SSC Enthusiast

Points: 188
More actions
October 21, 2015 at 4:59 am

#399216

Hi
I Have implement log shipping from Nigeria to Sa using FTP to ship the log files.
Has been working without incident for around a year.
my database in SA is in warm standby, and every night a script checks if there are new files and applies them to the warm standby database.
My primary database in Nigeria was restored from a Backup at some point , and I had already applied some logs taken after the restore point to the warm standby which I now want to Undo. ie role back to a specific LSN, so that I can continue applying logs produced by the restored Primary.
I could get a new Backup but this takes weeks, posting portable hard drives back and forth.
Any suggestions
August 25, 2020 at 7:05 pm

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

You need to send down the backup that you restored the primary from (or any other backup taken after that time) and all log backups. You can't 'undo' an applied transaction log backup.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

anel3 SSC Enthusiast Points: 188 More actions · Answer 2

Thanks for that, I had a feeling I would need a new backup

Regards Andre

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 3

You don't need a new backup- as Gila says you just need the old backup(s) again.

anel3 SSC Enthusiast Points: 188 More actions · Answer 4

Noted, but unfortunately I don't keep all the log files. I only retain those that I have not yet applied to the standby database. once successfully applied (+2 days) I delete.

So in essence I need a fresh backup.

But well spotted thanks:-)

donaldyates123 Newbie Points: 1 More actions · Answer 5

Thank you all for this great information. I like this forum. If you anybody are in a need of essay writing help then you can go through best essay writing service[/url]. They will give you a perfect essay for any of your essay topic. Unsatisfied customer get quick refund from these services. Go through and feels their appreciable activity.