SQL Server Errors or Failures from Error: 5055 to Error: 5074



Error: 5055, Severity: 16, Cannot add, remove, or modify file ‘%.*ls’. The file is read-only.
Error: 5056, Severity: 16, Cannot add, remove, or modify a file in filegroup ‘%.*ls’ because the filegroup is not online.
Error: 5057, Severity: 16, Cannot add, remove, or modify file ‘%.*ls’ because it is offline.
Error: 5058, Severity: 16, Option ‘%.*ls’ cannot be set in database ‘%.*ls’.
Error: 5059, Severity: 16, Database ‘%.*ls’ is in transition. Try the ALTER DATABASE statement later.
Error: 5060, Severity: 10, Nonqualified transactions are being rolled back. Estimated rollback completion: %d%%.
Error: 5061, Severity: 16, ALTER DATABASE failed because a lock could not be placed on database ‘%.*ls’. Try again later.

Error: 5062, Severity: 16, The option “%.*ls” conflicts with another requested option. The options cannot both be requested at the same time.
Error: 5063, Severity: 16, Database ‘%.*ls’ is in warm standby. A warm-standby database is read-only.
Error: 5064, Severity: 16, Changes to the state or options of database ‘%.*ls’ cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
Error: 5065, Severity: 16, The file “%ls” is currently being scanned or used by a background or user process. Try the operation again later.
Error: 5066, Severity: 16, Database options single user and dbo use only cannot be set at the same time.
Error: 5067, Severity: 16, The database option TORN_PAGE_DETECTION is incompatible with the PAGE_CHECKSUM option.

Error: 5068, Severity: 10, Failed to restart the current database. The current database is switched to master.
Error: 5069, Severity: 16, ALTER DATABASE statement failed.
Error: 5070, Severity: 16, Database state cannot be changed while other users are using the database ‘%.*ls’
Error: 5071, Severity: 16, Rebuild log can only specify one file.
Error: 5072, Severity: 16, ALTER DATABASE failed. The default collation of database ‘%.*ls’ cannot be set to %.*ls.
Error: 5073, Severity: 16, Cannot alter collation for database ‘%ls’ because it is READONLY, OFFLINE, or marked SUSPECT.
Error: 5074, Severity: 16, The %S_MSG ‘%.*ls’ is dependent on %S_MSG ‘%.*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.

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 *