asked on

Backup Exec Failing with database Query error

Our backup is failing with the following errors:

Job ended: 26 May 2006 at 11:13:12
Completed status: Failed
Final error: 0xe0008492 - Database Query Failure. See the job log for details.
Final error category: Resource Errors

Backup- SQLSRVR V-79-57344-33938 -
An error occurred on a query to database TornadoWireLive.
V-79-57344-33938 - Database 'TornadoWireLive' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
V-79-57344-33938 -
An error occurred on a query to database ReportServerTempDB.
V-79-57344-33938 - 0x2000e208 (536928776)
V-79-57344-33938 -
An error occurred on a query to database ReportServer.
V-79-57344-33938 - 0x2000e208 (536928776)
V-79-57344-33938 -
An error occurred on a query to database pubs.
V-79-57344-33938 - 0x2000e208 (536928776)
V-79-57344-33938 -
An error occurred on a query to database Northwind.
V-79-57344-33938 - 0x2000e208 (536928776)
V-79-57344-33938 -
An error occurred on a query to database NavisionObjectTestDb.
V-79-57344-33938 - 0x2000e208 (536928776)
V-79-57344-33938 -
An error occurred on a query to database msdb.
V-79-57344-33938 - 0x2000e208 (536928776)
V-79-57344-33938 -
An error occurred on a query to database model.
V-79-57344-33938 - 0x2000e208 (536928776)
V-79-57344-33938 -
An error occurred on a query to database master.
V-79-57344-33938 - 0x2000e208 (536928776)
V-79-57344-33938 -
An error occurred on a query to database GoLiveTestDb.
V-79-57344-33938 - 0x2000e208 (536928776)
V-79-57344-33938 -
An error occurred on a query to database AdventureWorks2000.
V-79-57344-33938 - 0x2000e208 (536928776)

We cannot seem to fix it - help please!!!

rindi

Do you have the SQL agent installed? Maybe you should also use the SQL manager to make sure the databse is still OK.

Powerhousecomputing

ASKER

yeah we have SQL agent installed - SQL Manager looks fine,

ASKER CERTIFIED SOLUTION

David_Fong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

beeker

The accepted answer is incorrect. The poster's problem is related to a problem with Backup Exec and the Remote Agent version disparity. This has nothing to do with the SQL server. Pity that a forced accept is done when the answer is wrong.

kgreeneit

Hi Beeker, I've just come accross your comment on the open discussion for this question, do you have a solution or pointer to the Backup Exec and Remote Agent version disparity?

oks1977

Hi,

I have checked on the link by David Fong,
http://support.microsoft.com/kb/180500/EN-US/

It does not work, does the community have any other solutions?

rindi

If you have a problem, please open a new Q ask it there.

oks1977

Hi Rindi,

Ok. Will do so. Thanks.