9017

Product

Name

Event ID

9017

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

LOG_MANY_VLFS

Message

Text

Database %ls has more than %d virtual log files which is excessive. Too many virtual log files

can cause long startup and backup times. Consider shrinking the log and using a different

growth increment to reduce the number of virtual log files.

During a database startup, SQL Server detects that a database has a large number of

virtual log

files

(VLFs) and logs this error message. The situations where you can encounter the error are:

When you start an instance of SQL Server

Restore a database

Attach a database

The 9017 informational message that is similar to this example is logged in the SQL Server error

log:

ﾉ

Expand table

Database dbName has more than n virtual log files which is excessive. Too many virtual log files can cause long startup and backup times. Consider shrinking the log and using a different growth increment to reduce the number of virtual log files. Too many virtual log files can adversely affect the recovery time of the database.