Redirected restore of SQL 2005 database fails with "Final error 0xe0008492 - Database Query Failure."

Article:TECH128692  |  Created: 2010-01-12  |  Updated: 2013-08-26  |  Article URL http://www.symantec.com/docs/TECH128692
Article Type
Technical Solution


Issue



Redirected restore of SQL 2005 database fails with "Final error 0xe0008492 - Database Query Failure."


Error



Final error 0xe0008492 - Database Query Failure

An error occurred on a query to database ReportServer. V-79-65323-1834

V-79-65323-3634 - The operating system returned the error '5 (Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'DATABASE PATH\DATBASENAME_Data.mdf'.

Errors in Event Logs.

Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 3634
Description:
The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'DATABASEPATH\DATABASENAME_Log.ldf'.
 
Event Type: Error
Event Source: Backup Exec
Event Category: None
Event ID: 57859
Description:
An error occurred while executing the following query: "RESTORE DATABASE [database name] FROM virtual_device = 'databasename_00__cafa8b68_a71a_4efd_8230_ce217b873b1a_' WITH REPLACE, NORECOVERY , MOVE 'logname' TO 'DATABASE PATH'\database name.mdf', MOVE 'logname_log' TO 'DATABASE PATH'\Log\database name_Log.ldf', MOVE 'INDEX NAME' TO 'DATABASE PATH'\database name.mdf', MOVE 'INDEXNAME' TO ''DATABASE PATH'\database name.mdf'".

Solution



  1. Retry the restore job of the backup in non operational mode.
  2. Verify if the SQL Server service (MSSQLSERVER) on the target server is running under the Local System Account.
  3. Make sure there is enough disk space and user has the following permissions: Local Administrator rights and SQL Administrator role on the SQL Server.
  4. Created a new database on the target server and configure the restore job to redirect to the test database and selected the option "Use this path" to specify the database path.
     

Supplemental Materials

SourceUMI
ValueV-79-65323-3634
Description

The operating system returned the error '5(Access is denied.)'


SourceError Code
Value0xe0008492
Description

Database Query Failure.


SourceEvent ID
Value3634
Description

The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'DATABASE PATH'\DABATASENAME_Log.ldf'.
 


SourceEvent ID
Value57859
Description

An error occurred while executing the following query: "RESTORE DATABASE ...."



Legacy ID



350188


Article URL http://www.symantec.com/docs/TECH128692


Terms of use for this information are found in Legal Notices