SQL 2005 Error

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?

LVL 3
Boze19130Asked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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
 
udaya kumar laligondlaTechnical LeadCommented:
this explains why the log is full and how to handle the situation http://support.microsoft.com/kb/317375
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
Boze19130Author Commented:
So I am a newb to SQL... Can you explain how to to do this?
0
 
Boze19130Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.