create DATABASE T --數(shù)據(jù)庫不能是簡(jiǎn)單模式goUSE tGOCREATE TABLE t(id INT IDENTITY,value CHAR(8000))GOINSERT INTO dbo.t        (  value )VALUES  (          REPLICATE('a',5000)          )go 5BACKUP DATABASE t TO DISK = 'c:/t.bak' WITH INITgo--停服務(wù)--用ue打開數(shù)據(jù)文件 找 aaaa，修改 隨便改DBCC checkdb (t) --驗(yàn)證goRESTORE DATABASE t PAGE = '1:90' FROM DISK='c:/t.bak' WITH NORECOVERYgoBACKUP LOG t TO DISK='c:/t.log' WITH INITgo    RESTORE LOG t FROM DISK ='c:/t.log'goDBCC checkdb (t) --驗(yàn)證