Solved

SQL 2005 Error

Posted on 2009-04-02
5
782 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

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 …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
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…

828 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