Today attend SQL2008 training is talking about what is the different Simple recovery model VS Full recovery Model.Then i am thinking what is the moss2007 setting? Below is the Default Recovery Model.
Simple model :
- Automatic reclaims the transaction log
- Allow only Full backups
Full Model:
- Require transaction log backup (which mean not automatic to shrink your transaction log file)
- able to enable recovery the data very near to down time
* oh ya…please remember all the Database here, because one of my interview is asking about this :) . ha ha..
No comments:
Post a Comment