SQL Statement

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

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