Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2010-08-31
1
Medium Priority
?
335 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 2000 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Loops Section Overview
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

824 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