July 23, 2012 at 10:34 am
Greetings All!
I have log shipping configured between a primary and secondary server. The secondary server will not restore files if they are not in the files name is not in the format of DBNAME_YYYYMMDDNNNNNN.trn where NNNNNN is some sort of sequence number. The files that are being skipped are in the format DBNAME_Backup_YYYY_MM_DD_HHMMSS.trn. The files have valid transations in them meaning the LSNs are in the correct order.
Why is the restore job skipping files NOT following the naming convention DBNAME_YYYYMMDDNNNNNN.trn?
Kind Regards,
-Andy
July 23, 2012 at 12:10 pm
Andrew Cruz-Moores (7/23/2012)
Greetings All!I have log shipping configured between a primary and secondary server. The secondary server will not restore files if they are not in the files name is not in the format of DBNAME_YYYYMMDDNNNNNN.trn where NNNNNN is some sort of sequence number. The files that are being skipped are in the format DBNAME_Backup_YYYY_MM_DD_HHMMSS.trn. The files have valid transations in them meaning the LSNs are in the correct order.
NNNNNN is not a sequence number. It's a timestamp of a sort. Look at it as military hours, minutes, seconds.
Why is the restore job skipping files NOT following the naming convention DBNAME_YYYYMMDDNNNNNN.trn?
Because those other backups are not in the same backup log chain as the ones being used by the log shipping. The first naming convention is used by automated SQL Server backups created through the maintenance plan or third party SQL backup tools like Litespeed.
The second naming convention smacks of a backup plan manually scripted out in T-SQL then run as a job or run through the GUI. Hence those backups are not in the same backup / restore chain as the others.
EDIT: FYI, You are making a huge (and incorrect) assumption about valid transactions and LSNs. The two have nothing to do with each other.
July 24, 2012 at 7:23 am
What is the restore code on the secondary server? Sounds like the code is setup to filter on a file name and would need to be changed to restore any .trn files.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy