Hi.
Our DB has Primary file group (data and log files are there) where all
lookup are.
has 2 big tables each on own partition (by date) with their indexes.
so
Primary has file xxx_data.mdf and xxx_log.ldf
the 1 big table1 and its indexes are on paritions by year.
data of 1970 on part_1970 filegroup part_1970 filename part_1970.mdf
data of 1971 on part_1971 .......................same
thing.......................mdf
..up to 2008
..
..
and so the other table2 (but by 10 years)
data of the 70s on part_70s.mdf
data of the 80s on part_80s.mdf
..up to 2008
..
..
there are no FKs between tables ..
Now.
I need a way to get:
primary file group and its data
the last 2 partition of table1 (2007 and 2008)
the last 1 partition of table2 (2000s)
I did a backup for the file/filegroup
WITH NOFORMAT, INIT, NAME = N'Forecast-Full Filegroup Backup', SKIP,
NOUNLOAD, STATS = 10
when restoring (with move, REPLACE , NORECOVERY / RECOVERY )
I am getting that the DB is taken offline because something was not
completed.
and the DB shows as (restoring)..
what am I missing here.
THANKS
>> Stay informed about: restore file/filegroup for partitioned tables