backup all SQL Server databases

--script to backup all databases

DECLARE @Name VARCHAR(50)
DECLARE @Path VARCHAR(256)
DECLARE @Filename VARCHAR(256)
DECLARE @FileDate VARCHAR(20)

SET @Path='c:\Backup\'
SELECT @FileDate=CONVERT(VARCHAR(20),GETDATE(),112)

DECLARE db_Cursor CUrSOR FOR
SELECT Name FROM Master.dbo.sysdatabases WHERE Name NOT IN ('master','model','msdb','tempdb') 

OPEN db_Cursor
Fetch NEXT FROM db_Cursor INTO @name

WHILE @@FETCH_STATUS=0
BEGIN 
SET @Filename=@Path+@Name+'_'+@FileDate+'.bak'
backup database @name TO DISK =@Filename
FETCH NEXT FROM db_Cursor INTO @Name
END
CLOSE db_Cursor
DEALLOCATE db_Cursor