BUG: Backup Filegroup Error Message 3029 Subject to Logical Recovery after Creating a Clustered Index on Two or More Filegroups (292808)

SYMPTOMS

For a database with two or more file groups, if a clustered index is created on a table in each filegroup, an attempt to back up any individual file group may fail with the following 3029 error message:

Server: Msg 3029, Level 16, State 1, Line 2
Database file 'DB_DataA' is subject to logical recovery and must be among the files to be backed up as part of the file or filegroup backup.
Server: Msg 3029, Level 16, State 1, Line 2
Database file 'DB_DataB' is subject to logical recovery and must be among the files to be backed up as part of the file or filegroup backup.
Server: Msg 3013, Level 16, State 1, Line 2
Backup or restore operation terminating abnormally.

WORKAROUND

Perform a full database backup before you attempt to make file or file group backups. After the full backup, you can back up individual file groups.

MORE INFORMATION

After every file group backup, you must perform a transaction log backup or the file group backup is not restorable.

REFERENCES

SQL Server 7.0 Books Online