Backup of SQL instances

  • Hi

    Can any one help me in listing the failed backup dbs under a SQL Server Group of Enterprise manager? A SQL Server group would be having around 300 to 700 dbs.

    Thanks, Siva T

  • What are you trying to do? If you want to be notified when the backup fails, you can use Notifications table in job definition to send email, net send message or page an operator. Otherwise you probably will have to query table msdb..sysjobhistory on every server to find out the status of the jobs.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply