发新话题
打印

Back exec 10备份恢复SQL数据库总出问题

Back exec 10备份恢复SQL数据库总出问题

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 编辑 ]

TOP

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

TOP

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 编辑 ]

TOP

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

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

TOP

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

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

TOP

建议系统数据库和用户数据库分开进行还原。
存储技术QQ群19277737,58620565,欢迎一起探讨存储技术!
博客www.yoalex.cn,虚拟化及存储技术论坛bbs.freexen.cn
创新科存储技术有限公司 www.uit.com.cn
MSN:runner79@msn.com

TOP

发新话题