Sunday, February 12, 2012

Backup Transaction Log - Event ID 17055

I recently changed the recovery model from simple to full on a specific SQL
Server 2000 database. I am backing up the transaction log every two hours
via a maintenance plan. I have other SQL Server 2000 DB's defined with the
full recovery model and do not receive these messages. The following error,
not a warning, appears in the application event log when the log backup
completes also in the database log. Are these backups valid? Found KB
818202 on this, but I cannot determine what action needs to be taken, if any.
Thoughts??
Source: MSSQLSERVER
Category: (6)
Event ID: 17055
Description: 18278 Database log truncated: Database: dbname.
Hi,
Can you perform a full database backup and then follow the transaction log
backup.
This is required when you change the recovery model from SIMPLE to FULL
Thanks
Hari
MCDBA
"paldba" wrote:

> I recently changed the recovery model from simple to full on a specific SQL
> Server 2000 database. I am backing up the transaction log every two hours
> via a maintenance plan. I have other SQL Server 2000 DB's defined with the
> full recovery model and do not receive these messages. The following error,
> not a warning, appears in the application event log when the log backup
> completes also in the database log. Are these backups valid? Found KB
> 818202 on this, but I cannot determine what action needs to be taken, if any.
> Thoughts??
> Source: MSSQLSERVER
> Category: (6)
> Event ID: 17055
> Description: 18278 Database log truncated: Database: dbname.
|||Yes, that has been completed.
"Hari Prasad" wrote:
[vbcol=seagreen]
> Hi,
> Can you perform a full database backup and then follow the transaction log
> backup.
> This is required when you change the recovery model from SIMPLE to FULL
> Thanks
> Hari
> MCDBA
> "paldba" wrote:

No comments:

Post a Comment