03-26-2003 06:32 AM - edited 03-12-2019 11:13 PM
Is anyone familiar with this Application log error on a Unity server?
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 3/26/2003
Time: 2:00:00 AM
Description:
18278 :
Database log truncated: Database: UnityDb.
Solved! Go to Solution.
03-26-2003 08:27 AM
That'll happen when the transaction log is truncated without being backed up first. Several things can cause that I'm sure... you could have a space issue - SQL will proactively truncate the logs to prevent running out of space. You could have a process (scheduled job, external backup app etc...) issuing commands to do backups and/or truncate logs (i.e. if you have your recovery mode set to "SIMPLE" it'll truncate logs when backups are issued - you want FULL in most cases).
You can wander around in the logs in SQL Enterprise manager around that time and see if you see anything interesting looking around that time - under the "Management" folder under your SQL server in enterprise manager look under SQL Server Logs - you should be able to open that days looks and have a peek at what might have been happening around that time.
03-26-2003 08:27 AM
That'll happen when the transaction log is truncated without being backed up first. Several things can cause that I'm sure... you could have a space issue - SQL will proactively truncate the logs to prevent running out of space. You could have a process (scheduled job, external backup app etc...) issuing commands to do backups and/or truncate logs (i.e. if you have your recovery mode set to "SIMPLE" it'll truncate logs when backups are issued - you want FULL in most cases).
You can wander around in the logs in SQL Enterprise manager around that time and see if you see anything interesting looking around that time - under the "Management" folder under your SQL server in enterprise manager look under SQL Server Logs - you should be able to open that days looks and have a peek at what might have been happening around that time.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide