about DBCC problem

lucyeva 2003-05-03 09:52:24
各位,你好, 我在做數據庫backup時,遇到如下問題,

Job server: HRMSSTBY
Job name: Restore 0151
Job started: 2002年12月12日 at AM 09:30:48
Job type: Restore
Log file: BEX12.txt
======================================================================

Drive and media information from media mount:
Drive Name: HP 0
Media Cartridge Label: 4M000002

======================================================================
Job Operation - Restore
======================================================================
Restoring data to HRMSSTBYhrmstest0.

Storage Media #1: " Media created 2002/12/11 05:34:23 PM "
Backup performed on 2002/12/11 at 05:34 PM
Backup set #1: " Backup 0150 "
Restore started on 2002/12/12 at 09:31:31 AM.

Restore completed on 2002/12/12 at 10:05:30 AM.
Restored 1 database(s)


Processed 603,963,392 bytes in 20 minutes and 51 seconds.
Throughput rate: 27.625 MB/min
----------------------------------------------------------------------
Consistency checking hrmstest0
There was a problem running the DBCC.
SQL Server returned the following error message:

Allocation Discrepancy: Page is allocated but not linked; check the following pages and ids: allocation pg#=236288 extent id=236512 logical pg#=236513 object id on extent=1372531923 (object name = payr_tx) indid on extent

特別是出現
There was a problem running the DBCC.
SQL Server returned the following error message:

Allocation Discrepancy: Page is allocated but not linked; check the following pages and ids: allocation pg#=236288 extent id=236512 logical pg#=236513 object id on extent=1372531923 (object name = payr_tx) indid on extent
指出 table payr_tx 有問題, 我該如何處理 ?




======================================================================
Job ended: 2002年12月12日 at PM 05:13:23
Job completion status: Failed
======================================================================

...全文
80 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

34,591

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧