全ユーザーデーターベースのバックアップ

Declare @DataBaseName as nvarchar(50)
Declare @BackupPath as nvarchar(100)

Declare DatabaseNames Cursor for

SELECT name FROM sys.databases where database_id > 4

open DatabaseNames 
fetch Next From DatabaseNames into @DataBaseName

        While @@FETCH_STATUS = 0
        BEGIN

            Set @BackupPath = 'D:\BackupFiles\' + @DatabaseName + '.bak'

            BACKUP DATABASE @DataBaseName TO  DISK = @BackupPath
            WITH RETAINDAYS = 90, NOFORMAT, NOINIT,SKIP, NOREWIND, NOUNLOAD,  STATS = 10

            fetch Next From DatabaseNames into @DataBaseName

        END

Close DatabaseNames
Deallocate DatabaseNames