Filestream get backed up?

  • I'm guessing that filestreams get backed-up with the regular back-up process since they're otherwise treated like 'normal' data with 2008.

  • Yup. That's one of the key selling points for it. Backed up with the database, transactional and will triggers, but in the file system, not split up in database pages

    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