INF: ??? ????????? ?? SQL Server 2000 ?? SHRINKFILE DBCC ?????

?????? ????????? ?????? ?????????
???? ???????: 272318 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ????? ?? SQL Server 2000 ?? ??? ????? ???????. ????? ????? ????? ????? ????? ??????. ??? ???? ?? ??? ??????? ?? ???? ???????? ?????? ??????? ?????? ??? ????? ??? ????? ??? ????? ???????.

??????? ????

??? ????? SHRINKFILE DBCC ????? SQL Server 2000 ??? ????? ?? ???? ????? ?????? ?? ????? ????? ??????? ??? ???? ?????? ?????? ??? ??? ?????. ??? ?? ??? ?????? ??? ??? ????? ????? ??? SQL Server ??????? ????? ???? ?? ??? ??? ????? ??? ??? ?? ????? ??????? ????? ????? ??? ????? ??? ????? ?????. ????????? ??????? ?? ?????? ?????? ????? ??? ?????????:
  1. ??? ????? ????? "??? ????? ?????????" ?????? ????? ?????? ????? ??? ?????? ?? ?????.
  2. ??? ????? SHRINKFILE DBCC ??? ???? ?? ??? ????? ??????? ??? ????? ??? ????? ??? ????? ?????.
?????? ?????? ???? ??? ?? ????? ?????? pubs (????????) ?????? ????? ????? pubs_log ??? 2 ???? ????:
  1. ????? ??? ????????? ????????:
    DBCC SHRINKFILE(pubs_log, 2)
    						
    ??????: ??? ?? ??? ?????? ??? ??? ????? ? ????? ??? ?????? ???????.
  2. ????? ??? ????????? ???????? ??? ??? ???? ?? ?????? ??? ???????? ?? ???????? ???? ???????? ?? ??? ?????????. ????? Truncate_only ????? ????? ????????? ??? ????????. ?????? ???? ????? ????????? ?????? ???????? ??? ????? ????? ????????? ??? ?????? truncate_only:
    BACKUP LOG pubs WITH TRUNCATE_ONLY
    - ?? -
    ????? ??? ????????? ???????? ??? ??? ???? ?? ???????? ???? ???????? ??? ????????? ?????? ??? ????? ????? ????? ????????? ??? ????????. ???? ??????? "????? ?????????" ??? SQL Server ??? ?????? ?????? ??? ???? ?? ?????????:
    BACKUP LOG pubs TO pubslogbackup
  3. ????? ??? ????????? ????????:
    DBCC SHRINKFILE(pubs_log,2)
    					
    ??? ?? ????? ???????? ???? ????? ??? ?????.

?????

????? ?? ?????????? ???? ???????? ????? "??? ?????????" ? SHRINKFILE DBCC ?? SQL Server 2000 ????????.

?????? ??? ??????? ?????? ??? ????? ??? ???????? ?? SQL Server 7.0 ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
256650INF: ????? ????? ??? ????????? SQL Server

???????

???? ???????: 272318 - ????? ??? ??????: 12/?????/1424 - ??????: 3.4
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbinfo KB272318 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????272318

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com