Shahrukh Khan (2/14/2009)
Hi,
When I check the SQL Server error logs, there is an error message "SQL Server log is deprecated". Eventhough there is a maintenance plan to back up the log, the log is not being backed up. Any thoughts???
Thank you,:)
Can you give us more information on this? Can you query msdb and see what was the last backup job performed?
Can u check you recovery model and see whether it is still in Full Recovery? What steps have you taken after noticing this?
Adding to this: Can you post your Tlog backup statements? may be you are using NO_LOG or TRUNCATE_ONLY option, which you should not while database is in Full Recovery model as this will break your log chain. Probably this could be the reason why your Tlog has been deprecated