SQL Server Errors or Failures from Error: 5032 to Error: 5054



Error: 5032, Severity: 10, The file cannot be shrunk below page %d until the log is backed up because it contains bulk logged pages.
Error: 5033, Severity: 16, The maximum of %ld files per database has been exceeded.
Error: 5034, Severity: 16, The file %ls is currently being autogrown or modified by another process. Try the operation again later.
Error: 5035, Severity: 16, Filegroup ‘%.*ls’ already exists in this database. Specify a different name or remove the conflicting filegroup if it is empty.
Error: 5036, Severity: 16, MODIFY FILE failed. Specify logical name.
Error: 5038, Severity: 16, MODIFY FILE failed for file “%.*ls”. At least one property per file must be specified.

Error: 5039, Severity: 16, MODIFY FILE failed. Specified size is less than or equal to current size.
Error: 5040, Severity: 16, MODIFY FILE failed. Size is greater than MAXSIZE.
Error: 5041, Severity: 16, MODIFY FILE failed. File ‘%.*ls’ does not exist.
Error: 5042, Severity: 16, The %S_MSG ‘%.*ls’ cannot be removed because it is not empty.
Error: 5043, Severity: 16, The %S_MSG ‘%.*ls’ cannot be found in %ls.
Error: 5044, Severity: 10, The %S_MSG ‘%.*ls’ has been removed.
Error: 5045, Severity: 16, The %S_MSG already has the ‘%ls’ property set.
Error: 5046, Severity: 10, The %S_MSG property ‘%ls’ has been set.
Error: 5047, Severity: 16, Cannot change the READONLY property of the PRIMARY filegroup.
Error: 5048, Severity: 16, Cannot add, remove, or modify files in filegroup ‘%.*ls’. The filegroup is read-only.

Error: 5050, Severity: 16, Cannot change the properties of empty filegroup ‘%.*ls’. The filegroup must contain at least one file.
Error: 5051, Severity: 16, Cannot have a filegroup with the name ‘DEFAULT’.
Error: 5052, Severity: 16, %ls is not permitted while a database is in the %ls state.
Error: 5054, Severity: 16, Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle.

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 *