I have a large database, ~100 gig or so, and about 5 gigs of it is mission critical data, the rest, I could reload from a web service, so it's not crucial.
Backing up that data is expensive, and not worth it, when it could just be reloaded.
So, I want to run simple recovery, and backup the primary file group. The issue is, it's grayed out, and the only way I can get it opened up is by using Full or Bulk-Logged recovery model.
These other recovery models generate a 50-100gig log file, because again, my large database has lots of operations going on to daily rank stuff and store, etc etc.
Is there anyway to do what I want, simple recovery with a backed up primary file group, and if not, is there anyway I can get to somewhere closer then having these massive files full of data I just don't care enough to backup.