Solved

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

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Operating an LTO on a W7 workstation 2 51
Solaris SUN OS 4.1.3 machine clone 2 63
Undelete of overwritten files 27 81
WD MybookLive Data disappear 6 29
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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…

786 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