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.
| Author |
Topic |
|
petek
Posting Yak Master
192 Posts |
 Posted - 2009-01-26 : 03:17:23
|
| Hi all,A strange one, one of my databases’ fails its transaction log backup every so often. After investigating the issue the database recovery is set to simple hence it failing the jobs.I don’t understand why this happens as I don’t change it, as its not changed manually. I don’t understand why its changed automatically. In the event log it just says:‘Setting database option RECOVERY to SIMPLE for database db1.’Any ideas?Kind RegardsPete. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-26 : 12:09:29
|
| SQL won't change the recovery model automatically. There's some code somewhere that's changing it. Check the jobs that run around the same time as the change happens. It won't be the first time I've heard of a reindex job that set the DB to simple recovery before running.--Gail ShawSQL Server MVP |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-01-26 : 14:44:13
|
| We had a "dba" who was of the opinion that our database should have been set to FULL recovery even though we only needed it to be simple. You could have a reverse case here as well. A co worker with a differing opinion.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
Database revcovery.