November 2, 2009 at 6:50 am
Looks to me like you can only backup read-write File/Filegroup if it's in a full or bulk-logged mode, in other words Filegroup backup assumes point-in-time restore.
What if you only need a full restore of a filegroup, and don't care about backing up logs?
November 2, 2009 at 7:35 am
You are correct. To do file/filegroup restores you have to have the log backups because, to bring the DB online, all the files/filegroups have to be rolled forward to the same point.
If say you backup primary at 10:00 and then backup a secondary filegroup at 12:00 then, when you restore, you have to apply log backups to bring the data in primary up to 12:00. SQL will not allow different parts of teh DB to be restored to different times.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply