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?