Error: MSSQLSERVER What does this mean?

[d.anthony.hadley_2]

I keep getting this error every so often on a Unity 3.1.5 server. What does it mean exactly? Is it serious? What do I do about it?

Event Type: Error

Event Source: MSSQLSERVER

Event Category: (6)

Event ID: 17055

Date: 6/20/2003

Time: 2:00:00 AM

User: "Domain-name"\administrator

Computer: USFL09VM03

Description:

18278 :

Database log truncated: Database: UnityDb.

Data:

0000: 66 47 00 00 10 00 00 00 fG......

0008: 0b 00 00 00 55 00 53 00 ....U.S.

0010: 46 00 4c 00 30 00 39 00 F.L.0.9.

0018: 56 00 4d 00 30 00 33 00 V.M.0.3.

0020: 00 00 08 00 00 00 55 00 ......U.

0028: 6e 00 69 00 74 00 79 00 n.i.t.y.

0030: 44 00 62 00 00 00 D.b...

[bbaldwin]

There are 2 SQL 'agents' that backup database transaction logs for Unity.

One runs on a nightly basis and the other on a weekly basis (on Sundays).

It's possible the first week before the weekly agent job completes that real error events will show up in the application log - these will be replaced by the 'error' events reported above after the weekly job runs and the nightly job has something to back up to.

Otherwise, this is reporting success with truncating the db log, which SQL happens to throw as an 'Error' Event Type.

[d.anthony.hadley_2]

The errors are followed by the information event below. Does this mean that it is the latter explanation and there nothing wrong?

Event Type: Information

Event Source: MSSQLSERVER

Event Category: (6)

Event ID: 17055

Date: 6/23/2003

Time: 2:00:02 AM

User: "Domain"\administrator

Computer: USFL09VM04

Description:

18270 :

Database differential changes backed up: Database: UnityDb, creation date(time): 2002/11/20(09:05:50), pages dumped: 777, first LSN: 3395:487:1, last LSN: 3395:489:1, full backup LSN: 3392:1017:3, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'UnityDbDump'}).

Data:

0000: 5e 47 00 00 0a 00 00 00 ^G......

0008: 0b 00 00 00 55 00 53 00 ....U.S.

0010: 46 00 4c 00 30 00 39 00 F.L.0.9.

0018: 56 00 4d 00 30 00 34 00 V.M.0.4.

0020: 00 00 07 00 00 00 6d 00 ......m.

0028: 61 00 73 00 74 00 65 00 a.s.t.e.

0030: 72 00 00 00 r...

[bbaldwin]

That's correct - these are expected events wrt SQL agents installed by Unity.