HEELPBOOK - DB SQL in Simple Mode (Microsoft SQL Server) ##########################

Un piccolo script SQL per convertire tutti i database utente in una istanza SQL in Simple mode.

declare @name VARCHAR(50)
declare @sql VARCHAR(1000)
declare db_cursor cursor for 
SELECT name from master..sysdatabases where name not in ('master','model','msdb','tempdb')
open db_cursor
fetch NEXT from db_cursor into @name
while @@fetch_status = 0
begin
 set @SQL = 'ALTER DATABASE [' + @name + '] SET RECOVERY SIMPLE'
 exec (@SQL)
 fetch next from db_cursor into @name
end
close db_cursor
deallocate db_cursor


############ ARTICLE INFO #############

Article Month: August
Article Date: 24/08/2012
Permalink: http://heelpbook.altervista.org/2012/db-sql-in-simple-mode-microsoft-sql-server/
Source: http://www.essereinformatica.com/index.php/soluzioni-tecniche-mainmenu-54/60-db-sql-in-simple-mode
Language: Italian

View more articles on: http://www.heelpbook.net/
Follow us on Facebook: http://it-it.facebook.com/pages/HeelpBook/100790870008832
Follow us on Twitter: https://twitter.com/#!/HeelpBook
Follow us on RSS Feed: http://feeds.feedburner.com/Heelpbook
Follow us on Delicious: http://delicious.com/heelpbook
Linkedin: http://it.linkedin.com/pub/stefano-maggi/27/73a/b20