Database 'model' transaction logs are full and I can't start SQL...
Posted on 2010-08-31
SQL will start right now and then stop about 3 seconds after and I see the following entry in the event viewer:
The transaction log for database 'model' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
However, I can't go into the management studio or anything because it's won't allow it to start long enough for me to connect. How can I empty the transaction logs for 'model' without being in SQL management studio to run a query?
This is SQL 2005 by the way...