ʹѺʹع 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 Server 2012ѺʹѺʹعѺʹѺʹع

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

ԹᵹẺᵹŹ

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

˵ Ҥس˹ѡêÿ Դ駨

Ѻ ԡŢ仹ʹٺ㹰ҹͧ Microsoft:
834661SQL 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 Server clustering 仹:
  • õ駤 SQL ͧ ÿͧÿ˹ҹյѡÿǢͧ ѺõԴ駤 ÿ鹰ҹͧÿẺ Guid ͧÿѺʹѺʹع蹹
  • 鹰ҹÿ ÿա˹ѡêÿ ҹöѹҧԹᵹͧ բͨӡѴûѺ բͨӡѴ ͧ multi-instance
  • Ѵѧͤس駤Ҥͧس ʴ¡÷ÿ鹰ҹ Сҷʡ 繷Ѿҡ㹡Ѿҡ õ駤 SQL Ǩͺá˹ÿǹ˹觢ͧõԴ駤
    ˵ǷҧԺѵԷշش ѡ A B Ѻ ҧá ŴӹǹͧԹᵹͧԹᵹ 23 ͤ
  • Ѿҡâͧ SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 2012 ͧ SQL Ѿҡê͢ SQL зѾҡâͧʡҧҾ红 شÿʵͧʴ繷ѾҡäʡҧҾ ͡ҡ ʡҧҾյѡêÿÿŷҷͧѧö繷ҧԧͧ SQL Server
  • ҤسӡõԴ Էҧԧ١ͧ١駤 ʡҧҾյѡÿǢͧ ش Էâ鹵͡ѹաõ駤ѵѵҧõԴ
˵͵ͧѧѹ سͧõԴẺ slipstreamed SQL Server 2008 R2 Server2008 ͧ SQL ֧ûѺاШ繵ͧ service pack
  • Դ slipstream SQL Server 2008 SQL Server 2008 Service Pack 3 ᾤࡨûѺا 9 Ѻ SQL Server 2008 Service Pack 3
  • Դ slipstream 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
  • õԴ 2012 ͧ SQL աԴҹûѺاԵѳ 6 ᾤࡨûѺاѺ 2012 SQL Դ

    ˵ سѡɳСûѺاԵѳ 2012 SQL 繵ͧաҶ֧Թ
Ӥѭ Ңй سԵ÷ѴPCUSOURCECUSOURCEͤسõԴ slipstream 鹰ҹ

Ӥѭ Ҥس slipstream ҹ 蹢ͧ slipstream ͧѧҹ㹵˹ҺҷͧԹᵹͧ 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. R:\Mnt\XDrive ѧҡسҧ˹ ö鹷ҧ "R:\Mnt\XDrive" ͧҶ֧ÿ X: Ҩ캹ÿ R:

ͤسҷ سö unify кҧ к NTFS Ẻ 16 Եк FAT к ISO-9660 ÿմŧкẺͨԤŷ˹觺ÿ NTFS ǡѹ ءͧâǡѺÿ«繵˹觷駢ͧ˹ ŷسͧͤк鹷ҧẺҷ캹ÿ NTFS ÿö١Ѵ ᷹ subdivided ŧÿŨӹǹҡ ¼ء¹õ駤

· SQL Server ԴʡҧҾʵաá˹ ش 繤͸Ժҷж١ʴ繡úʡҧҾ

ҧ仹ͧ SQL Server 2008 R2 ѡкÿöҧ֧ҧҧ˹ÿͧʹʡẺ:
  • X:\Program Files\Microsoft SQL Server\MSSQL10_50Id ͧԹᵹ\Data
    ˵ 鹷ҧ
  • X:\Program Files\Microsoft SQL Server\MSSQL10_50Id ͧԹᵹ\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 Ѻáҡ Ңй سҧ õǨͺ١ͧͧҹŻѨغѹ ¡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 ԸաûѺا slipstream õԴ駢ͧ SQL Server 2008
956008 ѧҡسԴ SQL Server 2008 㹴ʡСͺ¡á˹ÿ աҧԧж١ҧҧÿŷҷʡ

ѺǡѺشá˹ÿ 䫵 Microsoft 仹:

˹

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


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

سѵ

Ţ (Article ID): 819546 - Ǥش: 13 Ҿѹ 2556 - Revision: 9.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
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