MSSQLSERVER_1793

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

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