sql 2000 recovery dbcc checkdb dbcc checktable

之前介紹過使用 Transcation LOG recovery 資料
現在介紹DBCC語法

Dbcc check db

Setp 1. single user mode

Use master
sp_dboption dbname, single, true

Setp 2. dbcc checkdb -> list table

Dbcc checkdb (db_name) -> find error table

Setp 3. Dbcc checktable

option :
REPAIR_ALLOW_DATA_LOSS
REPAIR_FAST
REPAIR_REBUILD
-------------------
EX: dbcc checktable ( company,REPAIR_REBUILD)

REF: http://technet.microsoft.com/zh-tw/library/ms174338.aspx

sql 2000 recovery dbcc checkdb dbcc checktable

老師有沒有講～資料庫災後復原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'

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