Đoạn script này giúp bạn backup toàn bộ db trên server

Use Master

Declare @DatabaseName sysname
Declare @SQLCommand varchar(1024)
Declare curDBName Cursor For
Select [Name] From Master..Sysdatabases
Where [Name] Not In ('tempdb')

Open curDBName
Fetch curDBName Into @DatabaseName

While (@@fetch_status = 0)

Begin
        if databasepropertyex (@DatabaseName,'Status') = 'online'
        Begin
                Select @SQLCommand = 'Backup Database ' + @DatabaseName + 
                ' To Disk = ''D:\Backups\Databases' + @DatabaseName + '.bak'' With Format'
                execute (@SQLCommand)
        End
        Fetch curDBName Into @DatabaseName
End

Close curDBName
Deallocate curDBName