[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8507
  • Last Modified:

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!!!
0
Powerhousecomputing
Asked:
Powerhousecomputing
1 Solution
 
rindiCommented:
Do you have the SQL agent installed? Maybe you should also use the SQL manager to make sure the databse is still OK.
0
 
PowerhousecomputingAuthor Commented:
yeah we have SQL agent installed - SQL Manager looks fine,
0
 
David_FongCommented:
It sounds like a SQL problem, you probably have to use sp_resetstatus.
http://support.microsoft.com/kb/180500/EN-US/

Or ask in the SQL TA.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
beekerCommented:
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.
0
 
kgreeneitCommented:
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?
0
 
oks1977Commented:
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?
0
 
rindiCommented:
If you have a problem, please open a new Q ask it there.
0
 
oks1977Commented:
Hi Rindi,

Ok. Will do so. Thanks.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now