about DBCC problem
各位,你好, 我在做數據庫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 有問題, 我該如何處理 ?
thank you
问题点数：0、回复次数：0Top
