Solved

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

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
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…

623 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