SQL 2005 Error

Posted on 2009-04-02
Last Modified: 2012-06-21
I am getting this error and it won't allow me to successfully run my maintenance plan.  Here is the error:

"The transaction log for the database 'NSMRulestat' is full.  To find out why space in the log cannot be reused, see the log_reused, see the log_reuse_wait_desc column in sys.databases"

I can't even find this database.  Any suggestions?

Question by:Boze19130
  • 2
  • 2
LVL 12

Expert Comment

ID: 24056169
this explains why the log is full and how to handle the situation
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24056243
To get it resolved, Take a Full backup of NSMRulestat database and then issue the following statements:

backup log NSMRulestat with truncate_only;
dbcc shrinkfile ('NSMRulestat_Log', 1000)

This would do.

Author Comment

ID: 24059761
So I am a newb to SQL... Can you explain how to to do this?
LVL 57

Accepted Solution

Raja Jegan R earned 500 total points
ID: 24068162
Open SQL Server Management Studio and run the following commands:

backup log NSMRulestat with truncate_only;
dbcc shrinkfile ('NSMRulestat_Log', 1000)

This should help you out.

Author Closing Comment

ID: 31566000

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
passing parameter in sql procedure 9 63
Selection from table2 where criteria for table1 10 43
TSQL mapping detailed records to group records 9 52
convert null in sql server 12 34
In this article I will describe the Copy Database Wizard 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.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

777 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