Post reply

Data warehose Recovery Model

  • May 18, 2005 at 8:46 am

    #152413

    Can anyone suggest what recovery model to use for a write only db that is updated each morning & what backup method I should use ? I was thinking weekly full & differential.Thanks

  • May 18, 2005 at 9:08 am

    #559613

    In a data warehouse you would typically not care about point in time recovery functionality so I would guess that a simple recovery model is what you are looking for. Differentials are a good way of limiting space requirements in your backup strategy especially if most of the data in the warehouse is static. 

  • May 18, 2005 at 9:19 am

    #559620

    K thanks for the advice.

  • May 18, 2005 at 11:07 am

    #559660

    Just be absolutely sure that if you are not taking transaction log backups, that you change the database recovery model to Simple.  If you don't, you'll discover that your transaction logs are filling up your disks.

    Steve

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply