SQL Server Errors or Failures from Error: 5517 to Error: 5537

SQLServerF1

 

Error: 5517, Severity: 16, FILESTREAM container MAXSIZE must be greater than or equal to 512 KB.
Error: 5518, Severity: 16, FILESTREAM path ‘%.*ls’ is too long.
Error: 5519, Severity: 16, A database must have primary FILESTREAM log filegroup and log file in order for it to contain other FILESTREAM filegroups.
Error: 5520, Severity: 16, Upgrade of FILESTREAM container ID %d in the database ID %d failed because of container size recalculation error. Examine the previous errorlog entries for errors, and take the appropriate corrective actions.
Error: 5521, Severity: 16, Error 0x%x (NT status code) was encountered when SQL Server attempts to retrieve ‘%.*ls’ from the Transaction File System Resource Manager located at ‘%.*ls’.

Error: 5522, Severity: 16, FILESTREAM data file cannot be removed because its log file has not been backed up.
Error: 5523, Severity: 16, FILESTREAM data file group cannot be added to refer to an empty FILESTREAM log file group.
Error: 5524, Severity: 16, Default FILESTREAM data filegroup cannot be removed unless it’s the last FILESTREAM data filegroup left.
Error: 5525, Severity: 16, The READ_ONLY, READ_WRITE, and ONLINE/OFFLINE properties cannot be modified on a FILESTREAM log filegroup.
Error: 5526, Severity: 16, The FILESTREAM log file ‘%.*ls’ cannot be removed because it is being referenced by a FILESTREAM data filegroup.
Error: 5527, Severity: 16, The primary FILESTREAM log file cannot be dropped because other FILESTREAM filegroups exist.
Error: 5528, Severity: 16, A database can have at most one primary FILESTREAM log filegroup and log file.

Error: 5529, Severity: 16, Failed to remove a FILESTREAM file. The database is a primary database in an availability group. Wait for the FILESTREAM data files to be hardened on every secondary availability replica. Then retry the drop file operation.
Error: 5531, Severity: 16, Error 0x%x (NT status code) was encountered when SQL Server attempts to change the logging mode of Transaction File System Resource Manager located at ‘%.*ls’ from ‘%.*ls’ to ‘%.*ls’.
Error: 5532, Severity: 16, SQL Server cannot obtain the Kernel Transaction Manager’s transaction context to perform file system operation.
Error: 5533, Severity: 23, The FILESTREAM file system log record that has the LSN ‘%d:%d:%d’ is missing. Log folder ‘%.*ls’ is corrupted. Restore the database from a backup.
Error: 5534, Severity: 23, SQL log record at LSN ‘%d:%d:%d’ for database ‘%.*ls’ is corrupted. Database cannot recover.
Error: 5535, Severity: 23, FILESTREAM data container ‘%.*ls’ is corrupted. Database cannot recover.
Error: 5536, Severity: 23, FILESTREAM deleted folder ‘%.*ls’ is corrupted. Database cannot recover.
Error: 5537, Severity: 16, Function %ls is only valid on columns with the FILESTREAM attribute.

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 *