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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2008-01-15 : 14:36:30
|
| Has anyone encounterd this message in the sql log:-----BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically truncate the transaction log.-----DB's are in simple recovery mode and only a daily backup is being done on DB's. It almost seems that SQL is doing something internally.thanks |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-01-15 : 16:28:45
|
| Almost, but I have multiple databases in Simple recovery mode, and I do not have these messages in any of my logs. i suspect you have an application that is attempting to be helpful. Start with any application that has DBO access to their own database, or run a profiler trace to see if you can pick up what application is doing this. |
 |
|
|
|
|
|
Message in SQL log