MSSQLSERVER_1793

Applies to: yesSQL Server (all supported versions)

Details

Attribute Value
Product Name SQL Server
Event ID 1793
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name FILESTREAM_BASEDATA_NEED_SAME_PARTITION
Message Text Cannot drop index '%.*ls' since a partition scheme is not specified for FILESTREAM data.

Explanation

This message occurs when you try to drop a clustered index on a table that contains FILESTREAM data, and you specify a MOVE TO clause for the base data, but you do not specify a FILESTREAM_ON clause for the FILESTREAM data.

User Action

When dropping a clustered index on a table that contains FILESTREAM data, use one of the following options:

  • Specify both a MOVE TO clause for the base data and a FILESTREAM_ON clause for the FILESTREAM data.

  • Do not specify either a MOVE TO clause for the base data or a FILESTREAM_ON clause for the FILESTREAM data.

The following example fails because a partition scheme is specified for the base data, but is not specified for the FILESTREAM data.

DROP INDEX [<clustered_index_name>] ON [<table_name>]   
WITH ( ONLINE = OFF, MOVE TO [PRIMARY] )  
GO  

The following example succeeds because both a MOVE TO clause for the base data and a FILESTREAM_ON clause for the FILESTREAM data are specified.

DROP INDEX [<clustered_index_name>] ON [<table_name>]   
WITH ( ONLINE = OFF, MOVE TO [PRIMARY], filestream_on 'default' )  
GO  

The following example also succeeds because neither a MOVE TO clause for the base data nor a FILESTREAM_ON clause for the FILESTREAM data is specified.

DROP INDEX [<clustered_index_name>] ON [<table_name>]   
WITH ( ONLINE = OFF )  
GO