Restore of Microsoft SQL 2005 database fails with error 0xe0008492 - Database Query Failure.

Article:TECH87705  |  Created: 2009-01-07  |  Updated: 2014-01-14  |  Article URL http://www.symantec.com/docs/TECH87705
Article Type
Technical Solution


Environment

Issue



Microsoft SQL 2005 database redirect restore fails with error with error 0xe0008492 - Database Query Failure.


Error



 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
 Restore- <Servername>\BKUPEXEC V-79-65323-5110 - An error occurred on a query to database <DB name>

Following event id is recorded on the destination SQL server:
 
Event Type:   Error
Event Source: Backup Exec
Event Category: None
Event ID:  57859
Description: An error occurred while executing the following query: "RESTORE DATABASE <DB name>FROM virtual_device = '<DB name>_Restore_00__2bdeeb45_d853_4753_8237_0fc9974c437e_' WITH REPLACE, NORECOVERY , MOVE '<DB name>' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<DB name> Restore_Data.MDF', MOVE '<DB name>_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<DB name> Restore_log.LDF'".
 
SQL error number: "0CB9". 
SQL error message: "There is insufficient free space on disk volume 'C:\' to create the database. The database requires 13058834432 additional free bytes, while only 5872215552 bytes are available".
 

Solution




Make sure that there is enough free disk space available on the drive where the redirected restore is targeted to.

 

Supplemental Materials

SourceUMI
ValueV-79-57344-33938
Description

An error occurred on a query to database.


SourceError Code
Value0xe0008492
Description

Database Query Failure.


SourceEvent ID
Value57859
Description

An error occurred while executing the following query: "RESTORE DATABASE <DB name>FROM virtual_device = '<DB name>_Restore_00__2bdeeb45_d853_4753_8237_0fc9974c437e_' WITH REPLACE, NORECOVERY , MOVE '<DB name>' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<DB name> Restore_Data.MDF', MOVE '<DB name>_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<DB name> Restore_log.LDF'".


SourceError Code
Value0CB9
Description

"There is insufficient free space on disk volume 'C:\' to create the database. The database requires 13058834432 additional free bytes, while only 5872215552 bytes are available".


Legacy ID



327502


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


Terms of use for this information are found in Legal Notices