SQL Server Errors or Failures from Error: 8995 to Error: 9015

SQLServerF1

 

Error: 8995, Severity: 16, System table ‘%.*ls’ (object ID %d, index ID %d) is in filegroup %d. All system tables must be in filegroup %d.
Error: 8996, Severity: 16, IAM page %S_PGID for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) controls pages in filegroup %d, that should be in filegroup %d.
Error: 8997, Severity: 16, Service Broker Msg %d, State %d: %.*ls
Error: 8998, Severity: 16, Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID %d pages from %S_PGID to %S_PGID. See other errors for cause.

Error: 8999, Severity: 10, Database tempdb allocation errors prevent further %ls processing.
Error: 9001, Severity: 21, The log for database ‘%.*ls’ is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Error: 9002, Severity: 17, The transaction log for database ‘%ls’ is full due to ‘%ls’.
Error: 9003, Severity: 20, The log scan number %S_LSN passed to log scan in database ‘%.*ls’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication.
Error: 9004, Severity: 21, An error occurred while processing the log for database ‘%.*ls’. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

Error: 9005, Severity: 16, Either start LSN or end LSN specified in OpenRowset(DBLog, …) is invalid.
Error: 9006, Severity: 10, Cannot shrink log file %d (%s) because total number of logical log files cannot be fewer than %d.
Error: 9007, Severity: 10, Cannot shrink log file %d (%s) because requested size (%dKB) is larger than the start of the last logical log file.
Error: 9008, Severity: 10, Cannot shrink log file %d (%s) because the logical log file located at the end of the file is in use.
Error: 9009, Severity: 10, Cannot shrink log file %d (%s) because of minimum log space required.
Error: 9010, Severity: 14, User does not have permission to query the virtual table, DBLog. Only members of the sysadmin fixed server role and the db_owner fixed database role have this permission
Error: 9011, Severity: 14, User does not have permission to query backup files with the virtual table DBLog. Only members of the sysadmin fixed server role has this permission
Error: 9012, Severity: 10, There have been %d misaligned log IOs which required falling back to synchronous IO. The current IO is on file %ls.
Error: 9013, Severity: 10, The tail of the log for database %ls is being rewritten to match the new sector size of %d bytes. %d bytes at offset %I64d in file %ls will be written.
Error: 9014, Severity: 21, An error occurred while processing the log for database ‘%ls’. The log block version %d is unsupported. This server supports log version %d to %d.
Error: 9015, Severity: 24, The log record at LSN %S_LSN is corrupted.
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 *