- 论坛徽章:
- 0
|
各位大侠:
master 数据库 dbcc checkalloc 出现如下问题
sp_dboption master,single,true 无效
checkpoing 也无效。如何解决呢???
Alloc page 512 (# of extent=31 used pages=114 ref pages=106)
Alloc page 768 (# of extent=32 used pages=244 ref pages=244)
Alloc page 1024 (# of extent=22 used pages=65 ref pages=65)
Alloc page 1280 (# of extent=32 used pages=222 ref pages=222)
Alloc page 1536 (# of extent=30 used pages=141 ref pages=139)
Alloc page 1792 (# of extent=1 used pages=1 ref pages=1)
Msg 2546, Level 16, State 1
Table Corrupt: Extent id 2248 on allocation pg# 2048 has objid 8 and used bit on, but reference bit off.
Alloc page 2048 (# of extent=3 used pages=20 ref pages=12)
Alloc page 2304 (# of extent=4 used pages=32 ref pages=31)
Alloc page 2560 (# of extent=1 used pages=1 ref pages=1)
Alloc page 2816 (# of extent=1 used pages=1 ref pages=1)
Alloc page 3072 (# of extent=1 used pages=1 ref pages=1) |
|