CODEWITHSUNDEEP
sql-server
sri ram
sri ram

Reputation: 21

Exclude db in simple recovery mode from t-log backup

We have a T-log Maintenance plan for few databases. One of the database "ABC" in simple recovery mode. Our maintenance plan fails with the error "Database ABC will not be backed up because it does not have recovery mode set to full or bulk"

Please help me fix this issue without changing ABC database to full recovery mode

Version: SQL Server 2005 standard edition SP2

Upvotes: 1

Views: 178

Answers (1)

sri ram
sri ram

Reputation: 21

Sorry i resolved the issue on my own.... I excluded this db from MP by changing the db to full-recovery mode .....I cant believe i wasted 3 hours on this :(

Upvotes: 1

Related Questions