Solved

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

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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Storage Pool - Software 7 80
Client backup and data retention? 3 67
how to run a TSM script twice a day? 9 60
VMware SRM - Datastore not showing in Array Replication 11 122
We planned to use NetApp's SnapManager for Exchange (SME) to make three snapshots a day for quick recovery. Additional we planned to use Symantec NetBackup7 to backup to tape media for disaster recovery. We followed the best practice guide from NetA…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
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 steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

749 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