Home Forums SQL Server 2005 Backups How take backup without overwriting or Appending the old files RE: How take backup without overwriting or Appending the old files
John Mitchell-245523
SSC Guru
Points: 148809
More actions
January 9, 2012 at 7:19 am
#1430446
Yes, maintenance plans will do that for you. You don't have any control, as far as I know, over the actual name of the file, but you'll get each day's backup in a separate file whose name contains the database name and a timestamp.
John