Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Thumbs down Unanswered: Backup database problem

    I am trying to backup database on limited size drive
    In options for backup I picked overwrite existing file, but for some reasons it still creates new file with the date associated with it
    What strange about that is ,it strippes old file from the date and new file has the date in file name

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    If you are using the Database Maintenance planner or the xp_sqlmaint procedure, they will use a file naming convention which may be different than the old backup that is on your system, so they won't touch the old file because they don't recognize it.

    Also, when overwriting files, Windows applications typically create a new file and then delete the old file and rename the new file when the new file is complete. So you can still run out of disk space if you don't have enough room for two copies of the file.


Posting Permissions

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