USE MASTER
GO
/*
executa o backup de todos os bancos de dados, exceto sistemas.
*/
DECLARE @dbname VARCHAR(100)
,@pathname
VARCHAR(100)
DECLARE _cursor CURSOR FOR SELECT name FROM sysdatabases WHERE name NOT IN
('master', 'tempdb', 'model', 'msdb')
OPEN _cursor
FETCH NEXT FROM _cursor INTO @dbname
WHILE @@FETCH_STATUS = 0
BEGIN
SET @pathname =
'F:\BACKUP\' + @dbname + '.bak'
BACKUP DATABASE @dbname TO
DISK = @pathname WITH INIT
FETCH NEXT FROM _cursor
INTO @dbname
END
CLOSE _cursor
DEALLOCATE _cursor
GO
