SQL Server Errors or Failures from Error: 5010 to Error: 5031



Error: 5010, Severity: 16, Log file name cannot be generated from a raw device. The log file name and path must be specified.
Error: 5011, Severity: 14, User does not have permission to alter database ‘%.*ls’, the database does not exist, or the database is not in a state that allows access checks.
Error: 5012, Severity: 16, The name of the primary filegroup cannot be changed.
Error: 5013, Severity: 16, The master and model databases cannot have files added to them. ALTER DATABASE was aborted.
Error: 5014, Severity: 16, The %S_MSG ‘%.*ls’ does not exist in database ‘%.*ls’.

Error: 5015, Severity: 16, ALTER DATABASE failed. The total size specified must be 1 MB or greater.
Error: 5016, Severity: 16, Cannot change the name of the system database %.*ls.
Error: 5018, Severity: 10, The file “%.*ls” has been modified in the system catalog. The new path will be used the next time the database is started.
Error: 5019, Severity: 10, Cannot find entry in sys.master_files for file ‘%.*ls’.
Error: 5020, Severity: 16, The primary data or log file cannot be removed from a database.
Error: 5021, Severity: 10, The %S_MSG name ‘%.*ls’ has been set.
Error: 5022, Severity: 16, Log file ‘%ls’ for this database is already active.
Error: 5023, Severity: 16, The database must be suspect or in emergency mode to rebuild the log.

Error: 5024, Severity: 16, No entry found for the primary log file in sysfiles1. Could not rebuild the log.
Error: 5025, Severity: 16, The file ‘%ls’ already exists. It should be renamed or deleted so that a new log file can be created.
Error: 5027, Severity: 16, System databases master, model, and tempdb cannot have their logs rebuilt.
Error: 5028, Severity: 16, The system could not activate enough of the database to rebuild the log.
Error: 5029, Severity: 10, Warning: The log for database ‘%.*ls’ has been rebuilt. Transactional consistency has been lost. The RESTORE chain was broken, and the server no longer has context on the previous log files, so you will need to know what they were. You should run DBCC CHE
Error: 5030, Severity: 16, The database could not be exclusively locked to perform the operation.
Error: 5031, Severity: 16, Cannot remove the file ‘%.*ls’ because it is the only file in the DEFAULT filegroup.

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.

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 *