|
Home > Archive > Microsoft SQL Server forum > September 2005 > How to check Backup of SQL Server Database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to check Backup of SQL Server Database
|
|
| ikosianski@gmx.net 2005-09-29, 7:24 am |
| Hallo,
MSDB.dbo.BackupSet 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
| |
| Uri Dimant 2005-09-29, 7:24 am |
| Lookup backupset system table that stored in msdb
<ikosianski@gmx.net> wrote in message
news:1127985458.676707.120340@g43g2000cwa.googlegroups.com...
> Hallo,
>
> MSDB.dbo.BackupSet 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
>
| |
| Simon Hayes 2005-09-29, 7:24 am |
| 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.LastRunOutcome 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
| |
| ikosianski@gmx.net 2005-09-30, 11:23 am |
| Thanks Uri,
Backupset has not information about status of backup.
| |
| ikosianski@gmx.net 2005-09-30, 11:23 am |
| 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
|
|
|
|
|