????? ??????

Select the product you need help with

????????? ?? ??? ??????? ???? ???? ????? ???????? ?????? ????? SQL Server

???? ???????: 873235 - ??? ???????? ???? ????? ????? ??? ???????.

??? ??? ?????? ??????? ???? ??? ???? ??????? ????? ????? ??? ??? ????????? ?????? ????? ?????. ???? ?????? ????????? ?????? ?? ???? ????? ?????? Microsoft SQL Server ??? ????? ?????????. ??? ??? ?????? ????? ?????? ????? ????????? ?????? ?????? ?????? ??? ??? ????? ????????? ?? ??????? ????? ??? ??????.

???? ??? ?????? | ????? ???????

??????? ????

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

??? ????? ??? ???? ?? ???? ??? ??? ?? ????? ????????? ?? ??????? ???? ??? ???? ????? ?????. ??? ???? ???? ???? ?? ????? ????????? ??? ?????? ?? ??? ????????? ???? ????? ???? ??? ??? ?????????.

?????? ??? ????? ????????? ?????? ?????? ?????? ??? ????? ????????? ???? ????? ????????. ????? ??? ???? ??? ??? ??????? ?????? ?????? ????????? ??? ??? ??? ???? ???????? ?? ????? ???????? ?????? ????????? ????.

????? ?? ????????? ??? ????? ????? ??? ????? ?????????? ???? ????? ???? ????? ?????? ?????? ????? Microsoft:

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

(http://msdn.microsoft.com/ar-sa/library/aa174524(en-us,SQL.80).aspx)

????? ??? ????? ????????? ?????? ????? SQL Server 2005

(http://technet.microsoft.com/ar-sa/library/ms178037(en-us,SQL.90).aspx)

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

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

?????? ?? ????????? ??? ??? ????????? ???? ?? ???? ???? ???????? ????? ???? ????? ???? ??? ??? ??? ??????? ?????? ????????? ??? ?????? ??????? ???? ????? ????? ?? ??????? ????? ??????? ????? ?????????? ?????? ?????????? ???? ????? ????????? ?????? ????????? ??? SQL Server Books Online:

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

????? ????? ??? ????????? ??? ?????? ?? ??? ??? ????????? ???????? ????? ????????. ????? ?? ????????? ???????? ??? ????? ?????? ????? ?????????? ???? ??????? ????? ?? "?????? ????? ?????????" ??? SQL Server Books Online.

??? ??? ?? ???? ??????? ????? ????? ????????? ??????? ???? ?? ???? ???? ???????? ?? ????? ???????? ??????? ??? ??? ?? ???? ?????? ????????? ?????? ?????????.

?????? ??? ??????? ?????? ??? ???????? ???? ?? ???? ??? ?????? ????? ????? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (?? ????? ??? ??????? ??? ???????? ??? ????? ?????? ?????????? (????? ?? ??? ?????? ???)):

62866

(http://support.microsoft.com/kb/62866/ar/ )

??????? ???? ??? ??????? ????? ??????? SQL ????????

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

????? ????? ????????? ?? ????? ???????? ?? ???? ?? ??? ??? ?????. ?????? ??? ??? ??? ?????????? ???? ?? ????? ??? ??? ????????? ????. ?????? ??? ??? ??????? ????? ??????? ?????? ??????? ??? ?????????? ????? ???? ??????? ????? DBCC SHRINKFILE. ???? ??????? "DBCC SHRINKFILE Transact-SQL" ????? ????? ??? ????? ???? ??? ?????.

?????? ?? ???? ?????? "DBCC SHRINKFILE Transact-SQL" ?????? ????? ?????? ??? ??????? ????????? ???? ??? ????? ?? ????? ?????.

????? ?? ????????? ??? ????? ????? ????? ?????????? ???? ??????? ??? ????????? ??????? ?? SQL Server Books Online.

????? ??? ??? ?????????
DBCC SHRINKFILE

?????? ??? ??????? ?????? ??? ????? ????? ????? ????? ????????? ???? ???? SQL Server 2000? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (?? ????? ??? ??????? ??? ???????? ??? ????? ?????? ?????????? (????? ?? ??? ?????? ???)):

272318

(http://support.microsoft.com/kb/272318/ar/ )

????? ??? ????????? ???? ???? SQL Server 2000 ???????? ????? DBCC SHRINKFILE

?????? ??? ??????? ?????? ??? ???????? ???? ?? ???? ??? ????? ??? ????? ????? ?????????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft" (?? ????? ??? ??????? ??? ???????? ??? ????? ?????? ?????????? (????? ?? ??? ?????? ???)):

814574

(http://support.microsoft.com/kb/814574/ar/ )

???????: ????? ?????: "????? ????? ??? ?????..." ???? ??? ??????? ????? ????? ?????? ??? ??? ??? ?????????

324432

(http://support.microsoft.com/kb/324432/ar/ )

???????: ?? ????? ??? ????? "DBCC SHRINKFILE" ?????? "SHRINKDATABASE" ???? ?????? ??????? ?? ?? ntext ?? ????? ?????

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

???? ??? ????? ????? ????????? ???? ??? ?????? ???? ?????? ???? ????? ???????:

?? ???? ??? ????? ??? ????????? ??? ???? ????? ?? ????? ???????? ???????? ?????? ??? ?????????.
?? ?????? ?????? ???????? ?????? ??? ????????? ???????? ????? ??????? ????? ?? ?????? ??????? ???? ??? ????? ???????? ?????? ????? ?????? ???????.

?????? ??? ??????? ?????? ??? ?????????? ?????? ?????? ?????? ????? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ?????? ???)):
315512
(http://support.microsoft.com/kb/315512/ar/ )
?????????? ?????? ?????? ???????? ?????? ??????? ????????
????? ????? ?????????. ?? ???? ???? ????? ?? ??? ?? ????????? ???? ?? ???? ???????? ????? ???????? ?????? ?? ??? ????? ??? ????? ???????? ? ????? ????????? ???????? ???? ????? ????????. ????? ???? ????? ???????? ???????? ?? ????? ???????? ????? ????? ??????? ??? ????? ????????? ??????? ????? ???? ?????? ??? ???? ????? ????????? ???????? ???? ??? ???? ??? ?? ??? ???? ?? ????? ?????? ????????:
- ????? ????????? ??????
- ????? ????????? ??????
- ????? ????????? ?? ???? ??????? ??????
??? ??????? ????? ????????? ??????? ????? ??????? ????? ???????? ??? ??? ????? ??? ??????? ?? ??????? ??? ????? ????????. ??? ??????? ????? ????????? ?????? ?? ????? ????????? ???????? ??????? ????? ??????? ????? ???????? ??? ????? ???? ?? ??? ??? ???????? ???? ?? ???? ??????? ????? ???????? ?????? ?? ?? ????? ?????????? ?????? ????? ?????????.

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

????? ????? ????? ????????? ?? ??????? ?????? ?????? ??? ?? ??? ?? ???? ???????? ????? ????? ????????? ????? ????? ??????? ???????? ??????.
???? ?????? ?????? ????????? ?????? ????? ???????? ????? ?????? ??? ???? ???? ????????? ??? ?????? ?? ??? ????????? ????.
???? ?????? ??? ????????? ???? ???? ???? ?????.
?? ??? ?? ????? ????????? ??? ???????? ????? ?? ????? ???? ??? ?????.
?? ?????? ?????? ???????? ??????? ???? ??? ??????? ???? ????.
????? ????? ????? ??????? ?? ???? ???? ????? ????? ???? ???? ??????? ????? ?????? ????? "DBCC INDEXDEFRAG Transact-SQL" ????? ?? "DBCC DBREINDEX Transact-SQL". ?? ???? ???????? ??????? "DBCC DBREINDEX"? ???? ???? ??? ????????? ???? ????? ????? ??????? ????? ????????? ?????? ?? ????? ?????? SQL Server ?????? ??. ???????? ??? ???? ?? ????? ????? "DBCC INDEXDEGRAG" ??????? ??????? ???? ????? ??? ??? ????? "DBCC DBREINDEX".

?????? ?? ????????? ???????? ?? ????? ????? ????? ??????? ???? ???? SQL Server 2000? ???? ???? ????? ?????? ????? ????? Microsoft:
???? ????? ?????? ????? ????? Microsoft SQL Server 2000
(http://technet.microsoft.com/ar-sa/library/cc966523(en-us).aspx)
??? ?????? ???????? ????? "DBCC DBREINDEX" ?????? ?????? ??? ????? ?? ??? ????? ????? ????????? ???? ???? ????? ??? ??????? ??? ??? ?????. ???????? ??? ???? ????? ???? ????? ??????? ????? ????????? ?????? ????????? ????? ?????? ????? ????? ?????? ???????.

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

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

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

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

?????? ??? ??????? ?????? ??? ???????????? ???? ?? ???? ??? ????? ????? ????????? ???? ??? ?????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (?? ????? ??? ??????? ??? ???????? ??? ????? ?????? ?????????? (????? ?? ??? ?????? ???)):

317375

(http://support.microsoft.com/kb/317375/ar/ )

???? ??? ????? ????????? ???? ??? ????? ?? ????? ??? SQL Server

???? ??? ?????? | ????? ???????

?????

????? ?? ????????? ???????? ??? ??????? ??????? ?????? ???????? ??????? ???????? ??? ????? ????? ????? ?????????? ??? ???? ??? ????? "??????? ??? ??????? ??? ?????" ???????? ??? SQL Server Books Online. ????? ?? ????????? ???????? ??? ???? ????? ?????????? ???? ??????? ??? ????????? ??????? ?? SQL Server Books Online.