Do you know what is the importance of a recovery model?
Submitted by: Muhammad
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.
Submitted by: Muhammad
Read Online SQL Administrator Job Interview Questions And Answers
