What are the challenges you face when working across database platforms? Take the survey
Options

6.5 VDI problems seem more frequent

PDinCAPDinCA Posts: 642 Silver 1
edited June 15, 2011 4:37PM in SQL Backup Previous Versions
Having noted the
Improved timeout for VDI functions and threaded SQL connections
point in the release notes, I installed the update immediately as I've had about 3 or 4 VDI-related "failures" per week. Thank goodness SQL Backup retries - every retry succeeds on the 1st attempt.

However, I'm now getting 3 or 4 PER DAY!

Assistance, please... I'll gladly furnish the SB Log file...

Thanks.
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Please do post the log file for a couple of the backups that failed on the first attempt.

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    PDinCAPDinCA Posts: 642 Silver 1
    There are four files for May 12th on their way to the support email inbox, citing this thread.

    Thanks.
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • Options
    Does the new 6.5.1.9 help with this problem?

    Chris
    English DBA living in CANADA
  • Options
    PDinCAPDinCA Posts: 642 Silver 1
    Hi Chris,

    Until your post I was unaware of the dot-release but have begun to install it. I followed Peter Yeoh's advice to create the timeout DWORD and initially set it to 60 seconds, which I upped to 80 seconds a few days ago and timeout backup failures have ceased.

    It may have been "environmental" as the network at Rackspace has given us tons of timeout issues, typically on Windows authentication requests and sometimes on SQL Monitor pinging the cluster. Taking 90 seconds to change a Windows password is molasses and a further indication of environmental factors contributing to the issue.

    Will see how the new release performs...

    Cheers!
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • Options
    Did it improve things?

    Chris
    English DBA living in CANADA
  • Options
    PDinCAPDinCA Posts: 642 Silver 1
    I'll know in a few days...
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • Options
    peteypetey Posts: 2,358 New member
    The issue was because a checkpoint process was blocking the backup process from running. As the backup was blocked for more than 30 seconds, SQL Backup aborted the backup process, and attempted it again later when the blocking process completed. The alternative was to use a timeout value longer than 30 seconds.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    PDinCAPDinCA Posts: 642 Silver 1
    Had just one VDI Timeout failure early today. Far fewer incidents but not "cured" yet.
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • Options
    PDinCAPDinCA Posts: 642 Silver 1
    2 weeks on and failures are down to 1 per week or less. Much improved.

    "Thread Ends".
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
Sign In or Register to comment.