Post reply

Filegroup backup assumes point-in-time restore

  • November 2, 2009 at 6:50 am

    #211760

    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

    #1073805

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply