From: samalex@gmail.com   
      
   On Wed, 10 Jun 2009 17:51:17 -0500, Ed Murphy    
   wrote:   
      
   > 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?   
      
      
   Hi Ed,   
      
   First off long time no chat my friend :)  It's Sam Alexander from FidoNet   
   388.  I pinged you probably 5 or 6 years ago on another forum, but I don't   
   know if I ever checked back or saw your reply.   
      
   As for SQL Server backups on SQL 2005 and 2008, you can still setup   
   maintenance plans like you could in SQL 2000, but personally I've always   
   preferred writing my own code to do this since I always have some tweaks.   
   Most of our systems have nightly SSIS processes that run for various   
   tasks, and I just add my backup code to that so there's no timing issues.   
   Not to say it's the best way, but it works in our environment.   
      
   Take care, and good to see you're still around...   
      
   Sam Alex   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)