• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 702
  • Last Modified:

SQL Error

hi there

I have been getting a error in the event logs under application for Sql server. The error message is below

Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (6)
Event ID:      17055
Date:            11/20/2006
Time:            2:14:08 AM

Description:
18278 :
Database log truncated: Database: MMA.

can someone tell what needs to be done to resolve this issue





0
kadiyalav
Asked:
kadiyalav
1 Solution
 
NightmanCTOCommented:
A "Database log truncated" error is logged in the Event Log when you try to back up the transaction log with either a NO_LOG or TRUNCATE_ONLY option when a database is in the full recovery model.

http://support.microsoft.com/kb/818202

To resolve, don't use NO_LOG or TRUNCATE_ONLY options. This puts you at risk anyway - if you don't care, consider switching to simple recovery model (although personally I would never do this for a production server)
0
 
MrNeticCommented:
kadiyalav,

Atention, if you are doing TrnLog Backups or Log shipping, consider review you production environment.

Related to you question, Nightman gave all the answers.

Best Regards,

Paulo Conde├ža
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now