Are non-modified FILESTREAM files excluded from DIFFERENTIAL backups?

Posted by TiborKaraszi on SQL Blog See other posts from SQL Blog or by TiborKaraszi
Published on Fri, 14 May 2010 06:38:00 GMT Indexed on 2010/05/14 6:56 UTC
Read the original article Hit count: 196

Filed under:
Short answer seems to be "yes". I got this from a forum post today, so I thought I'd test it out. Basically, the discussion is whether we can somehow cut down backup sizes for filestream data (assumption is that filestream data isn't modified very frequently). I've seen this a few times now, and often suggestions arises to somehow exclude the filestream data and fo file level backup of those files. But that would more or less leaves us with the problem of the "old" solution: potential inconsistency....(read more)

© SQL Blog or respective owner

Related posts about backup