Results 1 to 3 of 3

Thread: Backup Database Help

  1. #1
    Join Date
    Dec 2007
    Posts
    1

    Backup Database Help

    Could you tell me how to make my backup files not overwrite each other? Right now I have a job setup to run a backup everyday at 12am, but when I arrive in the morning there is just one file in the folder. I want it to read like this (BUP_Master_12/11/07 12:00am, BUP_Master_12/12/2007 12:00am…). I want to see a file for everyday. Anyone know what to do? (getdate???)

  2. #2
    Join Date
    Dec 2007
    Posts
    7
    How do you start the backup, from unix cron?

    Rename the files before the backup start
    or
    Have your script dump to different file names

  3. #3
    Join Date
    Jan 2008
    Posts
    1
    Include date in file name so that file name will not be overwritten

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •