Sql Error #5504, Severity 15

Sql Error Number:5504
Severity: 15

Description: 'PRIMARY' can only be specified for FILESTREAM log filegroup in a 'CONTAINS' clause.

Possibly related links:

FILESTREAM Storage in SQL Server 2008
... CONTAINS FILESTREAM clause is necessary to distinguish the ... and the Active Portion of the Log" (http://msdn.microsoft.com/en-us/library/ms189573.aspx) ...

ALTER DATABASE File and Filegroup Options (Transact-SQL)
There can be only one file, , for a FILESTREAM filegroup. ... and add a FILEGROUP that CONTAINS the FILESTREAM clause to --the FileStreamPhotoDB database. ...

Using FILESTREAM with Other SQL Server Features
... data file is included in a CREATE DATABASE ON clause, the ... Database mirroring cannot be configured for a database that contains FILESTREAM filegroups. ...

CREATE DATABASE (Transact-SQL)
There can be only one file, , for a FILESTREAM filegroup. ... were created, only the primary file has to be specified in the FOR ATTACH clause. ...

RESTORE (Transact-SQL)
For online restore of a non-primary filegroup, the database can stay in use ... for each cleared cachestore in the plan cache, the SQL Server error log contains ...

CREATE TABLE (Transact-SQL)
... contains FILESTREAM data and the table is partitioned, ... In this case, a different FILESTREAM filegroup, partition scheme, or "default" can be specified. ...

CREATE INDEX (Transact-SQL)
... be stored in a single filegroup that is specified in the FILESTREAM_ON clause. ... The UNIQUE or PRIMARY KEY constraint can contain a computed column as ...

DROP INDEX (Transact-SQL)
The ONLINE option can only be specified when you drop clustered indexes. ... Specifies a FILESTREAM filegroup for FILESTREAM data. ...

ALTER TABLE (Transact-SQL)
NOT NULL can be specified in ALTER COLUMN only if the column contains no null values. ... clause will succeed only if the table has no FILESTREAM columns. ...

RESTORE Arguments (Transact-SQL)
If the backup contains the primary filegroup and a partial restore is being performed. ... Only transaction log records written before the specified date and time are ...

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!