InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 13:55:29 GMT20http://www.sqlservercentral.com/Forums/Topic1409175-391-1.aspx[quote][b]winmansoft (1/21/2013)[/b][hr]If i create a file group with read only then how can i insert the values to the table?[/quote]You can't. That's what read only means.[quote]What is the use of read only file group?[/quote]Historical data. Static lookups. Anything that doesn't change.Mon, 21 Jan 2013 06:40:22 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1409175-391-1.aspxIf i create a file group with read only then how can i insert the values to the table? What is the use of read only file group?Mon, 21 Jan 2013 06:04:17 GMT IT researcherhttp://www.sqlservercentral.com/Forums/Topic1409175-391-1.aspxIf it was read only at the time of backup, then when you restore it, you won't need to roll the logs forward, as it was read only and hence could not have changed.Mon, 21 Jan 2013 02:46:11 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1409175-391-1.aspxWhat if i create secondary file group as read only?Mon, 21 Jan 2013 00:46:55 GMT IT researcherhttp://www.sqlservercentral.com/Forums/Topic1409175-391-1.aspxGail is right. You will have to restore to two separate databases, each rolled forward to different point-in-time.Sat, 19 Jan 2013 19:12:33 GMTVedran Kesegichttp://www.sqlservercentral.com/Forums/Topic1409175-391-1.aspxAs I mentioned previously ([url]www.sqlservercentral.com/Forums/Topic1407762-391-1.aspx[/url])[quote]You'd have to restore the primary filegroup backup, the the secondary, then all the log backups since the oldest of those 2 backups to bring the DB to a consistent point[/quote]You can't restore parts of a database to one time and parts to some other time. A database has to be all at one point in time.Sat, 19 Jan 2013 09:52:11 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1409175-391-1.aspxI am pretty sure you dont get an option to backup the log file in file and file group backup.Could you confirm the exact steps you performed.What your trying to do is something like a piecemeal restore. where only certain file groups are brought online but in order to do this the filegroups that arent brought online should be read only filegroups.Sat, 19 Jan 2013 05:54:03 GMTJayanth_Kuruphttp://www.sqlservercentral.com/Forums/Topic1409175-391-1.aspxI 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 backupPrimary fg backup--pri1.baksecondary fg backup--sec1.baklog backup--log1.bakInserted some rows to table of primary file group.Inserted some rows to table of secondary file group.primary fg backup--pri2.baksecondary fg backup-- sec2.baklog backup--log2.bakWhat 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 GORESTORE DATABASE [test23] FILE = N'nvt_fg' FROM DISK = N'D:\sec1.bak' WITH NORECOVERY GORESTORE LOG [test23] FROM DISK = N'D:\log1.bak' WITH NORECOVERYGORESTORE LOG [test23] FROM DISK = N'D:\log2.bak' WITH RECOVERYGOBut 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 ?Thank youSat, 19 Jan 2013 04:03:37 GMT IT researcher