Solved

Error backing up SQL databases, Connection Error during Consistency check.

Posted on 2008-10-14
3
539 Views
Last Modified: 2013-12-01
I'm running backup Exec 11d on a Win2k3 server.  For the past week I've been getting the following error while trying to backup SQL databases.

An unknown or unexpected database error occurred while attempting a DBCC.
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

This happens during the consistency check and only happens on this server. ( I don't experience it on the other SQL servers.)  I've tried restarting the SQL server experiencing these problems to no avail.  I've combed the error logs and a connection is established between the backup server and SQL server.   About 30-40% through the DBCC the connection error starts to show up.  It will process the first 20-30 DBs before I get the dreaded "An unknown or unexpected database error occurred while attempting a DBCC."
It does not stop on a specific database either... The connection error has started on a different DB on each backup iteration.
Any ideas on where to start troubleshooting this problem?  I can't find any information on Symantec's website and I haven't applied any updates / changes to the 2 servers....
0
Comment
Question by:SharePointNub
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
RobinHuman earned 500 total points
ID: 22712552
Have you got Advanced open file on?
Try removing 1 DB from the backup list, and see if that makes a difference
 
0
 

Author Comment

by:SharePointNub
ID: 22714165
I do have advanced open File on.

I'm removing a single DB from the list... I'll let you know tomorrow if I have any success.
0
 

Author Closing Comment

by:SharePointNub
ID: 31505873
There was a rogue database causing problems.  A DB was stuck in "restore" causing connection problems.  Thanks.
0

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to fix error ""Failed to validate the vCentre certificate. Either install or verify the certificate by using the vSphere Data Protection Configuration utility" when you are trying to connect to VDP instance from Vcenter.
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question