by 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.