Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14 dbcc checkstorage (mutubatch) go dbcc checkverify (mutubatch) go dbcc checkcatalog (mutubatch) go use dbccdb go sp_dbcc_summaryreport go sp_dbcc_faultreport 'short', mutubatch go
J'obtiens le Type Code : 100028 sur plusieurs tables
Dans le Troubleshooting and Error Messages Guide, 100028 :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8 Table Name Index Type Code Description Page Number ---------- ----------- ----------- ----------- ----------- sysobjects 0 100028 page misplaced 48 sysobjects 1 100028 page misplaced 1025 sysobjects 2 100028 page misplaced 1048 etc ....
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6 A page of the object was found in a location other than where allocations are currently allowed Activate Trace Flag 2513 AND run: dbcc indexalloc, dbcc tablealloc, or dbcc checkalloc Similar to 2558 ErrorJ'obtiens :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 use master go sp_dboption mutubatch,"single user", true use mutubatch go checkpoint go -- To turn on trace flag 2513, follow these commands: dbcc traceon (2513) go dbcc tablealloc (sysobjects, full, fix) go
Par contre là je commence par être perdu.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 *************************************************************** TABLE: sysobjects OBJID = 1 INDID=1 FIRST=49 ROOT=1040 SORT=1 Data level: 1. 113 Data pages allocated and 15 Extents allocated. Indid : 1. 1 Index pages allocated and 2 Extents allocated. INDID=2 FIRST=1056 ROOT=1058 SORT=1 Indid : 2. 24 Index pages allocated and 4 Extents allocated. TOTAL # of extents = 21 Alloc page 0 (# of extent=3 used pages=24 ref pages=24) Alloc page 256 (# of extent=1 used pages=8 ref pages=8) Alloc page 512 (# of extent=3 used pages=24 ref pages=24) Alloc page 768 (# of extent=2 used pages=16 ref pages=16) Alloc page 1024 (# of extent=6 used pages=28 ref pages=28) Alloc page 204800 (# of extent=5 used pages=39 ref pages=39) Alloc page 205056 (# of extent=1 used pages=3 ref pages=3) Total (# of extent=21 used pages=142 ref pages=142) in this database DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role. Extent not within segment: Object 1, indid 0 includes extents on allocation page 0 which is not in segment 0. Extent not within segment: Object 1, indid 0 includes extents on allocation page 256 which is not in segment 0. Extent not within segment: Object 1, indid 0 includes extents on allocation page 512 which is not in segment 0. Extent not within segment: Object 1, indid 0 includes extents on allocation page 768 which is not in segment 0. Extent not within segment: Object 1, indid 1 includes extents on allocation page 1024 which is not in segment 0. Extent not within segment: Object 1, indid 2 includes extents on allocation page 1024 which is not in segment 0.
Quelqu'un peut m'éclairer ?
Partager