repent_kog_is_near
SSCertifiable
Points: 7278
More actions
March 24, 2010 at 8:31 pm
#142203
Is the info of the last original Full backup and it's TL backup links in sequence available in any of the system tables for us to see how many TL backups are done, what names they are stored and where they are stored on disk?
Dan
Jeffrey Williams
SSC Guru
Points: 90303
March 24, 2010 at 10:02 pm
#1139384
Backup history is stored in the system tables in MSDB. Look in the backup* tables in that database to find the information you are looking for.
Jeffrey Williams“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers fasterManaging Transaction Logs
March 25, 2010 at 6:32 am
#1139551
backupset has it. Thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply