• GilaMonster (10/2/2013)


    Warning: Since the DB is in simple recovery, you can take file and file group backups at different times, but you won't be able to restore them (unless all but one are read only).

    Stick to full backups unless you like surprises when it comes to restore.

    What if the Recovery model is full? We've been discussing reducing backup times & space by doing nightly backups of filesgroups containing current data only, and then backup the archive filegroups only after the archiving job runs, which isn't very often. But if this makes a full restore problematic, it's not something we should do.