The Transaction Log For Database ‘model’ Is Full

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s