August 28, 2012 at 4:13 am
any one help on this
August 28, 2012 at 4:15 am
query msdb.dbo.backupset
August 28, 2012 at 4:19 am
pls send the query .
August 28, 2012 at 4:21 am
You will need to provide more details that what you have posted already to get a query.
What is the goal? What do you want to see?
SELECT * FROM MSDB.dbo.BackupSet WHERE .............
August 28, 2012 at 4:27 am
as the jobs are failing on weekends we need to investiagte the backup start time and end time of the last 3 months .
August 28, 2012 at 4:34 am
Well msdb.dbo.backupset wont help you as that is successfull backups. It is always good to say what you are trying to acheive first.
You will need to look through the job history of the jobs and find the error codes, that is if the job history still exists in MSDB.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply