SQL Administrator Question:
Download Job Interview Questions and Answers PDF
Do you know what is the importance of a recovery model?
Answer:
Primarily, recovery model is chosen keeping in view the amount of data loss one can afford to. If one expects to have minimal or no data loss, choosing the Full recovery model is a good choice. Depending on the recovery model of a database, the behavior of database log file changes. I would recommend you read more material on log backups and log file behavior and so on to understand in depth.
Download SQL Administrator Interview Questions And Answers
PDF