Stored procedure SP - backup all databases

 1
 2DECLARE @name VARCHAR(50) -- database name
 3DECLARE @path VARCHAR(256) -- path for backup files
 4DECLARE @fileName VARCHAR(256) -- filename for backup
 5DECLARE @fileDate VARCHAR(20) -- used for file name
 6
 7SET @path = 'C:\Backup\';
 8
 9SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)
10
11DECLARE db_cursor CURSOR FOR
12SELECT name
13FROM master.dbo.sysdatabases
14WHERE name NOT IN ('master','model','msdb','tempdb')
15
16OPEN db_cursor
17FETCH NEXT FROM db_cursor INTO @name
18WHILE @@FETCH_STATUS = 0
19BEGIN
20SET @fileName = @path + @name + '_' + @fileDate + '.bak'
21BACKUP DATABASE @name TO DISK = @fileName
22FETCH NEXT FROM db_cursor INTO @name
23END
24CLOSE db_cursor
25DEALLOCATE db_cursor