Link to home
Start Free TrialLog in
Avatar of badrhino
badrhinoFlag for United States of America

asked on

Log Error SQL Server 2008

I'm getting an error that I'm not undersanding.  The error is:
Msg 9002, Level 17, State 4, Line 5
The transaction log for database 'database' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

This is where my question begins.  The database is set to simple recovery, I'm not using any commit or rollback statements.  When I go to tasks>Shrink>files and select Log I've only have 1% (log file is restricted at 50mb) available.  It is a samll databse, being used for development and I'm using a lot of delete and drop table statements.

I obviously can keep bumping the file size up and get rid of this error, but I was under the impersion when the database is set to simple recovery, the database did not log.  

I don't care about the log files, so how do I sql from logging on this database?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Rich Weissler
Rich Weissler

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Please post the output from this statement:

SELECT
    compatibility_level, log_reuse_wait_desc, state_desc, snapshot_isolation_state_desc,
    recovery_model_desc
FROM
    sys.databases
WHERE
    name = '<your_db_name>'
Avatar of badrhino

ASKER

compatibility_level:100
log_reuse_wait_desc: Nothing
state_desc: Online
snapshot_isolation_state_desc: Off      
recovery_model_desc:  SIMPLE
      
Thanks!