Filegroups sql-server 7.0 - backup error 3029

Filegroups sql-server 7.0 - backup error 3029

Post by jobi » Sat, 01 Apr 2000 04:00:00



Here is my scenario:

I 've created database DjohanFG.

created FG1 filegroup with 2 files.('DJohanFG_FG1_0Data'
,'DJohanFG_FG1_1Data')
created FG2 filegroup with 1 file. ('DJohanFG_FG2_0Data')

created table T_FG1 on FG1 + primary-key in FG1.
Creatad table T_FG1_tweede on FG1.
Created table T_FG2 on FG2.

No relations between the tables !

Took a full backup.

Inserted 50 rows in all tables.

Took a fg-backup from FG1. ok
Took a log-backup. ok

Inserted another 50 rows in T_FG1 and T_FG2

Took a fg-backup from Primary + FG2. ok
Took a log-backup. ok

Inserted another 50 rows in T_FG1_Tweede and T_FG2.

wanted to make a filegroup-backup from FG1 .
(BACKUP DATABASE [DJohanFG]   FILEGROUP = N'FG1' TO [DjohanFG_FG1]
     WITH NOINIT ,  NOUNLOAD ,
     NAME = N'DJohanFG backup FG1',  SKIP ,  STATS = 10,
     DESCRIPTION = N'only objects FG1',  NOFORMAT )
This resulted in :
Database file 'DJohanFG_FG2_0Data' is subject to logical recovery
and must be among the files to be backed up as part of
the file or filegroup backup. [SQLSTATE 42000] (Error 3029)
Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error
3013).
The step failed.

Q : What is wrong ? I don't recall mixing FG1 and FG2 in create-table/index
statements.

 
 
 

Filegroups sql-server 7.0 - backup error 3029

Post by jobi » Wed, 05 Apr 2000 04:00:00


I did a new setup and everything works fine.

Probably friday-vibes :)
Sorry for the troubles.


>Here is my scenario:

>I 've created database DjohanFG.

>created FG1 filegroup with 2 files.('DJohanFG_FG1_0Data'
>,'DJohanFG_FG1_1Data')
>created FG2 filegroup with 1 file. ('DJohanFG_FG2_0Data')

>created table T_FG1 on FG1 + primary-key in FG1.
>Creatad table T_FG1_tweede on FG1.
>Created table T_FG2 on FG2.

>No relations between the tables !

>Took a full backup.

>Inserted 50 rows in all tables.

>Took a fg-backup from FG1. ok
>Took a log-backup. ok

>Inserted another 50 rows in T_FG1 and T_FG2

>Took a fg-backup from Primary + FG2. ok
>Took a log-backup. ok

>Inserted another 50 rows in T_FG1_Tweede and T_FG2.

>wanted to make a filegroup-backup from FG1 .
>(BACKUP DATABASE [DJohanFG]   FILEGROUP = N'FG1' TO [DjohanFG_FG1]
>     WITH NOINIT ,  NOUNLOAD ,
>     NAME = N'DJohanFG backup FG1',  SKIP ,  STATS = 10,
>     DESCRIPTION = N'only objects FG1',  NOFORMAT )
>This resulted in :
>Database file 'DJohanFG_FG2_0Data' is subject to logical recovery
>and must be among the files to be backed up as part of
>the file or filegroup backup. [SQLSTATE 42000] (Error 3029)
>Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error
>3013).
>The step failed.

>Q : What is wrong ? I don't recall mixing FG1 and FG2 in create-table/index
>statements.