MSSQLSERVER_18264
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Details
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.