Solved

Database 'model' transaction logs are full and I can't start SQL...

Posted on 2010-08-31
1
294 Views
Last Modified: 2012-06-22
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...
0
Comment
Question by:willlandymore
1 Comment
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 33568383
The "Model" database is what SQL Server uses as the baseline for creating new databases - it doesn't have any actual data in it. If you have another copy of SQL Server elsewhere on your network (as long as it's the same version or lower), you can just replace the model.MDF and model.LDF files with the ones from the other server, and then SQL should start without a problem.

If you don't have another SQL Server instance handy, you'll need to rename the log file, then start SQL Server (which will flag the model database as "Suspect", since the log is missing). Once it does that, you can ask SQL Server to recreate the log file from scratch. See this link for instructions on recreating a log file when it's missing:

http://www.tech-recipes.com/rx/1867/sql_server_2005_how_to_attach_or_reattach_a_database_missing_the_ldf/
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now