Monday, April 09, 2012

Database Recovery model and backup types

When you try to configure the Database recovery option for backup strategy make sure to select the correct recovery model . If you need further more about this read from microsoft web.

Database
Backup Type
Recovery_Model FullDifferentialTransaction
FULLYesYesYes
Bulk-loggedYesYesYes
SimpleYesYesNo