????? ??????

Select the product you need help with

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

???? ???????: 819546 - ??? ???????? ???? ????? ????? ??? ???????.

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

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

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

??????

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

????? ?????

????? ???? ????? ???????? ??????? ??? ????? SQL Server ???? ?? ??? ??? ???? SQL Server ???? ????? ?? ?????? ????????:

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

???????	???? ?????	???? ?????? ????????
SQL Server 2000	?????	??? ?????
SQL Server 2005	?????	?????
SQL Server 2008	?????	?????
SQL Server 2008 R2	?????	?????
SQL Server 2012	?????	?????

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

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

???? ?????

?? ???? ????? ?? SQL Server? ??? ?????? ????? ???????? ??? ???? ????? ??? ????????? ???????? ????? ?? Windows Server ? SQL Server. ??? ???? ????? ?????? ????? SQL Server ????? ??????? ??????? ?? ???? ????? ???? ????? ??? ???? ????? ??????. ??? ?? ??? ??? ???? ????? ????? ???? ??????? ??????? ?? ???? ????? ????? ?????? "???????" ????? ??? ???? ??????? ??????? ?????? ????? ???????.

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

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":

834661

(http://support.microsoft.com/kb/834661/ )

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

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

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

??? ????? ??? ???? ?????? ???????? ?? SQL Server 2005 ?? SQL Server 2008 ?? SQL Server 2008 R2 ?? SQL Server 2012? ???????? ????? ??? ???? ????? ???? ?????. ??? ???? ????? ?????? ??????? ?????? ???????? ?? SQL Server ??? ??? ???? ?????? ??????? ????????. ????? ??? ??? ?????? ??? ???? ????? ???? ??? ????? ???????? ?????? ???? ???? ?????? ??????? ?????? ??????? ?????? ?????? ??????? ?? ?????? ????? ???? ???????? ???? ?????? ???? ?????? ????? ??? ???? ?? 25 ?????? SQL Server ?? ???? ?????? ????? ?????.

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

???????? ???? ????? ?????? ????? SQL ????? ????? ????????? ???? ?? ???:

????? SQL Server ????? ???? ??? ???? ????? ????? ???? ??????? ??????? ?? ???? ????? ????. ???????? ???? ?????? ????? ?????? ??? ?? ???? ???? ??????? ??????? ??? ???? ????? ?????? ????????. GUIDs ???? ??????? ??? ?????? ?? ??? ???????.
???? ??????? ??????? ?? ???? ??????? ???? ?? ????? ??? ???? ???????. ?? ???? ?????? ??????? ??? ?????? ???? ?????? ????? ?????. ??? ?? ??? ?????? ???????? ????? ????? ?? ?? ??? ????? ??? ????? ?????? ???? ??????.
?? ????? ??? ????? ???? ?????? ????? ????? ????? ?? ?????? ?? ?? ??? ??? ?? ?? ???? ??????? ???????? ???????? ??????? ?? ????? ??????? ?????? ?? ?????? ?????. ????? SQL Server ??????? ?? ??? ????? ???? ??????? ???? ?? ????? ????? ???? ?????? ????? ?????.
??????�??????? ????? ?? ?????? ?????? A ?? B ?????. ??? ???? ???? ???? ??? ???? ???????? ??????? 23 ?? ????.
?????? SQL Server 2005 SQL Server 2008? SQL Server 2008 R2 ? 2012 ???? SQL ????? ??? ???? ??? ???? ??????? SQL ?????? ????? ??????? ???? ????? ?????????. ??? ?? ??? ????? ????? ??? ?????? ???? ???? ??????? ????? ??????? ??????. ???????? ??? ???? ??? ????? ????? ?????? ????? ??? ??? ???? ????? ??? ???? ????? ????? ?????? SQL Server.
??? ??? ???? ????? ????? ??? ????? ???????? ??????? ??????? ??? ??????? ??????? ???? ????? ??? ??? ???? ????? ?????? ???? ???? ?????. ??? ????? ???????? ????? ???????? ????? ???????.

?????????????? ??? ???????? ??? ??????? ????? ????? SQL Server 2008 ?? SQL Server2008 R2 ???????. ????? ??? ??????? ???????? ????? ??????? ????????.

????? ?????? SQL Server 2008 ????? SQL Server 2008 Service Pack 3 ????? ??????? ???????? 9 SQL Server 2008 Service Pack 3.
????? ?????? SQL Server 2008 R2 ????? ?? ???:
- SQL Server 2008 R2 Service Pack 1
- ???? ??????? ???????? 10 ? SQL Server 2008 R2 Service Pack 1
- ???? ??????? ???????? 4 ? SQL Server 2008 R2 SP2
????? SQL Server 2012 ?? ????? ??????? ?????? ????? ??????? ???????? 6 ????? 2012 ???? SQL.

?????? ???? "??????? ??????" ?? SQL Server 2012 ????? ?????? ??? ??????.

??? ???? ???????? ???? ????? ??? ??????? PCUSOURCE ? CUSOURCE ??? ??????? ????? ?????? ??????.

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

??? ??? ????? ???????? ??????? ?????? ?? SQL Server 2005 ??? ????????? ?? SQL Server 2008 Service Pack 2 ?????????? ???????. ???????? ??? ???? ??? ???? ????? ???????? ??????? ?? ?????? ??????? ???? ????? ????????.

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

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

??????? ????

???? Windows Server 2003 ?????? ??????? ??????? ?? ????. ??? ???? ???? ???? ???? ?? SQL Server 2000? ??????? ????? ??????? ??????? ??? ???? ?????? ????? ??? ???? ???? ???? ???? ?????? ???????? ????? ??? SQL Server 2000 ??? ????? ??? ?? ???? ?????.

??????�????????? ??????? ?? ??? ??????? ??? ????????? ??????? ?? ???? Microsoft Press "SQL Server 2000 ???????." ???? ????????? ???? ??? ????????? ?? ????? 4? "????? ??????? ????? ?????" ?? ????? 2? "????? ???? Microsoft SQL".

???? ???? ??????? NTFS ???????? ???????. ???? ???? ?????? ??? ???? ????? ????? ??? ???? ????? ????. ????? ??? ????? ???? ?????? ???? ?????? ??? ?????????? ?????????? ???? ??????? ????? ???????? ???? ?????? ?????? ?? ???????? ??? ???? ??????? ????? ???????. ??? ???? ??????? ?????? ????? ???? ????? ?????? ???? ??????? x: ?????? R:\Mnt\XDrive ??????? ??? ???? ??????? r. ??? ????? ?????? ??????? ???? ????????? ???? ?????? ??? ???? ??????? x: "R:\Mnt\XDrive" ??? ?? ???? ???? ??? ???? ??????? r:.

??? ??????? ?????? ???????? ????? ????? ????? ??????? ???????? ??? ???? ??????? NTFS ????? ????? FAT 16-?? ???? ????? ISO 9660 ??? ???? ??????? ???????? ?? ???? ????? ????? ???? ??? ???? ????? NTFS ?????. ?? ?????????? ?? ????????? ??? ??????? ??? ???? ??????? ????? ??? ???? ??? ????. ???? ????????? ???? ??? ?? ???? ???? ?????? ???? ??? ???? ?? ???? ???? ?????? ???? ????? ??? ???? ??????? NTFS. ???? ????? ????? ??????? ?? ???????? ?? ??????? ??? ?????? ?? ????? ??????? ??? ?????? ??? ?????????? ?? ??????? ?????? ???????.

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

?? ?????? ?????? SQL Server 2008 R2? ???? ?? ???? ??? ???? ??????? ??? ???? ????? ???? ?? ??? ????:

Server\MSSQL10_50 SQL ?????????? X:\Program.???? ??????\Data
?????? ??? ?? ?????? ?????????.
Server\MSSQL10_50 SQL ?????????? X:\Program.???? ??????\Log
Y:\Temp
Z:\MSSQL10_50.???? ??????\Backup

?? ??? ????? ?????????? ?? ???? ???????? ???? ???. ??? ???? ??????? ??? ??? ???? ??????? z: ?? ??? ???? ?????? ?????? ??????? ?????? ?????? ?? ??? ???? ???????. ?? ???? ??????? ??????? ?????? ????? ??? ?????? ??? ??????? ???? ???. ??? ???? ??????? ????? ??????? ?????? MP1:

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

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

Z:\MountPoint1 ?? ????? ?????? ??????? ???????.
Z:\MountPoint1\MP1 ?? ???? ????? ????? ?????. ??? ????? SQL Server? ???? ????? ????? SQL Server ??? ???? ???? ?? ???? ?? ???????. ??? ????? SQL Server? ????? ????? ?? ???:

Z:\MountPoint1\MP1|DBLog1

???? ??? ??????? ????? ????? ??? ?????? ??? ??????? ???? ???? DBLog2 ?? DBLog3. ??? ???? ?? ????? ?????? ??????? ??? Z:\MountPoint2\MP1\Log1 ?? Z:\MountPoint2\MP1\Log2. ???????? ??? ???? ????? ????? ?????? ??????? ???? ?????? ??????? ?????? ????? ???????? ??? ?????? ?? ????? ??????????.

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

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

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

1 ??? ?????? ???? ??? ?????? ????????.
4 ??? ??????? ???? ????? ???????? ?? ???????? ????? 1.
4 ??? ??????? ???? ????? ?? ???????? ????????.
????? IP: xxx.xxx.xxx.88 ?? ????? ????????.
????? IP: xxx:xxxx:c0:xxxx.xxxx:c597:8cb0:49f2 ?? ????? ????????.
?????: ???? ???????? ????? IP: xxx:xxxx:c0:xxxx:xxxx:c597:8cb0:49f2 ? ????? IP: xxx.xxx.xxx.88.
????? ??? ???? ????? SQL (????) ???????? ?? ????? IP.
???????? SQL Server?????: ????? 4 ??? ?????? ????? ???? ????? ? ???????? ????? 1.
????? SQL Server ?? ????? ????????.

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

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

??? ??? ?????? ?????? SQL Server ??? ???? ???? ??? ???????? ?? ???? ?????? ???? ?????? ?? ??? ????? ????? ???????? ??????? ???????? ??????? DBCC CHECKDB ??? ??? ????? ???????? ??? ?????? ???? ??? ???????. ????? ?? ????????? ??? ????? ?????? ????? ????? ??? ??? ????? ??? ???? ????? Microsoft (MSDN) ??????:

??? ????? ?????? ????????: SQL Server 2012
(http://msdn.microsoft.com/en-us/library/ms345483.aspx)
??? ????? ?????? ????????: SQL Server 2008
(http://msdn.microsoft.com/en-us/library/ms345483(v=SQL.100).aspx)
??? ????? ?????? ????????: SQL Server 2005
(http://msdn.microsoft.com/en-us/library/ms345483(v=SQL.90).aspx)

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

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

??? ????? ?? ???? ????? ???? ????? ????? ???? ????? ???? ?????? ???? ???? ?????. ??? ???? ???? ??????? ??????? ????? ??? ???? ??????? ??????? ?????? ?? ?? ???? ???? ????? ?????? ??? ?????? ?????.
??? ??? ???? ???? ????? ?? ??? ????? ???? ??? ??? ????? ???? ???? ?? ?? ??????? ???????? ???? ?? ??? ????????.
???? ??????? ???? ??????? ????? (????) ????? ????? ?????. ??? ???? ??????? ?? ???? ????? ???? ?????? ???? ?????. ??? ??????? ???? ????? ??????? ???????? ?????? ??? ????? ??????? ??????? ??? ??? ???? ??? ????? ?????? Chkdsk.exe. ???? ???? ????? ??????? ????????? ?? ?????? ?????????? ??? ???? ??????? ??????.
??? ??? ?????? ???? ??????? ????? (??????) ????? ????? ????????? ?????? ??? ?? ???? ??? ???? ??????? ?????? 5 ???????? (MB) ??? ?????. ???? ???? ?? ?????? ?? ???? ??????? ???? ????????? ??? ??? ???? ???? ?????.

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

?????

????? ?? ????????? ??? ?????? ??????? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":

2216461

(http://support.microsoft.com/kb/2216461/ )

??? ????? SQL Server 2008 ?????? ??? ???? ????? ???? ???????? ??? Windows Server 2008

237701

(http://support.microsoft.com/kb/237701/ )

?? ???? ????? Cacls.exe ?????? ??? ??? ???? ????? ???? ?????

2686690

(http://support.microsoft.com/kb/2686690/ )

?????: ????? ???? ?????? ????? ??? SQL Server 2012 ?????? ????? ?????? ???? ??? ????? ?????? ?? ??? ??????? ?????? ????????

2777358

(http://support.microsoft.com/kb/2777358/ )

???? ??????? ???????? 1 + SQL Server 2008 R2 Service Pack 4 ? SQL Server 2008 R2 SP2

2783135

(http://support.microsoft.com/kb/2783135/ )

???? ??????? ???????? 10 ? SQL Server 2008 R2 Service Pack 1

280297

(http://support.microsoft.com/kb/280297/ )

????? ????? ???? ????? ???? ??????? ??? ???? ???? Microsoft

295732

(http://support.microsoft.com/kb/295732/ )

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

832234

(http://support.microsoft.com/kb/832234/ )

?? ????? ????? ???????? ??? ?????? ????? ????? ????? ???? ????? NTFS ?? Windows Server 2003

835185

(http://support.microsoft.com/kb/835185/ )

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

878531

(http://support.microsoft.com/kb/878531/ )

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

934012

(http://support.microsoft.com/kb/934012/ )

???? ????? ??? ??? ?????? ????? SQL Server 2005 ??? ???? ????? ???? ?????: "?? ???? ????? ????? ??? ????? ?????? ?????? SQL Server ???????"

947021

(http://support.microsoft.com/kb/947021/ )

????? ????? ???? ????? ???? ??????? ??? ???? ???? ?? Windows Server 2008

955392

(http://support.microsoft.com/kb/955392/ )

????? ????? ?? ???? ????? SQL Server 2008

956008

(http://support.microsoft.com/kb/956008/ )

??? ????? ???? ?????? ????? ??? SQL Server 2008 ?? ??? ????? ??? ???? ????? ?????? ??? ????? ??? ?????? ??? ????? ????? ??????? ???????

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

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

(http://msdn2.microsoft.com/en-us/library/aa365733.aspx)

????? ?? ????????? ??? ???? "????? ??????" ?? SQL Server 2012? ????? ??? ???? ??? MSDN ??????:

??????? ?????? ?? ????? SQL Server 2012

(http://msdn.microsoft.com/en-us/library/hh231670(v=SQL.110).aspx)

????? ?? ????????? ??? ?????? ??????? ???????? ???? ???????? ??????? ?? Windows ???????? ???????:

"??????? Windows Server 2003"
"????? ?????????"
"????? ??????? ?????????"
"????? ???????"
"?????? ??????? ??????? NTFS ????????"

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

???????

???? ???????: 819546 - ????? ??? ??????: 03/????�??????/1434 - ??????: 41.0

????? ???

Microsoft SQL Server 2008 R2 Datacenter
Microsoft SQL Server 2008 R2 Developer
Microsoft SQL Server 2008 R2 Enterprise
Microsoft SQL Server 2008 R2 Standard
Microsoft SQL Server 2000 64-bit Edition
Microsoft SQL Server 2000 Developer Edition
Microsoft SQL Server 2000 Enterprise Edition
Microsoft SQL Server 2000 Enterprise Evaluation Edition
Microsoft SQL Server 2000 Standard Edition
Microsoft SQL Server 2000 Workgroup Edition
Microsoft SQL Server 2005 Analysis Services
Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Enterprise Edition
Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
Microsoft SQL Server 2005 Enterprise X64 Edition
Microsoft SQL Server 2005 Evaluation Edition
Microsoft SQL Server 2005 Standard Edition
Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
Microsoft SQL Server 2005 Standard X64 Edition
Microsoft SQL Server 2005 Workgroup Edition
Microsoft SQL Server 2008 Developer
Microsoft SQL Server 2008 Enterprise
Microsoft SQL Server 2008 Enterprise Evaluation
Microsoft SQL Server 2008 R2 Standard Edition for Small Business
Microsoft SQL Server 2008 R2 Web
Microsoft SQL Server 2008 R2 Workgroup
Microsoft SQL Server 2008 Standard Edition for Small Business
Microsoft SQL Server 2008 Web
Microsoft SQL Server 2008 Workgroup
Microsoft SQL Server 2012 Analysis Services
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Developer
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Parallel Data Warehouse Beta
Microsoft SQL Server 2012 Standard
Microsoft SQL Server 2012 Web
SQL Server 2012 Enterprise Core

kbsql2005cluster kbhowto kbinfo kbmt KB819546 KbMtar

????? ????

???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????

???? ??? ????? ??????? ?????? ??????????819546

(http://support.microsoft.com/kb/819546/en-us/ )

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