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)證
新聞熱點(diǎn)
疑難解答
圖片精選