August 17, 2010 at 3:52 am
IS there any way or sys tables where we can check whether database is scheduled in backup operation.
August 17, 2010 at 10:14 am
diva.mayas (8/17/2010)
IS there any way or sys tables where we can check whether database is scheduled in backup operation.
Check msdb.dbo.backupset - should contain one row per backup operation.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 18, 2010 at 9:47 am
i get from backupset but how to find in scheduled jobs ?Is there any way to find through T-sql
August 18, 2010 at 10:31 am
diva.mayas (8/18/2010)
i get from backupset but how to find in scheduled jobs ?Is there any way to find through T-sql
Problem is, you wouldn't know the name of the job which makes kind of difficult to figure it out if any of the scheduled jobs is doing the backup you are looking for.
If you query msdb.dbo.backupset ( via T-Sql ) you will know not only backups are taken but also the status of each one of them - including the last one.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply