September 12, 2016 at 10:36 am
Hi,
I have been looking at log shipping for the first time to fulfil a warm reporting solution and would like to implement this between 2008 and to 2012 which is implied in the below article to be possible.
http://www.sqlservercentral.com/Forums/Topic1499395-2799-1.aspx
Having followed the above steps it 'nearly' seems to work but the log files are skippedot applied as per message below
Skipped log backup file. Secondary DB: 'TestLS2', File: 'G:\Log Shipping\CON-POL-SAGE-01_TestLS\TestLS2_________.trn'
Could not find a log backup file that could be applied to secondary database 'TestLS2'.
Any ideas if this can be achieved?
Thanks in advance
Laurence
September 12, 2016 at 12:44 pm
Nope, as I commented on the referenced thread, not possible.
You can log ship up-version if and only if the logs are restored WITH NORECOVERY. You cannot have a version mismatch and restore WITH STANDBY.
The reason you're getting the error about not being able to find a log backup is that the restore WITH RECOVERY adds extra log records, so when ther DB is backed up and re-restored WITH STANDBY, the logs from the primary no longer match and hence can't be restored.
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply