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?