October 21, 2015 at 4:59 am
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
October 21, 2015 at 5:33 am
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
October 21, 2015 at 5:43 am
Thanks for that, I had a feeling I would need a new backup
Regards Andre
October 21, 2015 at 6:00 am
You don't need a new backup- as Gila says you just need the old backup(s) again.
October 21, 2015 at 6:22 am
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:-)
December 15, 2015 at 3:22 am
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.
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