recheld

用SQL Agent 完全备份一个数据库,在恢复操作时总显示以下错误:

Job Completion Status
Job ended: 2007年11月13日 at 10:16:12
Completed status: Failed
Final error: 0xe0008492 - Database Query Failure. See the job log for details.
Final error category: Resource ErrorsFor additional information regarding this error refer to link V-79-57344-33938

怎么处理才可以恢复成功?

[ 本帖最后由 recheld 于 2007-11-13 10:29 编辑 ]

dengbao2001

能不能把全部的详细日志贴出来？

recheld

Restore Set Information
Restoring data to AXP-SQ .
Storage Media #1: " Media created 2007-11-13 9:18:58 "
Backup performed on 2007-11-13 at 9:41
Backup set #4: " SQL Axapta "

Restore Set Detail Information

Database SikaTest
Database pubs
Database Northwind
Database msdb
Database model
Database master
V-79-57344-33938 -
An error occurred on a query to database master.
Database JNDB
Database AXTST
V-79-57344-33938-
An error occurred on a query to database AXTST.

Database Consistency Checks
Consistency checking SikaTest
Consistency Check including Indexes.
Consistency check was completed.
Consistency checking pubs
Consistency Check including Indexes.
Consistency check was completed.
Consistency checking Northwind
Consistency Check including Indexes.
Consistency check was completed.
Consistency checking msdb
Consistency Check including Indexes.
Consistency check was completed.
Consistency checking modelConsistency Check including Indexes.
Consistency check was completed.
Consistency checking JNDB
Consistency Check including Indexes.
Consistency check was completed.

Restore Set Summary

Restored 8 databases
2 items were skipped.
Processed 460525449 bytes in 5 minutes and 47 seconds.
Throughput rate: 75.9 MB/min

[ 本帖最后由 recheld 于 2007-11-14 14:32 编辑 ]

dengbao2001

建议你看看Symantec的知识库，来解决这个问题。
http://seer.entsupport.symantec.com/docs/281881.htm
http://seer.entsupport.symantec.com/docs/262416.htm

根据你的环境，与知识库描述对照，看看发生了什么问题。

popgo

http://seer.entsupport.symantec.com/docs/275542.htm

[ 本帖最后由 popgo 于 2007-12-14 11:00 编辑 ]

runner

建议系统数据库和用户数据库分开进行还原。