Situatie
Mai jos este un script ce realizeaza schimbarea de la recovery model Simple la recovery model Full pentru toate bazele de pe o instanta Microsoft SQL Server (cu exceptia bazelor listate la linia de exceptii).
Solutie
USE MASTER
GO
DECLARE @DBName VARCHAR(200)
DECLARE DB_Cursor CURSOR FOR
SELECT name
FROM sys.databases
WHERE name NOT IN ( ‘master’, ‘tempdb’, ‘model’, ‘msdb’ ) — aici pun bazele exceptie
and recovery_model_desc=’Simple’
OPEN DB_Cursor
FETCH NEXT FROM DB_Cursor INTO @DBName
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @SQL NVARCHAR(500)=Null
SET @SQL=’ALTER DATABASE [‘ + @DBName
+ ‘] SET RECOVERY FULL’
PRINT @SQL
EXEC ( @SQL)
FETCH NEXT FROM DB_Cursor INTO @DBName
END
CLOSE DB_Cursor
DEALLOCATE DB_Cursor
–Check if Recovery Model is changed to Full
SELECT name, recovery_model_desc
FROM sys.databases
order by 1
Leave A Comment?