How can we help you today? How can we help you today?

DiskRetry options in version 6 and Full disks

Hi,

Would I be right in assuming that if the backup disk gets full and the DISKRETRYCOUNT > 0 then it will continue to try to write to the disk until the retries count is passed?

Most of our problems have come from no disk space on our Development servers so the backup fails. For a database of over 200Gb creating a 20Gb backup and having a space problem and the software continuing to keep running is not good.

I have had occasions when a backup fails because of not enough space but the partial backup is not deleted causing further disk space problems. Having failed backups delete the partial backup would be a very good addition to SQL Backup.

Thanks

Chris
ChrisAVWood
0

Comments

4 comments

Sort by
  • Linda Hawksworth
    Thanks for your feature request for SQL Backup. I have logged it in our tracking system. It will be considered for a future release of SQL Backup.
    Linda Hawksworth
    0
  • ChrisAVWood
    Linda,

    I'm glad that you will look at the deleting of partial backups caused by disk full failures.

    Can I get an answer to my real question about the DISKRETRIES option when the backup fills up the disk before it finishes. Will the default 10 retries keep trying to backup even though there is no disk space?

    Thanks

    Chris
    ChrisAVWood
    0
  • petey
    Can I get an answer to my real question about the DISKRETRIES option when the backup fills up the disk before it finishes. Will the default 10 retries keep trying to backup even though there is no disk space?
    Yes it will.
    petey
    0
  • ChrisAVWood
    Thanks Petey.

    Now I will adjst my T-SQL scripts that we have in our SQL Agent jobs when we upgrade to 6.2.

    Chris
    ChrisAVWood
    0

Add comment

Please sign in to leave a comment.