?
Solved

SQL 2005 Error

Posted on 2009-04-02
5
Medium Priority
?
793 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 2000 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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…
Integration Management Part 2
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

839 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