Simple script to backup all SQL Server databases

DECLARE @Name VARCHAR(50)--database name

DECLARE @Path VARCHAR(256) -- path for backup files

DECLARE @FileName VARCHAR(256)--filename for backup

DECLARE @FileDate VARCHAR(20) -- Used for file name

SET @Path ='H:\backuptest\'

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