This is an old revision of the document!
Download SQL Server Management Studio: https://msdn.microsoft.com/library/mt238290.aspx
It is convenient to use the Microsoft SQL Server Management Studio to perform the actual database recovery.
Set all databases to the FULL recovery model. Replace the three occurrences of “full” with “simple” if desired.
USE master GO -- Declare a variable to store the value [database name] returned by FETCH. DECLARE @dbname sysname, @cmd varchar(1000) -- Declare a cursor to iterate through the list of databases DECLARE db_recovery_cursor CURSOR FOR SELECT name from sysdatabases -- Open the cursor OPEN db_recovery_cursor -- Perform the first fetch and store the value in a variable. FETCH NEXT FROM db_recovery_cursor INTO @dbname -- loop through cursor until no more records fetched WHILE @@FETCH_STATUS = 0 BEGIN IF (SELECT DATABASEPROPERTYEX(@dbname,'RECOVERY')) <> 'full' and @dbName <> 'tempdb' BEGIN -- create the alter database command for each database SET @cmd = 'ALTER DATABASE "' + @dbname + '" SET RECOVERY full' -- alter each database setting the recovery model to full EXEC(@cmd) PRINT @dbname END FETCH NEXT FROM db_recovery_cursor INTO @dbname END -- close the cursor and deallocate memory used by cursor CLOSE db_recovery_cursor DEALLOCATE db_recovery_cursor