???? ????? ??? ??? ????? ??? ??? ???????? ?? ????? ???????? ?? SQL Server: "????? ????? ??? ?????..."

?????? ????????? ?????? ?????????
???? ???????: 814574 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

??? ????? ??? SHRINKFILE DBCC ?? ???? ??????? SQL ????? ??? ??? ????????? ?????? ?? ????? ?????? ?? ????? ??? ??? ???????? ?? ?? ????? ????? ????? ???????:

????? ????? ??? ????? < ???? ????? ??? ???????? > (< ???????? ??? ??? ????? >) ???? ?? ???? ?? ???? ?????? ??? ????? ????? ??????? ??? ?? 2.

??????? ????

????? ???? ??? ??? ?????? ???? ??? ??????? ? ????? ????? ??? ??? ???????? ???????? SHRINKFILE DBCC ?????.

?????

?????? ??? ??????? ??????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
272318 ????? ??? ???????? ?? SQL Server 2000 ?? SHRINKFILE DBCC

324432SHRINKFILE DBCC ?????? SHRINKDATABASE ?? ?? ???? ???? ?? ???? sparsely ntext ?? ??? ????? ???

80629??? ????????? ?????? ??????

317375??? ????????? ????? ??? ???? ??? ????? ?? ???? ???? ??? SQL Server


????? ?? ?????????? ?? ?????? ????? Microsoft ??????? ??? ?????:
Shrinking the Transaction Log

DBCC SHRINKFILE

Attaching and Detaching a Database

???????

???? ???????: 814574 - ????? ??? ??????: 14/????? ??????/1428 - ??????: 5.6
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbsysadmin kbprb KB814574 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????814574

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

 

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