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

  • 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