Frequent failure of SQL Server 2008 Backups by using EMC Legoto


We have configured SQL Server backups through EMC Networker, Legoto on our environment and maximum servers were Virtual Servers. We found backup failures frequently due to following error found Event viewer Application log.

Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).                                   SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=10492. Thread=4724. Client. Instance=. VD=Global\Legato#4692dfe4-a07d-4934-9600-db5ba4c3e513_SQLVDIMemoryName_0.

Instance settings:

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2769.0 (X64)   Jun 24 2011 13:09:43   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

4 system and 1 user database.
Processors :4
memory settings:
Min: 6553 MB
Max: 6553 MB
Max worker Threads:
config_value: 0 run_value:0

Please provide feasible solution for this issue.

Thanks & Regards,
Chandra Mohan KanithiPrincipal Consultant - DatabaseAsked:
Who is Participating?
theruckConnect With a Mentor Commented:
if it is virtual machines giving these errors your virtualization host can be overloaded during the backup hence do networking misbehaviour. try to run the backups on different time of the day one by one if you come to the same error
Are you backing up the databse using the SQL agent which was granted rights in the sql server security?
Does the system have the VSS and shadow copies enabled?
You also excluded the directory (data,log) to avoid the filesystem backups from trying to backup the active database/transaction log files.
If you do not have the SQL agent for legato, you need to use sql maintenance plan to backup the database to disk backup directory often and then let legato filesystem backup capture those .bak files.
Daniel_PLDB Expert/ArchitectCommented:

Can you look at the log folder and post errors from xbsa.messages file?
(Example location: C:\Program Files\Legato\nsr\applogs\xbsa.messages)
Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Chandra Mohan KanithiPrincipal Consultant - DatabaseAuthor Commented:
I found following messages on 'C:\Program Files\Legato\nsr\applogs\xbsa.messages' folder.

XBSA-1.0.1 rb_nmsql522.Build.23 5980 Mon Jul 22 05:17:51 2013           _nwbsa_is_retryable_error: received a retryable network error (Severity 0 Number -13): retry needed
XBSA-1.0.1 rb_nmsql522.Build.23 5980 Mon Jul 22 05:18:22 2013           _nwbsa_is_retryable_error: received a retryable network error (Severity 0 Number -13): busy
Daniel_PLDB Expert/ArchitectCommented:
Following is description of your messages derived from Legato's Error Message Guide:

Received a retryable network error (Severity <n> Number <n>): busy
Message Source
Message Type
The backup server might be busy. The network operation will be retried
automatically until it succeeds.
If this error occurs too many times in a row:
• Verify that the backup server is running.
• Verify that the network protocols are functioning properly. Test by
running ping.

Maybe your backup server is overloaded or your network connection is not working properly. I think you could verify network connection settings/reliability both from vm and host perspective (since you are using virtual servers)
David ToddSenior DBACommented:

Do your guests have the disk 'thin provisioned'? While great for labs and testing, its not recommended for production database servers.

Chandra Mohan KanithiPrincipal Consultant - DatabaseAuthor Commented:
We found one more error related to VSS in event viewer.

Volume Shadow Copy Service error: Unexpected error calling routine ConvertStringSidToSid.  hr = 0x80070539.
Daniel_PLDB Expert/ArchitectCommented:
In following topic you can find that this VSS error may be related due to problematic profile in profiles list:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.