[20140711] SQL Server page还原

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) --验证