Solved

SQL 2005 Error

Posted on 2009-04-02
5
783 Views
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?

0
Comment
Question by:Boze19130
  • 2
  • 2
5 Comments
 
LVL 12

Expert Comment

by:udaya kumar laligondla
ID: 24056169
this explains why the log is full and how to handle the situation http://support.microsoft.com/kb/317375
0
 
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.
0
 
LVL 3

Author Comment

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

Accepted Solution

by:
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.
0
 
LVL 3

Author Closing Comment

by:Boze19130
ID: 31566000
Thanks!
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…

749 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