March 6, 2019 at 3:39 pm
Hello Folks,
We have a SQL Server 2005 box (well, please don't ask why... 🙁 ). Since last week, I have observed that the Maintenance Backup jobs (both log and full), does not log information into the backupset table in msdb. I also tried running the backup command manually, but with same effect.
Has anyone experienced this before ?
Thanks in advance ..
March 6, 2019 at 6:21 pm
Nishith-121814 - Wednesday, March 6, 2019 3:39 PMHello Folks,
We have a SQL Server 2005 box (well, please don't ask why... 🙁 ). Since last week, I have observed that the Maintenance Backup jobs (both log and full), does not log information into the backupset table in msdb. I also tried running the backup command manually, but with same effect.
Has anyone experienced this before ?Thanks in advance ..
Does the backup file exist in the destination that was specified on the backups? Are the backups being logged as successful to the SQL Server error log?
Sue
March 6, 2019 at 8:26 pm
Yes, latest backups files are present and backups areb also logged as success. I am also able to read and verify the backup files with current timestamp
March 7, 2019 at 2:06 pm
Nishith-121814 - Wednesday, March 6, 2019 8:26 PMYes, latest backups files are present and backups areb also logged as success. I am also able to read and verify the backup files with current timestamp
So does the following list the correct server, database names and last backups are all from last month? SELECT server_name, database_name, max(backup_finish_date) as LastBackup
FROM msdb.dbo.backupset
GROUP BY server_name, database_name
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply