DECLARE @name NVARCHAR(50) -- database name <br>
DECLARE @path NVARCHAR(256) -- path for backup files <br>
DECLARE @fileName NVARCHAR(256) -- filename for backup <br>
DECLARE @fileDate NVARCHAR(20) -- used for file name
<p>SET @path = 'C:\' </p>
<p>SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) </p>
<p>DECLARE db_cursor CURSOR FOR <br>
  SELECT name <br>
  FROM master.dbo.sysdatabases <br>
  WHERE name NOT IN ('master','model','msdb','tempdb') -- AND name LIKE 'Eskulap%'</p>
<p>OPEN db_cursor <br>
  FETCH NEXT FROM db_cursor INTO @name </p>
<p>WHILE @@FETCH_STATUS = 0 <br>
  BEGIN <br>
  SET @fileName = @path + @name + '.bak' <br>
  PRINT @fileName<br>
  BACKUP DATABASE @name TO DISK = @fileName </p>
<p> FETCH NEXT FROM db_cursor INTO @name <br>
  END </p>
<p>CLOSE db_cursor <br>
  DEALLOCATE db_cursor</p>