??????????????
????SQL Server 2008 R2 Active/Passive Nodes??Windows Server 2008 R2 SP1 Cluster?? vSphere 5.x
???????????
????6 am ???Application Team???? BiztalkMsgBoxDb????suspect??????????????
???????????????????????
?????????App Manager?綽???￡????????Apps????down time????Ticket????????????????????????????з??????κα?????????????Ticket?????????email???????????綽Incident Manager???????е???????￡?????????????????????????????????????????????????????
??????????????
????6:30 am??????綽??????????????????brainstorm???suspect????????????????饗??????????????????????/SAN Disk??????????????
??????Error Log????λ??????????
????6??40 am?????????????????????? Log backup????1?????????????????OS Error??????LogWriter??log flush????д?????????????д???????????suspect.
2014-03-17 03:15:56.05 spid5s      Error: 17053?? Severity: 16?? State: 1.
2014-03-17 03:15:56.05 spid5s      LogWriter: Operating system error1117(failed to retrieve text for this error. Reason: 15105) encountered.
2014-03-17 03:15:56.05 spid5s      Write error during log flush.
2014-03-17 03:15:56.05 spid79      Error: 9001?? Severity: 21?? State: 4.
2014-03-17 03:15:56.05 spid79      The log for database 'BizTalkMsgBoxDb' isnot available. Check the event log for related error messages. Resolve anyerrors and restart the database.
2014-03-17 03:15:56.05 spid85      Error: 9001?? Severity: 21?? State: 4.
????????????:
????1117 OS?????й????.??????????????????????????????log file????
????????γ????DBCC Repair
????(?κγ????????????????:???????????????????????)
???????ALTER DATABASE [xxxxxx]SET EMERGENCY;
???????????????????????????alter database ????????DBCC CHECKDB (N'xxxxxxx'?? REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS?? ALL_ERRORMSGS;?????
?????????????? DBCC Repair ?????????? emergency???￡????????????????log ??????????????????(consistent recover)????? log?????? ????? ????? log ( ???????????repair allow data loss??????? ?????????100 GB?????????? rebuild log?????????С????????recovery time object (RTO)?? SLA ??service level agreement) ?? ?????????????  downtime  ??? ???o??????????????????alter database?????????????????database log locked?? ?????????? log??????? corrupt?? ?????б?????dbcc repair???
?????o???????????log file corrupted ???????dbcc  repair??? methodology ?????????????????????????????????????????15?????active transaction ????????????????? ( ?15 ??????????????????????ο??????????????  downtime?????????????δ?????????????????database backup restore?????methodology??????????????????file corrupted?????????server team?????IO????