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

1 comment:

james franklin said...

repair database sql corrupted by viruses, all sorts of malware, hard drive failures, file system errors, incorrect user actions, etc.