笔记324 查看数据页头部中的DIFF 位,显示的是当前数据库系统页的状态不是本数据页的状态 2013-7-17

笔记324 查看数据页头部中的DIFF  位,显示的是当前数据库系统页的状态不是本数据页的状态 2013-7-17

 1 --查看数据页头部中的DIFF  位,显示的是当前数据库系统页的状态不是本数据页的状态 2013-7-17
 2 GAM (1:2) = ALLOCATED                SGAM (1:3) = ALLOCATED              
 3 PFS (1:8088) = 0x61 MIXED_EXT ALLOCATED  50_PCT_FULL                      DIFF (1:6) = CHANGED
 4 -------------------------------------------------------------------
 5 USE [pratice]
 6 GO
 7 
 8 --DROP TABLE pagediff
 9 CREATE TABLE pagediff(id INT IDENTITY(1,1) NOT NULL ,telephone VARCHAR(200))
10 GO
11 
12 INSERT INTO pagediff
13 SELECT '13678945612' UNION ALL
14 SELECT '13978985612' UNION ALL
15 SELECT '13178945852' UNION ALL
16 SELECT '13478978312' UNION ALL
17 SELECT '13778545631' UNION ALL
18 SELECT '13978963852' UNION ALL
19 SELECT '13078363612' UNION ALL
20 SELECT '13578944713'
21 GO
22 
23 
24 
25 
26 --TRUNCATE TABLE [dbo].[DBCCResult]
27 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,pagediff,-1) ')
28 
29 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC
30 
31 DBCC IND(pratice,Department,-1)
32 
33 
34 -------------------------------------------------------
35 DBCC TRACEON(3604,-1)
36 GO
37 
38 DBCC PAGE([pratice],1,14465,3)
39 GO
40 
41 BACKUP DATABASE [pratice] TO DISK ='pratice_fullbackup_2013-7-16'
42 
43 DBCC TRACEON(3604,-1)
44 DBCC PAGE([pratice],1,6,3) --实际上是第7页

 

posted @ 2013-08-04 21:51 桦仔 阅读(...) 评论(...) 编辑 收藏