ʹѺʹع SQL Server Ѻÿŷҷ

ź ź
Ţ (Article ID): 819546 - ԵѳǢͧ㹺
· | غ

Һ˹ҹ

ػ

Ƕ֧ѭҷسͧԨóͤس˹Ѻ蹢ͧ Microsoft SQL Server ҾǴẺᵹŹ Ẻ

º¡ʹѺʹع

ҹʹѺʹعѺ˹ Ѻ蹢ͧ SQL Server ԹᵹẺᵹŹ ẺԹᵹͧ SQL Server:
غҧµҧ
ԹᵹẺᵹŹԹᵹͧ
SQL Server 2000ѺʹѺʹعѺʹѺʹع
SQL Server 2005ѺʹѺʹعѺʹѺʹع
SQL Server 2008ѺʹѺʹعѺʹѺʹع
SQL Server 2008 R2ѺʹѺʹعѺʹѺʹع
SQL 2012ѺʹѺʹعѺʹѺʹع
SQL 2014ѺʹѺʹعupported

˵ ˹¡աҧҵ仹:
  • ÿŷҷ
  • ÿ˹
  • Mountpoints
  • ش
  • شÿ

ԹᵹẺᵹŹ

ԹᵹẺᵹŹͧ SQL Server èѴ红źشͨѺʹѺʹع Windows Server SQL Server ѺʹѺʹع㹢й ҧá Դ SQL ͧվ鹰ҹÿͧÿ˹յѡêÿǢͧ ÿͧÿ˹ҹյѡêÿǢͧ Դ駨С˹ѡêÿѴŧÿ

˵ ˹ѡêÿ Դ駨

Ѻ ԡŢ仹ʹٺ㹰ҹͧ Microsoft:
834661 Ѿ 2000 ͧ SQL ͧյѡêÿͤسÿ˹

Թᵹͧ

Թᵹͧ SQL Server 2000 红źشͨѺʹѺʹع õԴ SQL Server 2000 ѺʹѺʹعá˹ҤըشҨشѺԹᵹͧ SQL Server 2000

ԹᵹǢͧ SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 2012 SQL 㹨شͨѺʹѺʹع ҧá õԴ SQL Server ١ӡѴӹǹѡâͧÿ ѧ ҤسѡкÿҹѺкԺѵԡ жѡÿ ÿ컡 ÿըشͷʵ سӡѴԹ 25 Թᵹ SQL Server ͤ

ÿŷҷ ҵ سöѡêÿҧԧѺʡҡ ҧ Ҥسյѡêÿ R: ҧԧ֧Ԣͧʡ سö "˹" ʡ ÿáѡкÿ R: ͧʡ ÿŷ繵ͧѡêÿͧͧ

ͤþԨóҨشҵѺ SQL Server մѧ:
  • õ駤 SQL ͧ ÿͧÿ˹ҹյѡêÿǢͧ ѺõԴ駤 ÿ鹰ҹͧÿẺ Guid ͧÿѺʹѺʹع蹹
  • ҹÿ ÿա˹ѡêÿ ҹöѹҧԹᵹͧ ͨӡѴͧẺѺ բͨӡѴԹᵹ
  • Ѵѧͤس駤ҤǢͧس ÿ鹰ҹ Сҷʡ 繷Ѿҡ㹡Ѿҡ õ駤 SQL Server Ǩͺá˹ÿǹ˹觢ͧõԴẺ
    ˵ ǷҧԺѵԷշش ѡ A B Ѻ ҧá 觹ŴӹǹͧԹᵹԹᵹ 23 ͤ
  • Ѿҡâͧ SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 SQL Server 2012 ѺѾҡê͢ SQL ѺѾҡúʡҧҾ红 شÿʵͧʴ繷ѾҡäʡҧҾ ͡ҡ ʡҧҾյѡâͧÿÿŷҷͧѧ繡â鹵͡ѹͧ SQL Server
  • ҤسӡõԴ Էҧԧ١ͧ١駤 ʡҧҾյѡêÿǢͧ ش Էâ鹵͡ѹ١駤ѵѵҧõԴ
˵ѧѹ سͧõԴ SQL Server 2008 SQL Server2008 R2 Ẻ slipstreamed ֧ûѺاШ繵ͧ service pack
  • Դ slipstream SQL Server 2008 SQL Server 2008 Service Pack 3 ᾤࡨѺا 9 Ѻ SQL Server 2008 Service Pack 3
  • SQL Server 2008 R2 slipstream ԴẺյ仹:
    • 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 繵ͧҶ֧Թ絨鹢ͧ Microsoft update ͡ҡسҨ觢ͧ繵 Դ駡ûѺاԡ SQL Server
Ӥѭ Ңй سԵ÷ѴPCUSOURCECUSOURCEͤسõԴ slipstream 鹰ҹѺ SQL Server 2008 SQL Server 2008R2SQL Server 2012 2014 ûѺاѵѵҧõԴ駢й

Ӥѭ Ҥس slipstream ҹ 蹢ͧ slipstream ͧѧ㹵˹ҺҷԹᵹͧ SQL Server

Ӥѭ سͧҧԧ١ͧ SQL Server 2005 蹢ͧ SQL Server 2008 Service Pack 2 蹡͹˹ҹµͧ ͡ҡ سͧҧԧ١ͧ㹡õԴ駷աҧԧ

ҡ§ҧԧ㹴ʡҧҾҡ 鹵ͨشҵ ¢ͧҹŨԴ ¢ͧҹҨԴҧ÷ӧҹ SQL Server ÷Ѿҡôʡ¹ͿŹ СѺѧʶҹ͹Ź˹

蹷ѺʹѺʹع㹻Ѩغѹͧ Windows ʹѺʹعÿ˹㹤 ҧá ͧҡ բͨӡѴ 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 ÿöѴ§ ᷹ subdivided ŧÿŨӹǹҡ·ء¹õ駤

· SQL Server ҵʡҧҾʵ˹ ش ͷ繤͸Ժ¢ͧҷж١ʴ麹ʡҧҾ 觨ռšѺʡѺҷѺԹᵹͧ SQL Server

SQL Server 2008 R2 ҧ ѡêÿöҧԧѧÿͧʹʡ:
  • Server\MSSQL10_50 SQL Files\Microsoft X:\ProgramId ͧԹᵹ\Data
    ˵ 鹷ҧ
  • Server\MSSQL10_50 SQL Files\Microsoft X:\ProgramId ͧԹᵹ\Log
  • Y:\Temp
  • Z:\MSSQL10_50Id ͧԹᵹ\Backup
㹺ҧʶҹó سҨá͡ҡҡ ҧ ÿ Z: ʡҧҾʵͧҷ ҷҡͧشá˹ ˹ҡѺʹѺʹع سͧá͡ҡҡ ҧ سö MP1 :

غٻҾٻҾ
2815286


ʶҹó:
  • Z:\MountPoint1 繤͹෹Ѻÿŷҷ
  • Z:\MountPoint1\MP1 ÿŷҷá ͤسԴ SQL Server öӡõ駤 SQL ˹ ͤسԴ SQL Server سöкص仹:

    Z:\MountPoint1\MP1|DBLog1
觪سкص˹觷駢ͧѹ֡áշժ DBLog2 DBLog3 ͡ҡѧسҷ Z:\MountPoint2\MP1\Log1 Z:\MountPoint2\MP1\Log2 ͡ҡ سö˹ʵáѺҹ tempdb ͧ

仹 ҧͧâ鹵͡ѹͧ§ҹʴҵѧҹ:

غٻҾٻҾ
2815287


ἹҾ:
  • ʡ 1աҧԧ
  • ҧԧ4 ʡ ˹觡á˹1 ʡ
  • 4 ʡ ˹觡á˹աҧԧ
  • IP: xxx.xxx.xxx.88աҧԧ
  • IP: xxx:xxxx:c0:xxxx.xxxx:c597:8cb0:49f2աҧԧ
  • : SOFTYҧԧ IP: xxx:xxxx:c0:xxxx:xxxx:c597:8cb0:49f2 IP: xxx.xxx.xxx.88
  • ͢ SQL (SOFTY)繵ͧҧԧ IP
  • â鹵͡ѹͧSQL Serverѧ: SOFTYФʡ 4, Mountpoint1 ʡ
  • SQL Serverաҧԧ
˹ʴ㹵ǨѴáäÿ:

غٻҾٻҾ
2815288



͹:ҤسµԴ SQL Server ѧáҡ سҨöԴ service pack ѺاҢй سҧ õǨͺʹͧͧҹŻѨغѹ DBCC CHECKDBШҡ °ҹѧسҧ ѺǡѺԸա÷蹹 ѧ˹䫵 Microsoft Developer Network (MSDN) 仹:

ǷҧԺѵԷշشͤسÿ˹ش

仹ǷҧԺѵԷշشͤسشá˹ÿ:
  • ӡҧԧẺÿŷҷʡѾҡ÷кشʡʵҵش 觷ÿŷҷѺдѺ§ʵ Ъ ÿʵ͹Ź͹
  • Ҥس¡ҵͷҡʡѹ˹ѧʡ蹷ѹ ôǨͺ ʡѹ㹡ǡѹ
  • ͧдѺҡ (ʵ) ѺشẺ͡Է੾кؤ ÿҡÿŷشʵ Ẻ֡ѴŴҷͧ¡׹Ҷ֧ÿŷҷҤس繵ͧ¡ͧ Chkdsk.exe ҧҡ 觨ЪŴҷ㹡ä׹Ҩҡͧÿʵ
  • ҤسдѺҡ (ʵ) Ẻ͡Է੾кؤѺش͢Ҵͧÿʵͧҧ 5 亵 (MB) 觹Ŵ繷ÿŨѺͧѾ蹹͡˹ͨҡش ѹ


ҧԧ

ѺǡѺÿ˹ ԡŢ仹ʹٺ㹰ҹͧ Microsoft:

2216461 õԴ SQL Server 2008 㹡õԴ駺ҵẺ Windows Server 2008
237701 Cacls.exe öʹѡͧҵͷ
2686690 : Դ駤Ǣͧ SQL Server 2012 ҴԴҹԴ͵ǨͺèѴ红Ẻ
2777358 SQL Server 2008 R2 Service Pack 1 + ࡨûѺا 4 Ѻ SQL Server 2008 R2 SP2
2783135 ᾤࡨѺا 10 Ѻ SQL Server 2008 R2 Service Pack 1
280297 Ըաá˹Ҩشá˹ÿźͧ Microsoft
295732 Ըաҧҹ ¹˹觷ʡ캹ÿѹ SQL Server 2000 Դ
832234 سöԷáҡͧÿкẺ NTFS Windows Server 2003
835185 ҧԧѾҡä SQL Server
878531 سö͹õԴ SQL Server 2012 աҧԧ¨ش
934012 ͤʴͼԴҴͤسԴ SQL Server 2005 㹡ҵͷ: "§ͺʡѺõԴ SQL Server Ѩغѹ·ҧ"
947021 Ըաá˹Ҩشá˹ÿź Windows Server 2008
955392 ԸաûѺا ԻʵõԴ駢ͧ SQL Server 2008
956008 ѧҡسԴ SQL Server 2008 㹴ʡСͺ¡á˹ÿ աҧԧж١ҧҧÿŷҷʡ

ѺǡѺشá˹ÿ 价䫵ͧ Microsoft 仹:

˹

ѺǡѺسѡɳСûѺاԵѳ SQL Server 2012 价䫵 MSDN 仹:


ûѺاԵѳ㹡õԴ SQL Server 2012


ѺǡѺÿ˹ Ǣ͵仹˹ҵҧԸ͹Ź:
  • "Windows Server 2003 Ը"
  • "ʡТ"
  • "èѴôʡТ"
  • "èѴôʡ"
  • " NTFS ҷÿ"

سѵ

Ţ (Article ID): 819546 - Ǥش: 3 Ҥ 2557 - Revision: 10.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 2005 Server Enterprise
  • 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 2005 Server Workgroup
  • 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
  • Microsoft SQL Server 2014 Business Intelligence
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Enterprise Core
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Web
Keywords:
kbsql2005cluster kbhowto kbinfo kbmt KB819546 KbMtth
¤
Ӥѭ: «ͿŴ¤ͧ Microsoft ᷹繹ѡŷ繺ؤ Microsoft պ¹ѡкŴ¤ سöҶ֧㹰ҹͧ Ңͧسͧ ҧá Ŵ¤Ҩբͺͧ ҨբͼԴҴ㹤Ѿ ٻẺҡó ǡѺóշǵҧҵԾٴԴ;ٴҢͧس Microsoft ǹѺԴͺͤҴ͹ ԴҴͤ·ԴҡҼԴҴ ͡麷Ţͧ١ Microsoft աûѺاͿŴ¤繻Ш
仹繩Ѻѧɢͧ:819546

ʹ

 

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