I have a database with nearly 1TB of
FILESTREAM data that I don't need backed up (if the data was deleted it'd be recreated automatically in a couple of hours, so it just isn't important). Most of the data is changed every couple of days, so differential backups wouldn't really help keep the size down.
I had the backups working the way I needed by setting Recovery Mode to
Full, creating a separate
FILEGROUP for the
FILESTREAM, then taking backups of only the "Primary"
FILEGROUP. The problem this caused was that the log file (which also gets backed up) is now unnecessarily large because it includes the
SIMPLE Recovery Mode takes away my ability to do backups of specific
FILEGROUPs, so I don't think that will be an option either.
My thoughts are to just move the
FILESTREAM data to a separate database, but now I'm losing referential integrity and surely inheriting a host of other issues as well.
Is there any way to create partial backups in
Simple recovery mode (without setting the
FILESTREAM table to read only)? If not, are there any other sane solutions to my problem?