SQL Server Errors or Failures from Error: 5124 to Error: 5170

SQLServerF1

 

Error: 5124, Severity: 16, The file header in ‘%ls’ does not match the expected contents for file ‘%ls’ of database ‘%ls’. The mismatch is possibly between the full-text catalog files and the related database. Perform a restore if necessary.
Error: 5125, Severity: 24, File ‘%ls’ appears to have been truncated by the operating system. Expected size is %I64d KB but actual size is %I64d KB.
Error: 5127, Severity: 16, All files must be specified for database snapshot creation. Missing the file “%ls”.
Error: 5128, Severity: 17, Write to sparse file ‘%ls’ failed due to lack of disk space.
Error: 5129, Severity: 10, The log cannot be rebuilt when the primary file is read-only.
Error: 5130, Severity: 10, The log cannot be rebuilt when database mirroring is enabled.
Error: 5131, Severity: 10, The log was not rebuilt because there is more than one log file.

Error: 5132, Severity: 16, The path specified by ‘%.*ls’ cannot be used for FILESTREAM files because it is a raw device.
Error: 5133, Severity: 16, Directory lookup for the file “%ls” failed with the operating system error %ls.
Error: 5134, Severity: 16, The path that is specified by ‘%.*ls’ cannot be used for FILESTREAM files because it is not on a supported file system.
Error: 5135, Severity: 16, The path ‘%.*ls’ cannot be used for FILESTREAM files. For information about supported paths, see SQL Server Books Online.
Error: 5136, Severity: 16, The path specified by ‘%.*ls’ cannot be used for a FILESTREAM container since it is contained in another FILESTREAM container.
Error: 5144, Severity: 10, Autogrow of file ‘%.*ls’ in database ‘%.*ls’ was cancelled by user or timed out after %d milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.

Error: 5145, Severity: 10, Autogrow of file ‘%.*ls’ in database ‘%.*ls’ took %d milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
Error: 5149, Severity: 16, MODIFY FILE encountered operating system error %ls while attempting to expand the physical file ‘%ls’.
Error: 5150, Severity: 16, The size of a single log file must not be greater than 2 TB.
Error: 5159, Severity: 24, Operating system error %.*ls on file “%.*ls” during %ls.
Error: 5161, Severity: 16, An unexpected file id was encountered. File id %d was expected but %d was read from “%.*ls”. Verify that files are mapped correctly in sys.master_files. ALTER DATABASE can be used to correct the mappings.
Error: 5169, Severity: 16, FILEGROWTH cannot be greater than MAXSIZE for file ‘%.*ls’.
Error: 5170, Severity: 16, Cannot create file ‘%ls’ because it already exists. Change the file path or the file name, and retry the operation.

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 *