SQL Server Change Recovery Model

Hi,

You may need to change database recovery model of SQL Server.

 

If your backup plan change and you don’t need time-in-point recovery then you may change recovery model of SQL Server database.

You can change all database recovery model of Instance like following query from Full to Simple.

declare @SQL varchar(max)=''
select @SQL+='ALTER DATABASE '+name+' SET RECOVERY SIMPLE;'+CHAR(10)
from sys.databases
where recovery_model_desc!='SIMPLE'
exec(@SQL)

 

Or you may need to change all simple database to Full recovery model in SQL Server then you can use following query.

declare @SQL varchar(max)=''
select @SQL+='ALTER DATABASE '+name+' SET RECOVERY FULL;'+CHAR(10)
from sys.databases
where recovery_model_desc='SIMPLE'
exec(@SQL)

 

 

Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.

https://ittutorial.org/sql-server-tutorials-microsoft-database-for-beginners/