January 10, 2008 at 3:26 pm
Hi all,
I just inherited Log Shipping in my new place from a non-DBA, and it stopped working.
Now, I'm trying to get it to work but there's a gap in the sequence. It's asking me to restore earlier TRN files, which have been deleted already.
Can anyone tell me what my options are? Is it possible to salvage the existing configuration by re-initializing the database with a backup, or should I delete and start from scratch.
Thanks in advance.
January 10, 2008 at 3:33 pm
should be able to salvage current set up.
disable the log shipping jobs
delete (or move to another directory) any tran log backups in source and destination folders (leave redo file)
backup primary database
copy to secondary and restore with replace, norecovery
re-enable log shipping jobs and do a trial log backup, copy, restore to prove functioning.
---------------------------------------------------------------------
January 10, 2008 at 5:33 pm
Thank you.
I ended up recreating from scratch.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply