SQL Server Errors or Failures from Error: 5538 to Error: 5570

SQLServerF1

 

Error: 5538, Severity: 16, Partial updates are not supported on columns that have a FILESTREAM as a source.
Error: 5539, Severity: 16, The ROWGUIDCOL column associated with the FILESTREAM being used is not visible where method %ls is called.
Error: 5540, Severity: 16, The FILESTREAM column cannot be used with method %ls because the associated ROWGUIDCOL of the base table is nullable or does not have a unique constraint.
Error: 5541, Severity: 16, An open mode must be used when a FILESTREAM column is opened as a file.
Error: 5542, Severity: 16, The FILESTREAM filegroup ‘%.*ls’ has no files assigned to it. FILESTREAM data cannot be populated on this filegroup until a file is added.

Error: 5543, Severity: 10, FILESTREAM: effective level = %d (remote access disabled), configured level = %d, file system access share name = ‘%.*ls’.
Error: 5544, Severity: 10, FILESTREAM: effective level = %d (remote access enabled), configured level = %d, file system access share name = ‘%.*ls’.
Error: 5550, Severity: 16, Too many Filestream containers were specified for Filestream Filegroup ‘%.*ls’. Specifying more than one Filestream Container per Filestream Filegroup is not supported in this edition of SQL Server. See Books Online for more details on feature support in
Error: 5551, Severity: 16, FILESTREAM file ‘%.*ls’ cannot be added because its destination filegroup cannot have more than one file. Specifying more than one Filestream Container per Filestream Filegroup is not supported in this edition of SQL Server. See Books Online for more deta
Error: 5552, Severity: 16, FILESTREAM file named with GUID ‘%.*ls’ that belongs to FILESTREAM data file ID 0x%x does not exist or cannot be opened.

Error: 5553, Severity: 16, SQL Server internal error. FILESTREAM manager cannot continue with current command.
Error: 5554, Severity: 16, The total number of versions for a single file has reached the maximum limit set by the file system.
Error: 5555, Severity: 16, The operation has failed because the FILESTREAM data cannot be renamed.
Error: 5556, Severity: 16, The database ‘%.*ls’ does not exist or does not support FILESTREAM. Supply a valid database name. To see available databases, use sys.databases.
Error: 5557, Severity: 16, The FILESTREAM container ‘%.*ls’ does not exist or cannot be processed. Supply a valid FILESTREAM container name. To see available containers, use sys.databases_files.
Error: 5558, Severity: 16, Database ‘%.*ls’ should be in single-user mode.
Error: 5559, Severity: 16, Could not open the database ‘%.*ls’.
Error: 5560, Severity: 16, Access to the FILESTREAM tombstone table for the database ‘%.*ls’ cannot be performed at the moment because it conflicts with another activity, such as background GC operation, backup operation, DBCC CHECK* operation or on-going snapshot creation.
Error: 5561, Severity: 16, FILESTREAM garbage collector operation was aborted on the database ‘%.*ls’.
Error: 5570, Severity: 16, FILESTREAM Failed to find the garbage collection table.

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 *