|
Posted by info on 10/02/49 11:59
I found that my transaction log backup jobs fails because the Recover
Mode of the database is set to SIMPLE. Its always been set to FULL.
Its not MSDB, its a user defined database so thats not it.
Any ideas and also how could I audit this? is it in Event Log or SQL
Logs?
I know there is a SQL Agent script I can run on restart of service but
I'd rather know why this is happening.
We do only file backups , not Backup Exec SQL Agent jobs.
Thanks
Erik
Navigation:
[Reply to this message]
|