????????? DBCC SHRINKFILE
???????????? ???????[ 2014/5/4 10:46:55 ] ????????????? DBCC
??????????е???????????????????δ??????????????С??????????????????Ч?????????????????????γ????????????С????????????????ú??б???????????????????????????С??????????????????????????????????????????????????????????????????????????
????????????β????????????磬????и? 5 GB ?????????????dbcc shrinkfile ????н? target_size ???? 4 GB????????????潫??????????? 1 GB ??????????????????????б?????????????ù??????????????????????Щ????·??????????????????????????????????????????????????磬?????? 5 GB ????????? 4 GB ?????????????dbcc shrinkfile????н? target_size ???? 3 GB?????????? 1 GB??
????????????
???????????????ASFCORE?????????????30G???????????1G??????????????????????????????????
????????????recovery_model_desc????
????SELECT NAME?? recovery_model_desc FROM sys.databases
?????????FULL?????????SIMPLE????
????ALTER DATABASE ASFCORE SET Recovery simple
????????????????С(??λ??M)
????DBCC SHRINKFILE (N'ASFCORE_log' ?? 10)
?????????????????
????USE ASFCORE
????SELECT NAME?? size FROM sys.database_files
?????????FULL????
????ALTER DATABASE ASFCORE SET Recovery FULL
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11