1ï¼å¨SQL Serveré建ç«ä¸ä¸ªä¾æ¢å¤ä½¿ç¨çæ°æ®åº(æ¯å¦pos).
2ï¼åææ°æ®åºæå¡å¨. ã
3ï¼å°åæçæçæ°æ®åºçæ¥å¿æ件pos_log.ldfå é¤ï¼ç¨è¦æ¢å¤çæ°æ®åºmdfæ件è¦çåæçæçæ°æ®åºæ°æ®æ件pos_data.mdf. ã
4ï¼å¯å¨æ°æ®åºæå¡å¨ãæ¤æ¶ä¼çå°æ°æ®åºposçç¶æ为âç½®çâãè¿æ¶åä¸è½å¯¹æ¤æ°æ®åºè¿è¡ä»»ä½æä½ã ã
5ï¼è®¾ç½®æ°æ®åºå
许ç´æ¥æä½ç³»ç»è¡¨ãæ¤æä½å¯ä»¥å¨å¯¹è±¡èµæºç®¡çå¨éé¢éæ©æ°æ®åºæå¡å¨ï¼æå³é®ï¼éæ©âå±æ§âï¼å¨âæå¡å¨è®¾ç½®â页é¢ä¸å°âå
许对系ç»ç®å½ç´æ¥ä¿®æ¹âä¸é¡¹éä¸ãä¹å¯ä»¥ä½¿ç¨å¦ä¸è¯å¥æ¥å®ç°ãã
useãã master ã
go ã
exec sp_configureãã 'allow updates',1 ã
goãã ã
reconfigureãã withãã override ã
goããã
6. 设置pos为紧æ¥ä¿®å¤æ¨¡å¼
update sysdatabases set status=-32768 where dbid=DB_ID('pos') ã
7. ä¸é¢æ§è¡çæ£çæ¢å¤æä½ï¼é建æ°æ®åºæ¥å¿æ件ãã
dbcc rebuild_log('pos','D:Program FilesMicrosoft SQL ServerMSSQLDatapos_log.ldf') ã
ãã--æ§è¡è¿ç¨ä¸ï¼å¦æéå°ä¸åæ示信æ¯ï¼ ã
ãã--æå¡å¨:ãã æ¶æ¯ãã 5030ï¼çº§å«ãã 16ï¼ç¶æãã 1ï¼è¡ãã 1 ã
ãã--æªè½æå®å°éå®æ°æ®åºä»¥æ§è¡è¯¥æä½ã ã
ãã--DBCCãã æ§è¡å®æ¯ãå¦æãã DBCCãã è¾åºäºé误信æ¯ï¼è¯·ä¸ç³»ç»ç®¡çåèç³»ã ã
ãã--说ææ¨çå
¶ä»ç¨åºæ£å¨ä½¿ç¨è¯¥æ°æ®åºï¼å¦æåææ¨å¨Fæ¥éª¤ä¸ä½¿ç¨å¯¹è±¡èµæºç®¡çå¨æå¼äºposåºçç³»ç»è¡¨ï¼é£ä¹éåºå¯¹è±¡èµæºç®¡çå¨å°±å¯ä»¥äºã ã
ãã--æ£ç¡®æ§è¡å®æçæ示åºè¯¥ç±»ä¼¼äºï¼è¦å: æ°æ®åº'pos'çæ¥å¿å·²é建ã已失å»äºå¡çä¸è´æ§ãåºè¿è¡ãDBCCãCHECKDBã以éªè¯ç©çä¸è´æ§ãå°å¿
é¡»éç½®æ°æ®åºé项ï¼å¹¶ä¸å¯è½éè¦å é¤å¤ä½çæ¥å¿æ件ã ã
8ï¼éªè¯æ°æ®åºä¸è´æ§ï¼å¯çç¥ï¼ãã
dbcc checkdb('pos') ã
9ï¼è®¾ç½®æ°æ®åºä¸ºæ£å¸¸ç¶æãã
exec sp_dboption 'pos','dbo use only','false' ã
10ï¼æåä¸æ¥ï¼æ们è¦å°æ¥éª¤5ä¸è®¾ç½®çâå
许对系ç»ç®å½ç´æ¥ä¿®æ¹âä¸é¡¹æ¢å¤ã
ã
exec sp_configureãã 'allow updates',0 ã
goãã ã
reconfigureãã withãã override ã
go
追é®å¤§ç¥ï¼è½ä¸è½ææ件åç»ä½ 帮æéå çä¸ä¸ï¼è½å¤ççè¯ï¼å¨å åé½å¯ä»¥ï¼