title: Replace previous database backup by new one
body: <p>I use this script for getting backup from my sql server databases</p>
  
  <pre><code>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
  
  --Path to backups
  SET @path = 'E:\DataBase Backups\' 
  
  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','ReportServer','ReportServerTempDB') 
  
  OPEN db_cursor  
  FETCH NEXT FROM db_cursor INTO @name  
  
  WHILE @@FETCH_STATUS = 0  
  BEGIN  
         --Remove if you dont want a date stamp 
         SET @fileName = @path + @name + '_' + @fileDate + '.BAK' 
  
        -- SET @fileName = @path + @name + '.BAK' 
         BACKUP DATABASE @name TO DISK = @fileName with noinit
  
         FETCH NEXT FROM db_cursor INTO @name  
  END  
  
  CLOSE db_cursor  
  DEALLOCATE db_cursor
  </code></pre>
  
  <p>This code makes new backup file per day, but I need to replace my old backup by today backup or after making today's backup, all old backups became deleted!
  Could you please help me? </p>