SQL Server Errors or Failures from Error: 9016 to Error: 9207

SQLServerF1

 

Error: 9016, Severity: 21, An error occurred while processing the log for database ‘%.*ls’. The log block could not be decrypted.
Error: 9017, Severity: 10, 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.
Error: 9018, Severity: 16, The log for database ‘%ls’ does not allow user writes.
Error: 9019, Severity: 21, The virtual log file sequence 0x%08x at offset 0x%016I64x bytes in file ‘%ls’ is active and cannot be overwritten with sequence 0x%08x for database ‘%ls’.

Error: 9020, Severity: 16, The log for database ‘%ls’ failed to grow while shrink in progress. Please retry.
Error: 9021, Severity: 16, Cannot accept virtual log file sequence 0x%08x for database ‘%ls’ because file %d does not exist yet.
Error: 9022, Severity: 14, The log can not be initialized because the log files are not fully formatted.
Error: 9023, Severity: 16, The log for database ‘%ls’ cannot be shrunk until all secondaries have moved past the point where the log was added..
Error: 9100, Severity: 23, Possible index corruption detected. Run DBCC CHECKDB.
Error: 9101, Severity: 16, auto statistics internal
Error: 9104, Severity: 16, auto statistics internal
Error: 9105, Severity: 16, The provided statistics stream is corrupt.

Error: 9106, Severity: 16, Histogram support not allowed for input data type 0x%08x.
Error: 9107, Severity: 16, The name, ‘%.*ls’, is invalid. The suffix ‘_readonly_database_statistic’ is reserved. Select another name without using the reserved suffix.
Error: 9201, Severity: 10, %d active query notification subscription(s) in database ‘%.*ls’ owned by security identification number ‘%.*ls’ were dropped.
Error: 9202, Severity: 16, The query notification subscription message is invalid.
Error: 9204, Severity: 16, The query notification subscription timeout is invalid. The allowed range is 1 through 2147483647.
Error: 9205, Severity: 16, User “%.*ls” does not have permission to request query notification subscriptions on database “%.*ls”.
Error: 9206, Severity: 16, The query notification subscription “%ld” cannot be deleted because it does not exist or it has already been fired.
Error: 9207, Severity: 10, The query notification dialog on conversation handle ‘%.*ls’ closed due to the following error: ‘%.*ls’.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *