Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Maintenance Plan

Author  Topic 

cipriani1984
Constraint Violating Yak Guru

304 Posts

Posted - 2014-02-11 : 05:55:45
Hi,

I have a maintenance plan that:

- backs up all db's on server
- backups all transaction logs on server

until recently it was all working fine, Ive checked the logs on sql and it complains that the recovery mode is set to simple. Ive checked blogs online and it says that it wouldn't be an issue as the use of a maintenance plan by passes the recovery mode being set to simple.

Any reason why this would happen? Any ideas on how to support simple recovery mode on maintenance plan backups?

many thanks
   

- Advertisement -