How to check Backup of SQL Server Database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ikosianski@gmx.net
    #1

    How to check Backup of SQL Server Database

    Hallo,

    MSDB.dbo.Backup Set logs all backups
    is it possible find Status of Backup (Success / Failed)?
    Table "BackupSet" hasn't any information about it.

    I need log and notify all backups with status
    (It must be a windows service (c#)

    Thanks

    Tags: None
    • Uri Dimant
      #2
      Re: How to check Backup of SQL Server Database

      Lookup backupset system table that stored in msdb



      <ikosianski@gmx .net> wrote in message
      news:1127985458 .676707.120340@ g43g2000cwa.goo glegroups.com.. .[color=blue]
      > Hallo,
      >
      > MSDB.dbo.Backup Set logs all backups
      > is it possible find Status of Backup (Success / Failed)?
      > Table "BackupSet" hasn't any information about it.
      >
      > I need log and notify all backups with status
      > (It must be a windows service (c#)
      >
      > Thanks
      >[/color]


        Comment

        • Simon Hayes
          #3
          Re: How to check Backup of SQL Server Database

          As far as I know, the backupset table only has successful backups (if
          the backup wasn't successful, there wouldn't be a backup set). But I
          guess what you should be looking at is the success/failure of the
          scheduled job that backs up the database - you can check the
          Job.LastRunOutc ome property using DMO (SQL2000, COM) or SQL 2005 (SMO,
          ..NET). Alternatively, you could have the job raise an alert and/or run
          a job if it fails, rather than polling it yourself.

          If a backup fails, it should be logged in the SQL Server error log and
          the Windows event log, so you could check either of them. The DMO/SMO
          ReadErrorLog() method can be used for the SQL Server log.

          Finally, there are plenty of third party monitoring tools available for
          MSSQL, so if you need something only for your own organization, it may
          be worth looking at the cost of buying versus the cost of developing
          and maintaining your own solution.

          Simon

            Comment

            • ikosianski@gmx.net
              #4
              Re: How to check Backup of SQL Server Database

              Thanks Uri,
              Backupset has not information about status of backup.

                Comment

                • ikosianski@gmx.net
                  #5
                  Re: How to check Backup of SQL Server Database

                  Thanks, Simon,
                  during backup I click to break it, but the new line is coming into
                  backupset.
                  EventLog has the information about failed backup, but I cannot identify
                  the special backup with his status
                  I will see DMO

                    Comment

                    Previous template Next
                    Working...