Solved

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

Posted on 2008-10-14
3
534 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
  • 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

Superior storage. Superior surveillance.

WD Purple drives are built for 24/7, always-on, high-definition security systems. With support for up to 8 hard drives and 32 cameras, WD Purple drives are optimized for surveillance.

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.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
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…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now