Change Recovery Model of MSSQL database


Staff member
In this article we are going to describe the details of changing recovery model on MS SQL database. You can easily change it through SQL Server Management Studio for your database. There are three recovery models are available.
  • Simple
  • Full
  • Bulk-logged
As you know mostly MSSQL database use full and simple recovery model but it can be switched to another model instantly, so its always recommended to take backup of transaction logs before switching the recovery model.

You can follow below steps to change recovery model with SQL Server Management Studio
  • First login to SQL Server Management studio
  • After login you will find “Object Explorer”on left hand side of screen, you have to click on server name. It will expand the server tree.
  • Now click on “databases” option to expand it and right click on particular database, choose “properties” option.
  • A new window will open where you have to click on “Options” under “Select a page” section. Here you will see the current recovery model which is available under Recovery model list box. You can choose the desired recovery model from drop down and click on OK.