SQL Server 2008 R2 File/Filegroup Restores

  • What you need to do after that is then restore all the log backups taken on prod between when the backup of FileGroupC was taken and when that last backup was taken. This is because the entire database must be restored to a consistent state and an exact same time.

    Other option, if the static filegroup is really static, mark it readonly on production, then restore it once to dev and there will be no need to restore logs.

    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 post 1 (of 2 total)

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