Today I have received the following error in a SQL Server 2005 database;
The transaction log for database ‘model’ is full. To find out why space in the log can not be reused, see the column in sys.databases log_reuse_wait_desc
This error gives when I try to start the service, so the database do not get start up. The problem seems to be in the transaction log of the model database, which will be in full recovery mode.
To start the database use the following command from a cmd, and we put a trace flag.
NET START MSSQLPXDSAP / T3609
Let us start the database but in a way very limited work.
The problem is that the transaction log can not grow because it limited its maximum size, an option is to remove the restriction, the other is to do a backup with truncate the log option, I chose the latter, although in the future may repeat the problem, so I put the model database in SIMPLE recovery mode. I stop and start the service again without trace flag;
NET STOP MSSQLPXDSAP
NET START MSSQLPXDSAP
HTH – Antonio NAVARRO