?????????????????????????????????CNBlogsText?????????????23G?????????????????????Truncate???????????????С??1G????????23G???????1G????????????????????????????????????????л???????????????￡??????????????????????????????????????

??????????????????????Shrink????????????????????????????????

Cannot shrink log file 2 (CNBlogsText_log) because of minimum log space required.

?????????????????????д????????-SQL Server 2008???????????????????????????????

?????? ???????????????Full?????????Simple??

?????? ??????Shrink????????

?????? ????????????Simple???????????Full??

???????????????????????????????????????????

??????????и?????????????????????????

????1??Detach?????Detach?????????????ж??????????д??????????????????

????2???????????????????

????3??Attach????????????????????????

 

????4?????(Remove)???????????????????????Ok????Attach??SQL Server????????????????????????????????μ??????????Attach??

????5????????????????????????·??????????Detach/Attach?????????????????????

?????? Detach?????

?????? ??????????????μ?λ??

?????? Attach????????????????·???????Attach

?????÷??????????????????????????????????????????

???????????????????SQL Server??????????????????????о???????????????????????????????????????÷????