Video Screencast Help

Final error: 0xe0008492 - Database Query Failure.

Created: 18 Mar 2009 • Updated: 22 May 2010 | 1 comment

Hello,

I am looking for someone who can help me to solve the problem.

 

Error Information:

-------------------------------------------------------------------------------------------------

Job completion status:

Job ended: 18 March 2009 at 1:02:51
Completed status: Failed
Final error: 0xe0008492 - Database Query Failure. See the job log for details.
Final error category: Resource Errors

For additional information regarding this error refer to link V-79-57344-33938
 

Errors:

Click an error below to locate it in the job log
Backup-ZSIS038

V-79-57344-33938 -
An error occurred on a query to database  UFDATA_007_2009 .
V-79-57344-33938 -
An error occurred on a query to database UFDATA_005_2009.
V-79-57344-33938 -
An error occurred on a query to database UFDATA_004_2009.
V-79-57344-33938 -
An error occurred on a query to database UFDATA_003_2009.
V-79-57344-33938 -
An error occurred on a query to database UFDATA_001_2009.

Exceptions:

Click an exception below to locate it in the job log
Backup- ZSIS038
The item UFDATA_007_2009 in use - skipped.
The item UFDATA_005_2009 in use - skipped.
The item UFDATA_004_2009 in use - skipped.
The item UFDATA_003_2009 in use - skipped.
The item UFDATA_001_2009 in use - skipped.

-------------------------------------------------------------------------------------------------------------

Base on the Error Info above, I checked "beremote.log" file, part of

 

[5940] 03/13/09 11:49:30 ******************************************************************
[5940] 03/13/09 11:49:30 **                                                                                       **
[5940] 03/13/09 11:49:30 **             SQL Agent Database Path Error                           **
[5940] 03/13/09 11:49:30 **                                                                                       **
[5940] 03/13/09 11:49:30 **    The database contains a path with extra backslashes.      **
[5940] 03/13/09 11:49:30 **    The database needs to be detached and then attached    **
[5940] 03/13/09 11:49:30 **    again using a corrected path.  See support website.        **
[5940] 03/13/09 11:49:30 **                                                                                       **
[5940] 03/13/09 11:49:30 ******************************************************************
 

I didn't see any backslashes in database. Maybe I didn't get the right way.

 

Have any suggestion?

 

Best Regard.

 

Hugo

 

 

Comments 1 CommentJump to latest comment

HiDefGator's picture

 

SQL has a bug in the tool used to create new databases.  It wil let you create a database with duplicate backslashes in the path.  An example would be

"c:\prog files\sql\data\\pubs.mdf"

 

notice the duplicate backslashes right before pubs.   Backup Exec has detected this problem and wants it fixed before it will agree to do the backup.  The extra backslash can cause problems at restore time. 

 

to fix it you need to detach the database and reattach it using good paths without the extra backslashes.