SQL Administrator Question:

Download Job Interview Questions and Answers PDF

Do you know what is the importance of a recovery model?

SQL Administrator Interview Question
SQL Administrator Interview Question

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

Previous QuestionNext Question
Tell us what are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?Tell me what are the new features in SQL Server 2005 when compared to SQL Server 2000?