By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,119 Members | 2,086 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,119 IT Pros & Developers. It's quick & easy.

SQL server 2005 error id 8309

P: n/a
Microsoft SQL 2005

Event id: 8309

Event Description:
BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically truncate the transaction log.

After changed all database recovery mode to simple, restart the SQL server, restart SQL server agent, changed user permission, the error 8309 still occur, please advice, thanks..
Oct 18 '10 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 2,878
Here, read this...

Good Luck!!!

~~ CK
Oct 18 '10 #2

P: n/a
Tried, still the same
Oct 19 '10 #3

Expert Mod 15k+
P: 31,615
Tried, still the same
Give us a clue what you tried. I read the linked article and I can say it's not so simple that your response makes any sense. Did you try the bit where the author says "I don't recommend this. It's just for illustration."?

Please post something that makes sense and shows you've actually attempted to do something before requesting more help.
Oct 19 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Browse more Microsoft SQL Server Questions on Bytes