Microsoft KB Archive/292808

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

Article ID: 292808

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q292808



BUG #: 101324 (SQLBUG_70)



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.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.



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