Database file differential changes backed up: Database: %1, creation date(time): %2(%3), file list: (%4), pages dumped: %5!d!, number of dump devices: %8!d!, device information: (%9).

Details
Product: SQL Server
Event ID: 18276
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Database file differential changes backed up: Database: %1, creation date(time): %2(%3), file list: (%4), pages dumped: %5!d!, number of dump devices: %8!d!, device information: (%9).
   
Explanation
This informational message indicates that a database file differential backup has completed successfully. This message is written to the application event log and the SQL Server error log every time a backup completes.
   
User Action
  • If the message is filling up your application Event Viewer logs, you can change properties of the log by setting the “Maximum log size” or choosing a different option under “When maximum log size is reached”.
  • If the message is causing your SQL Server error log to grow too large, you can execute the sp_cycle_errorlog stored procedure to create a new log. For more information about how to increase the number of SQL Server error logs retained, see the Microsoft Knowledge Base article 196909.
  • You can enable the trace flag 3226. This trace flag will prevent all informational BACKUP and RESTORE messages from being written to the SQL Server error log and to the NT application event log. Informational BACKUP and RESTORE messages include 18264, 18265, 18266, 18267, 18268, 18269, 18270, 18271, 18276, and 18277. Be aware that alerts for BACKUP and RESTORE informational messages will no longer fire, since they rely on an entry in the NT application event log. For detailed instructions on how to enable a trace flag with the -T startup option, see “Using Startup Options” in Books Online.

Related:

Leave a Reply