2007年10月19日

老師有沒有講~資料庫災後復原DIY 誤砍資料篇


老師有沒有講處理資料時
要小心、要小心、要小心
優待會員加入,下次資料亂掉時可以 CALL IN 0800-06-449(你北瀅瀅領六素素叫)

資料庫災後復原DIY 誤砍資料篇

setp1. backup transaction log

backup log powereip to disk ='c:\eip.bak'

setp2. find the last full backup restore with no recovery

restore database bb from disk ='c:\okk2.dat' with move 'PowerEIP' to 'd:\eip.mdf' ,move 'PowerEIP_Log' to 'd:\eip_log.mdf' ,norecovery

setp3. restore transaction log with recovery time ,try try see load data and find miss data time

restore log bb from disk = 'c:\eip.bak' with recovery, stopat= '2007/10/19 10:15:00'
Share/Save/Bookmark

0 意見: