Skip to content

Latest commit

 

History

History
37 lines (30 loc) · 1.61 KB

mssqlserver-18264-database-engine-error.md

File metadata and controls

37 lines (30 loc) · 1.61 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
MSSQLSERVER_18264
MSSQLSERVER_18264
MashaMSFT
mathoma
04/04/2017
sql
supportability
reference
18264 (Database Engine error)

MSSQLSERVER_18264

[!INCLUDE SQL Server]

Details

Attribute Value
Product Name Microsoft SQL Server
Event ID 18264
Event Source MSSQLENGINE
Component SQLEngine
Symbolic Name STRMIO_DBDUMP
Message Text Database backed up. Database: %s, creation date(time): %s(%s), pages dumped: %d, first LSN: %s, last LSN: %s, number of dump devices: %d, device information: (%s). This is an informational message only. No user action is required.

Explanation

By default, every successful backup adds this informational message to the [!INCLUDEssNoVersion] error log and the system event log. If you very frequently back up the transaction log, these messages can accumulate quickly, creating very large error logs that can make finding other messages difficult.

User Action

You can suppress these log entries by using [!INCLUDEssNoVersion] trace flag 3226. Enabling this trace flag is useful if you are running frequent log backups and if none of your scripts depend on those entries.

For information about using trace flags, see SQL Server Books Online.

See Also

Trace Flags (Transact-SQL)