396c397a   
   From: emurphy42@socal.rr.com   
      
   andrewl wrote:   
      
   > I am  a newbie in sqlserver 2005. I would like to backup with new   
   > backup name with date eg. backup200900601, backup20090602 etc. how am   
   > I going to do it?   
   > In real production large database practice, is the backup not append   
   > to the backupset every day?   
      
   In SQL Server 2000, we routinely created a maintenance plan and let it   
   handle these details (include date as part of name, delete backups older   
   than X days old).  Has this changed significantly in 2005?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)