Do re-attempts start over or continue where backup left off

• 
  It picks up where it last left off. It can't start from the beginning because it never stored the earlier backup data that has been written. That would take up way too much resources for large backups.

  petey August 11, 2011 21:53

  - 0 +
• 
  We are having severe performance issues with our network share which is being researched by the Network team but most of our large database retry 9 times and still never succeed which is only creating more contention on the network share. Is there a way to turn of the retries so I can do some testing? Thanks.

  jlynnmc10 August 23, 2011 13:16

  - 0 +
• 
  Use the DISKRETRYCOUNT option e.g.
  

  EXEC master..sqlbackup '-sql "BACKUP ... WITH DISKRETRYCOUNT = 0"'
  

  petey August 23, 2011 14:36

  - 0 +
• 
  Can I set DISKRETRYCOUNT to 0 in the registry? I would like to turn this off for one of our servers with a large database as the retries are frequently not successful and cause the backup to take 3-7 hours longer to fail than if successful. Thanks.

  jlynnmc10 August 23, 2011 20:35

  - 0 +
• 
  No, it isn't possible to set the DISKRETRYCOUNT value in the registry to be used as the default value.

  petey August 24, 2011 08:15

  - 0 +

Add comment

Please sign in to leave a comment.