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.
571 views last month, 3 views today