Stored Procedure to take database backup

CREATE PROC BackUP_Get
AS
DECLARE @name VARCHAR(50) -- database name
DECLARE @fileName VARCHAR(256) -- filename for backup
DECLARE @fileDate VARCHAR(20) -- used for file name
SET @path = 'C:\'
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)
DECLARE cursor_backup CURSOR FOR --
SELECT name
FROM master.dbo.sysdatabases
WHERE name NOT IN ('master','model','msdb','tempdb')
SELECT name FROM master.dbo.sysdatabases
OPEN cursor_backup
FETCH NEXT FROM cursor_backup INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
SET @fileName = @path + @name + '_' + @fileDate + '.BAK'
BACKUP DATABASE @name TO DISK = @fileName
FETCH NEXT FROM cursor_backup INTO @name
END
CLOSE cursor_backupDEALLOCATE cursor_backup
GO