We help IT Professionals succeed at work.

Why has the ASPNet database log file grown dramatically and can it be set to simple recovery mode?

Sue_W asked
Last Modified: 2008-04-24
Okay, I don't know where to ask this so I am going to ask in a couple of places.

We are using ASPState database to store session information for our asp.net 1.1 application. I noticed that the log file for this database has grown to an eye-whopping 102 gigabytes. I want to shrink and truncate the log file but I don't understand why this database is running in full recovery mode or why the log file has grown this large.

Can someone tell me if you can change the database to simple recovery mode since it is used to store session state information?

Watch Question

The log will grow until it is backed up.

The limitation to simple recovery mode is that you lose point-in-time restore. If you don't need to restore or restore to last backup is adequate, then simple recovery is fine.
This one is on us!
(Get your first solution completely free - no credit card required)

exec sp_dboption 'historictitle', 'trunc. log on chkpt.', 'true'

"historictitle" = change to name of your database
Forced accept.

EE Admin
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.