Tag Archives: recovery models

MS SQL Recovery Models

Recovery models serve very important roles when it comes to MS SQL Server backup. The purpose of an MS SQL Recovery Model is to control how transactions are logged, whether it allows and requires backing up and the types of restore operations that are available. By controlling transaction log maintenance, databases are able to be converted from one recovery model to another at any time. The three types of recovery models are simple, full and bulk-logged, with most databases using either the simple recovery model or full recovery model. Whichever model is used, there are differences between the three. Continue reading MS SQL Recovery Models