MSSQLSERVER_18264

Applies to: 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 SQL Server 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 SQL Server 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)