How To Change the Database Recovery Model

I will share how to change the database recovery model in this article.

You can find the answer of the “What is recovery model” question in detail in the article “What is Database Recovery Model“.

We can change database recovery model through SSMS (SQL Server Managemet Studio) or TSQL code.

Find and Change Database Recovery Model Via SSMS

Right click on the database via SSMS and click Properties.

Go to the Options tab and select Full, Bulk-logged or Simple from Recovery Model and click OK.

Change Database Recovery Model Via TSQL

You can change database recovery model by using the following script.

You can set one of the following recovery models.

  • FULL
  • SIMPLE
  • BULK_LOGGED