?????? ????? ???????? ????????? ??? ?? SQL Server 2005 ????? ???? ???? ??????? "??? ????" ? "???? ??????? Autogrowth ?????

???? ???????: 949523 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

???????

???? ??? ????????? ??????. ?? Microsoft SQL Server 2005 ????? ????? ?????? ???????. ??? ??? ????????? ?????? ?????? ??????? ???? ??????? ??? ???? ? ???? ??????? Autogrowth ?????. ?? ??? ?????????? ??? ?????? ????? ???????? ????????? ?????.

????? ?? ????????? ??? ????? ????? ?????? ????? ???????? ????????? ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms151846.aspx
(http://msdn2.microsoft.com/en-us/library/ms151846.aspx)
???????? ??? ???? ??? ?????? ?????? ?? ??????? ????? ????? ????? ??????? ??? ?????? ?? ???? ?????? ??? ???? ???????:
?????? ??????.
???? ??? ?????? | ????? ???????

?????

???? ??? ??????? ????? ??? ??? ????? ??? ???????? ???? ?? ???????. ??? ?? ????? ???? ??? ???? ?? ??? ??? ??????? ????????? ???? ?? ??? ????? ????? ????? ????????. ????? ?????? ??? ?????? ?????? ???? ???? ??????? sp_replcmds ???????. ?????? ???? ??? ?????? ????? ???? ????? ????? ??????? ?? ????? ????????? ???? ?? ??? ????? ????? ????? ???????? ???? sp_replcmds.

????? ?? ????????? ??? ????????? ?????? ????? ??? ??????? ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/ms179355.aspx
(http://msdn2.microsoft.com/en-us/library/ms179355.aspx)
???? ??? ?????? | ????? ???????

???? ??????

??????? ?????? ??? ??? ??????? ???? ??????? ???????:
  1. ????? ??? ??? ?????? ??? ????? ?????? ???????. ??? ??? ???????? ??? ????? ????????? ???????:
    • ????? ?????? ????.
    • ???? ??????? Autogrowth ????.
    ?????? ??? ??? ?????? ??? ????? ?????? ??????? ?????? ????? ALTER ????? ?????? ?? ????? ADD ??? ???. ????? ?? ????????? ??? ????? ALTER DATABASE ?? ?????? ???? MSDN ??????:
    http://msdn2.microsoft.com/en-us/library/ms174269.aspx
    (http://msdn2.microsoft.com/en-us/library/ms174269.aspx)
  2. ?????? ??????? SHRINKFILE DBCC ?????? ??? ????? ??? ???????? ???? ????? ??? ??? ????? ??? ???????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
    907511
    (http://support.microsoft.com/kb/907511/ )
    ????? ??????? ???? SHRINKFILE DBCC ?????? ??? ??? ???????? ?? SQL Server 2005
???? ??? ?????? | ????? ???????

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".
???? ??? ?????? | ????? ???????

??????? ????

??? ????? ????? ?????? ???? ???? ????????? ?????? ?????? ????? ?? ????? ?????? ??????? ???? ?????? ??? ???? ????? ????? ????? ??????? Autogrowth. ??? ?????? ????? ?????? ?????? ??????. ????? ??????? ?????? ??????? ???? ????? ????? ???? ????? ??? ?? ?????? ?????????? ??????? ??? ????????. ???? ??? ?????? ???? ????????? ???? ?? ???? ?? ????? ????? ????????. ?? ?????? ????????? ????? ???? ??? ????? ????? ???? ?????. ???????? ??? ???? ????? ????? ???????? ?????? ????? ???? ?????? ?? ????? ????. ?? ??? ?? ???? Autogrow ??????? ??????? ???? ???????? ?????? ????? ???????.
???? ??? ?????? | ????? ???????

???????

???? ???????: 949523 - ????? ??? ??????: 27/???/1429 - ??????: 1.2
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
????? ??????: 
kbmt kbexpertiseadvanced kbtshoot kbprb KB949523 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????949523
(http://support.microsoft.com/kb/949523/en-us/ )
???? ??? ?????? | ????? ???????

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

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