create DATABASE T --數據庫不能是簡單模式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--停服務--用ue打開數據文件 找 aaaa，修改 隨便改DBCC checkdb (t) --驗證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) --驗證