October 21, 2008 at 11:37 pm
Hi Gurus,
I'm collecting backup history for my user databases then i notice on one server that the no backup info was recorded in MSDB database but in errorlog shows that the backup was successully taken.
Pls advise how is this possible. Is there a way to collect the backup history without looking into the errorlog.
Thanks,
Art
October 22, 2008 at 4:55 am
No history at all for any databases on the server ? It is possible to delete the backup history. Perhaps someone did ?
October 22, 2008 at 5:26 am
Hi,
Check how the job history has been configured. In SSMS right click on the SQL Server Agent node and select Properties, then click the History tab.
Hope that helps.
Cath
October 22, 2008 at 11:23 pm
System database backup can be found. Any comments? Nobody has deleted any rows on msdb.
October 23, 2008 at 2:17 am
Have you checked the Agent Properties yet? If you know for sure that no-one has deleted anything from msdb and you have the correct permissions to view job history (you do don't you?) then it would be logical to assume the history data were never there, or there very briefly. Checking the history tab on Agent Properties will tell you if that assumption is right.
October 23, 2008 at 10:13 am
Art (10/22/2008)
Nobody has deleted any rows on msdb.
How can you tell for sure? In SQL Server 2005, there's a sp_delete_database_backuphistory stored procedure, that can be used to delete backup/restore history for specific databases.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply