首页 > 代码库 > [20140711] SQL Server page还原

[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.loggoDBCC checkdb (t) --验证