Posted - 01/19/2013 : 06:04:38
I am new to file group backup and restore .So i am trying something to do with file groups.
Below i have shown some steps which i did one by one. Please ask me if anyone don't understand the steps what i did!!
I have taken following backup
Primary fg backup--pri1.bak
secondary fg backup--sec1.bak
Inserted some rows to table of primary file group.
Inserted some rows to table of secondary file group.
primary fg backup--pri2.bak
secondary fg backup-- sec2.bak
What i wanted to acheive is that after all restoration i want all table of primary file group with all data(data which is present in both pri2.bak) and secondary file group tables with the data containing only in sec1.bak i don't want the data which i have inserted to secondary file group tables after taking sec.bak1.So i did following steps.
RESTORE DATABASE [test23] FILE = N'nvt' FROM DISK = N'D:\pri2.bak' WITH NORECOVERY
RESTORE DATABASE [test23] FILE = N'nvt_fg' FROM DISK = N'D:\sec1.bak' WITH NORECOVERY GO
RESTORE LOG [test23] FROM DISK = N'D:\log1.bak' WITH NORECOVERY
RESTORE LOG [test23] FROM DISK = N'D:\log2.bak' WITH RECOVERY
But when log2.bak restored it recovers all data of secondary file group.If i don't restore log2.bak then database will not be recovered. So how can achieve what i have mentioned above ?