INF: Microsoft Cluster Server¿¡ SQL Server 2000 Enterprise EditionÀ» ¼³Ä¡ÇÏ´Â ¼ø¼­

±â¼ú ÀÚ·á: 243218 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
ÀÌ ¹®¼­´Â ÀÌÀü¿¡ ´ÙÀ½ ID·Î ÃâÆÇµÇ¾úÀ½: KR243218
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

ÀÌ ÆäÀÌÁö¿¡¼­

¿ä¾à

º» ¹®¼­¿¡¼­´Â Microsoft Cluster Server¿¡ Microsoft SQL Server 2000 Enterprise EditionÀ» ¼³Ä¡Çϱâ À§ÇÑ ÀϹÝÀûÀÎ ¿ä±¸ »çÇ× ¹× ´Ü°è¸¦ ¼³¸íÇÕ´Ï´Ù.

Âü°í: Microsoft SQL Server 2000 Books OnlineÀÇ "failover clustering" »öÀÎ Ç׸ñ¿¡ º» ¹®¼­ÀÇ ³»¿ë°ú Ãß°¡ÀûÀÎ Á¤º¸°¡ µé¾î ÀÖ½À´Ï´Ù. »ç¿ëÀÚÀÇ ÆíÀǸ¦ À§ÇØ ±× Á¤º¸¸¦ ÀÌ Microsoft ±â¼ú ÀÚ·á ¹®¼­¿¡ ³Ö¾ú½À´Ï´Ù.

Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)¿¡ ´ëÇÑ Àǹ® »çÇ×ÀÌ ÀÖÀ¸¸é ¸ÕÀú SQL Server 2000 Books OnlineÀ» ÂüÁ¶ÇϽʽÿÀ.

Ãß°¡ Á¤º¸

Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)

Microsoft¢ç SQL Server¢â 2000 Enterprise Edition¿¡¼­ SQL Server 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)Àº ³ôÀº °¡¿ë¼º Áö¿øÀ» Á¦°øÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ¿î¿µ üÁ¦¿¡ ¿À·ù°¡ ¹ß»ýÇϰųª °èȹµÈ ¾÷±×·¹À̵带 ¼öÇàÇÒ ¶§ ÇÑ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)°¡ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ±¸¼º¿¡ Æ÷ÇÔµÈ ´Ù¸¥ ³ëµå·Î Àå¾Ö Á¶Ä¡(Failover)µÇµµ·Ï ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ ¹æ¹ýÀ¸·Î ½Ã½ºÅÛ Áß´Ü ½Ã°£À» ÃÖ¼ÒÈ­ÇÏ¿© ¼­¹öÀÇ °¡¿ë¼ºÀ» ³ôÀÏ ¼ö ÀÖ½À´Ï´Ù.

Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» ¼³Ä¡Çϱâ Àü¿¡

Microsoft¢ç SQL Server¢â 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¼³Ä¡Çϱâ Àü¿¡ ÄÄÇ»ÅÍ¿¡¼­ ½ÇÇàÇÒ ¿î¿µ üÁ¦¸¦ ¼±ÅÃÇØ¾ß ÇÕ´Ï´Ù. Microsoft Windows NT 4.0 Enterprise Edition, Microsoft Windows 2000 Advanced Server ¶Ç´Â Microsoft Windows 2000 Datacenter Server¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. Microsoft Cluster Service(MSCS)µµ ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù.

Âü°í: ¼÷·ÃµÈ »ç¿ëÀÚÀÎ °æ¿ì SQL Server 2000 Ŭ·¯½ºÅÍ ¼³Ä¡ ´Ü°è¸¦ ±¸Ã¼ÀûÀ¸·Î ¾Ë·Á¸é º» ¹®¼­ÀÇ "Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ¸¸µé±â: ½ÇÁ¦ ¼³Ä¡" ÀýÀ» ÂüÁ¶ÇϽʽÿÀ.

°æ°í: Microsoft´Â ¸ðµç »ç¿ëÀÚ°¡ º» ¹®¼­¸¦ ÀÖ´Â ±×´ë·Î »ç¿ëÇÒ °ÍÀ» ±ÇÀåÇÕ´Ï´Ù.

¼³Ä¡ Àü °Ë»ç ¸ñ·Ï

¼³Ä¡¸¦ ½ÃÀÛÇϱâ Àü¿¡ ¾Æ·¡¿Í °°Àº »çÇ×À» È®ÀÎÇÕ´Ï´Ù.

  • ³×Æ®¿öÅ© ÀÎÅÍÆäÀ̽º Ä«µå(NIC)¿Í µå¶óÀ̺ê/¹è¿­(SCSI) ÄÁÆ®·Ñ·¯°¡ IRQ¸¦ °øÀ¯ÇÏÁö ¾Ê¾Æ¾ß ÇÕ´Ï´Ù. ÀϺΠÇϵå¿þ¾î´Â ÀÌ·¯ÇÑ IRQ °øÀ¯¸¦ Áö¿øÇÏÁö¸¸ °øÀ¯ÇÏÁö ¾Ê´Â °ÍÀÌ ÁÁ½À´Ï´Ù.


  • »ç¿ë ÁßÀÎ Çϵå¿þ¾î°¡ Microsoft Windows NT Çϵå¿þ¾î ȣȯ ¸ñ·Ï¿¡ Æ÷ÇԵǾî ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù. Áö¿øµÇ´Â Çϵå¿þ¾îÀÇ Àüü ¸ñ·ÏÀ» º¸·Á¸é ¾Æ·¡ À¥ »çÀÌÆ®¿¡¼­ Çϵå¿þ¾î ȣȯ ¸ñ·Ï(HCL)À» ÂüÁ¶ÇϽʽÿÀ.
    Hardware Compatibility List
    Çϵå¿þ¾î ½Ã½ºÅÛÀÌ HCLÀÇ Cluster ¹üÁÖ¿¡ ³ª¿Í ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù. Ŭ·¯½ºÅÍ¿¡ »ç¿ëÀÚ°¡ Ãß°¡ÇÑ °³º° Ŭ·¯½ºÅÍ ±¸¼º ¿ä¼Ò´Â ½ÂÀÎµÈ ½Ã½ºÅÛ¿¡ ¼ÓÇÏÁö ¾Ê½À´Ï´Ù. Cluster ¹üÁÖ¿¡ ³ª¿Í ÀÖ°í Ŭ·¯½ºÅÍ ¼Ö·ç¼ÇÀ¸·Î ±¸ÀÔÇÑ ½Ã½ºÅÛ¸¸ÀÌ ½ÂÀÎµÈ Çϵå¿þ¾îÀÔ´Ï´Ù. ¸ñ·ÏÀ» È®ÀÎÇÒ ¶§ °Ë»ö ¹üÁÖ·Î Cluster¸¦ ¼±ÅÃÇϽʽÿÀ. ´Ù¸¥ ¹üÁÖ´Â ¸ðµÎ OEM¿ëÀÔ´Ï´Ù.


  • ¸ðµç ³ëµå¿¡¼­ µ¿½Ã¿¡ Microsoft Windows NT 4.0 Enterprise Edition, Microsoft Windows 2000 Advanced Server ¶Ç´Â Microsoft Windows 2000 Datacenter Server¸¦ ½ÇÇàÇϱâ Àü¿¡ Àû¾îµµ ÇÑ ³ëµå¿¡¼­ MSCS°¡ ¿ÏÀüÈ÷ ¼³Ä¡µÇ¾ú´ÂÁö È®ÀÎÇÕ´Ï´Ù. MSCS¸¦ »ç¿ëÇÒ ¶§ ´Ù¸¥ ³ëµå¸¦ ¿Â¶óÀο¡ ¿¬°áÇϱâ Àü¿¡ ÇÑ ³ëµå¿¡¼­ ³ëµå°¡ °øÀ¯ SCSI ¹ö½ºÀÇ Á¦¾î¸¦ ¹Þ°í ÀÖ´ÂÁö È®ÀÎÇØ¾ß ÇÕ´Ï´Ù. ÇÑ ³ëµå°¡ °øÀ¯ SCSI ¹ö½ºÀÇ Á¦¾î¸¦ ¹ÞÁö ¾ÊÀ¸¸é ÀÀ¿ë ÇÁ·Î±×·¥ Àå¾Ö Á¶Ä¡(Failover)·Î ÀÎÇØ ¿Â¶óÀÎ º¸·ù »óŰ¡ µÉ ¼ö ÀÖ½À´Ï´Ù. ±× °á°ú ´Ù¸¥ ³ëµå¿¡¼­ Ŭ·¯½ºÅͰ¡ ½ÇÆÐÇϰųª Àüü ³ëµå°¡ ½ÇÆÐÇÕ´Ï´Ù. ±×·¯³ª, Çϵå¿þ¾î Á¦Á¶¾÷ü°¡ µ¶Á¡ÀûÀÎ ¼³Ä¡ ¹æ¹ýÀ» Á¦°øÇÏ´Â °æ¿ì¿¡´Â Çϵå¿þ¾î Á¦Á¶¾÷üÀÇ ÁöħÀ» µû¶ó¾ß ÇÕ´Ï´Ù.


  • Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¿¡¼­ ¼³¸íÇÏ´Â ´ë·Î Windows Internet Name Service(WINS)¸¦ ¼³Ä¡Çß´ÂÁö È®ÀÎÇÕ´Ï´Ù.
    258750 Ŭ·¯½ºÅÍ ¼­¹ö¿¡ ±ÇÀåÇÏ´Â °³ÀÎ "ÇÏÆ®ºñÆ®" ±¸¼º
  • Ŭ·¯½ºÅ͸¦ »ç¿ëÇÒ ¼ö ÀÖ´Â µð½ºÅ©ÀÇ µå¶óÀÌºê ¹®ÀÚ°¡ µÎ ¼­¹ö¿¡¼­ µ¿ÀÏÇÑÁö È®ÀÎÇÕ´Ï´Ù.


  • SQL Server ¼³Ä¡ ÇÁ·Î±×·¥À» ½ÃÀÛÇϱâ Àü¿¡ ¸ðµç °³ÀÎ ³×Æ®¿öÅ© Ä«µå¿¡¼­ NetBIOS »ç¿ë ¼³Á¤À» ÇØÁ¦ÇØ¾ß ÇÕ´Ï´Ù.


  • ¸ðµç ³ëµå¿¡¼­ ½Ã½ºÅÛ ·Î±×¸¦ ºñ¿ì°í ´Ù½Ã Ç¥½ÃÇß´ÂÁö È®ÀÎÇÕ´Ï´Ù. ¼³Ä¡¸¦ ÁøÇàÇϱâ Àü¿¡ ·Î±×¿¡ ¿À·ù ¸Þ½ÃÁö°¡ ¾ø¾î¾ß ÇÕ´Ï´Ù.

Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering) ¼³Ä¡

Microsoft Windows NT¢ç 4.0 Enterprise Edition¿¡ Microsoft¢ç SQL Server¢â 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» ¼³Ä¡ÇÏ·Á¸é ¾Æ·¡¿¡¼­ ¼³¸íÇÏ´Â ¼ø¼­´ë·Î ÇÁ·Î±×·¥À» ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. Microsoft Windows¢ç 2000 Advanced Server ¶Ç´Â Microsoft Windows 2000 Datacenter Server¿¡ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» ¼³Ä¡ÇÒ ¶§´Â ¾Æ·¡ÀÇ ´Ü°è°¡ Àû¿ëµÇÁö ¾Ê½À´Ï´Ù.

ÁÖÀÇ: ¾Æ·¡¿¡¼­ ¼³¸íÇÏ´Â ¼ø¼­´ë·Î ÇÁ·Î±×·¥À» ¼³Ä¡ÇÏÁö ¾ÊÀ¸¸é ¼ÒÇÁÆ®¿þ¾î Á¦Ç°À» ¼³Ä¡ÇÏ´Â µ¥ ½ÇÆÐÇÏ°í µð½ºÅ©¸¦ ´Ù½Ã ÃʱâÈ­ÇÑ ÈÄ ´Ù½Ã ¼³Ä¡ÇØ¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.

Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ±¸¼º¿¡ SQL Server 2000À» ¼³Ä¡Çϱâ Àü¿¡ ½ÃÇèÆÇ ¹öÀüÀÇ SQL Server 2000À» ¾÷±×·¹À̵åÇØ¾ß ÇÕ´Ï´Ù.

Windows NT 4.0¿¡¼­ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» ¼³Ä¡ÇÏ·Á¸é ¾Æ·¡ ´Ü°è¸¦ ¼öÇàÇÕ´Ï´Ù.
  1. Microsoft Windows NT 4.0 Enterprise EditionÀ» ¼³Ä¡ÇÕ´Ï´Ù. Windows NT 4.0 Enterprise Edition¿¡´Â Microsoft Cluster Service(MSCS)¸¦ ¼³Ä¡ÇÏ´Â µ¥ ÇÊ¿äÇÑ Windows NT 4.0 ¼­ºñ½º ÆÑ 3ÀÌ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù.

    • Windows NT ¿É¼Ç ÆÑÀ» ¼³Ä¡ÇÒ °èȹÀÌ¸é ¼­ºñ½º ÆÑ 4 ÀÌ»óÀ» ¼³Ä¡ÇÏÁö ¸¶½Ê½Ã¿À.


    • Microsoft Internet Information Server(IIS)¸¦ ¼³Ä¡ÇÏÁö ¸¶½Ê½Ã¿À.


    Áß¿ä: IIS´Â ±âº»ÀûÀ¸·Î ¼³Ä¡µË´Ï´Ù. µû¶ó¼­, Windows NT 4.0À» ¼³Ä¡ÇÒ ¶§ IIS ¿É¼ÇÀ» ÇØÁ¦ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù.
  2. MSCS¸¦ ¼³Ä¡ÇÕ´Ï´Ù.
  3. Microsoft Internet Explorer ¹öÀü 5.0 ÀÌ»óÀ» ¼³Ä¡ÇÕ´Ï´Ù.
  4. Microsoft Distributed Transaction Coordinator(MS DTC) ¼³Ä¡ ÇÁ·Î±×·¥ÀÌ ¸®¼Ò½º¸¦ »ý¼ºÇÒ ¼ö ÀÖµµ·Ï ¼öµ¿À¸·Î MSDTC ȣȯ ¸®¼Ò½º ±×·ìÀ» ¸¸µì´Ï´Ù. ÀÌ ±×·ìÀº IP ÁÖ¼Ò, ³×Æ®¿öÅ© À̸§ ¹× Ŭ·¯½ºÅÍ µð½ºÅ© ¸®¼Ò½º¸¦ Æ÷ÇÔÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ¼¼ Ç׸ñÀ» Æ÷ÇÔÇÏ´Â ±×·ìÀº ¸ðµÎ MSDTC¿Í ȣȯµË´Ï´Ù.

    SQL Server ¼³Ä¡ ÇÁ·Î±×·¥ÀÌ ³ªÁß¿¡ MSDTC¸¦ ¼³Ä¡ÇÕ´Ï´Ù. µû¶ó¼­ Windows NT 4.0 ¿É¼Ç ÆÑ¿¡¼­ MSDTC ¿ÜÀÇ ±¸¼º ¿ä¼Ò°¡ ÇÊ¿äÇÒ ¶§¸¸ Windows NT 4.0 ¿É¼Ç ÆÑÀ» ¼³Ä¡ÇϽʽÿÀ.
  5. Ãֽм­ºñ½º ÆÑÀÎ Windows NT 4.0 ¼­ºñ½º ÆÑ 5¸¦ ¼³Ä¡ÇÕ´Ï´Ù. Create an uninstall directory¸¦ ´©¸£°í Year 2000 SetupÀ» ´©¸¥ ´ÙÀ½ Intel Service Pack install for Intel based systems È®ÀζõÀ» ¼±ÅÃÇÕ´Ï´Ù.

    Microsoft Message Queue Server(MSMQ 1.0)³ª IIS´Â ¼±ÅÃÇÏÁö ¸¶½Ê½Ã¿À. SQL Server 2000Àº MSMQ 1.0À» Áö¿øÇÏÁö ¾Ê½À´Ï´Ù. IIS ±â´ÉÀº Microsoft Windows NT ·Îµå ±ÕÇü Á¶Á¤ ¼­ºñ½º(WLBS)¿Í ÇÔ²² »ç¿ëÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. WLBS¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀ» º¸·Á¸é ¾Æ·¡ÀÇ Microsoft Windows NT Server À¥ »çÀÌÆ®¿¡¼­ "WLBS Features Overview"¸¦ °Ë»öÇϽʽÿÀ.
    Microsoft Windows NT Server
    5´Ü°è¸¦ ¼öÇàÇϱâ Àü¿¡ ¼û±è µð·ºÅ͸®ÀÎ "$NTServicePackUninstall$"ÀÇ À̸§À» "$NTServicePackUninstall$.¼­ºñ½º_ÆÑ_¹øÈ£"·Î º¯°æÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ¿©±â¼­ ¼­ºñ½º_ÆÑ_¹øÈ£´Â ¼­ºñ½º ÆÑÀÇ ¹øÈ£ÀÔ´Ï´Ù. ¼­ºñ½º ÆÑÀ» ¼³Ä¡ÇÑ ´ÙÀ½ »õ µð·ºÅ͸®¸¦ Ãß°¡ÇÕ´Ï´Ù. ÀÌ·¸°Ô ÇÏ¸é ½Ç¼ö·Î ¼³Ä¡ Á¦°Å µð·ºÅ͸®¸¦ µ¤¾î¾²Áö ¾Êµµ·Ï ¹æÁöÇÏ°í ±× µð·ºÅ͸®¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
  6. SQL Server 2000À» ¼³Ä¡ÇÕ´Ï´Ù.
Âü°í: ´Ù¸¥ ÀÀ¿ë ÇÁ·Î±×·¥À» ¼³Ä¡Çϱâ Àü¿¡ ÇÊ¿äÇÑ ¼­¹ö Á¦Ç°À» Ãß°¡·Î ¼³Ä¡ÇϽʽÿÀ.

Microsoft Windows 2000¿¡¼­ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» ¼³Ä¡ÇÏ·Á¸é ¾Æ·¡ ´Ü°è¸¦ ¼öÇàÇÕ´Ï´Ù.
  1. ±âº»ÀûÀ¸·Î ¼³Ä¡µÇ´Â ÀÀ¿ë ÇÁ·Î±×·¥À» ¸ðµÎ Àû¿ëÇÏ¿© Windows 2000À» ¼³Ä¡ÇÕ´Ï´Ù.
  2. ù ¹øÂ° ³ëµå¿¡ Windows 2000À» ¼³Ä¡ÇÑ ÈÄ MSCS¸¦ ¼³Ä¡Çϱâ Àü¿¡ ½ÃÀÛÀ» ´©¸£°í ÇÁ·Î±×·¥, °ü¸® µµ±¸¸¦ Â÷·Ê·Î °¡¸®Å² ´ÙÀ½ ¼­¹ö ±¸¼ºÀ» ´©¸¨´Ï´Ù.
  3. °í±Þ¿¡¼­ Ŭ·¯½ºÅÍ ¼­ºñ½º¸¦ ´©¸¥ ´ÙÀ½ ¿À¸¥ÂÊ Ã¢¿¡¼­ ÀÚ¼¼È÷ ¾Ë¾Æº¾´Ï´Ù¸¦ ´©¸¨´Ï´Ù.
  4. Windows 2000 µµ¿ò¸» ¸Þ´º¿¡¼­ "Windows Ŭ·¯½ºÅ͸µ" Ç׸ñÀÇ 2¹øÀ» ÀнÀ´Ï´Ù. Windows Ŭ·¯½ºÅ͸µÀº Windows 2000À» ¼³Ä¡ÇÏ´Â µ¿¾È SQL Server 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)°ú ÇÔ²² »ç¿ëµË´Ï´Ù. "Windows Ŭ·¯½ºÅ͸µ" Ç׸ñÀÇ Áöħ¿¡ µû¶ó MSCS¸¦ ¼³Ä¡ÇÕ´Ï´Ù.

    Áß¿ä: "Windows Ŭ·¯½ºÅ͸µ °èȹ\¿ä±¸ »çÇ×" Ç׸ñ¿¡¼­ ¼­¹ö Ŭ·¯½ºÅÍ¿¡ ´ëÇÑ ¼³¸íÀ» Àаí "°Ë»ç ¸ñ·Ï: ¼­¹ö Ŭ·¯½ºÅÍ ¸¸µé±â"¿¡ ³ª¿Â ¼­¹ö Ŭ·¯½ºÅÍ °Ë»ç ¸ñ·ÏÀ» µû¶ó¾ß ÇÕ´Ï´Ù. "°Ë»ç ¸ñ·Ï: ¼­¹ö Ŭ·¯½ºÅÍ ¸¸µé±â" Ç׸ñÀº ¼­¹ö Ŭ·¯½ºÅÍ¿¡ ´ëÇÑ Ç׸ñ¿¡¼­ "¼­¹ö Ŭ·¯½ºÅÍ Àý\°Ë»ç ¸ñ·Ï" ¾Æ·¡¿¡ ÀÖ½À´Ï´Ù.
  5. MSCS¸¦ ¼³Ä¡ÇÑ ´ÙÀ½¿¡´Â Ŭ·¯½ºÅÍ¿¡¼­ ½ÇÇàÇÒ MSDTC¸¦ ±¸¼ºÇØ¾ß ÇÕ´Ï´Ù. MSDTC¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books Online¿¡¼­ "Failover Clustering Dependencies" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
  6. ½ÃÀÛ ¸Þ´º¿¡¼­ ÇÁ·Î±×·¥, °ü¸® µµ±¸, Ŭ·¯½ºÅÍ °ü¸®ÀÚ¸¦ Â÷·Ê·Î °¡¸®Å² ´ÙÀ½ ±×·ì º¸±â¿¡¼­ Ŭ·¯½ºÅÍ ±×·ìÀ» ´©¸¨´Ï´Ù. ±×·ìÀÌ MSDTC ¸®¼Ò½º¸¦ Æ÷ÇÔÇÏ´Â °æ¿ì¿¡´Â 9´Ü°è·Î °Ç³Ê¶Ý´Ï´Ù. ±×·ìÀÌ MSDTC ¸®¼Ò½º¸¦ Æ÷ÇÔÇÏÁö ¾ÊÀ¸¸é °è¼ÓÇÏ¿© 7´Ü°è¸¦ ¼öÇàÇÕ´Ï´Ù.
  7. ½ÃÀÛ ¸Þ´º¿¡¼­ ½ÇÇàÀ» ´©¸¨´Ï´Ù. ½ÇÇà ´ëÈ­ »óÀÚ¿¡ ¾Æ·¡ ¸í·ÉÀ» ÀÔ·ÂÇϰí
    cmd
    È®ÀÎÀ» ´©¸¨´Ï´Ù. ¸í·É ÇÁ·ÒÇÁÆ® â¿¡¼­ ¸í·ÉÁÙ¿¡ ¾Æ·¡¿Í °°ÀÌ ÀÔ·ÂÇÕ´Ï´Ù.
    Comclust.exe
  8. Ŭ·¯½ºÅÍÀÇ ³ª¸ÓÁö ³ëµå¿¡ ´ëÇØ ÇÑ ¹ø¿¡ ÇÑ ³ëµå¾¿ 7´Ü°è¸¦ ¹Ýº¹ÇÕ´Ï´Ù.
  9. SQL Server 2000À» ¼³Ä¡ÇÕ´Ï´Ù.
Âü°í: »ç¿ëÀÚ ÀÀ¿ë ÇÁ·Î±×·¥À» ¼³Ä¡Çϱâ Àü¿¡ ÇÊ¿äÇÑ ¼­¹ö Á¦Ç°À» Ãß°¡·Î ¼³Ä¡ÇϽʽÿÀ.

Cluster Disk Selection È­¸é

»õ °¡»ó ¼­¹ö¸¦ ¼³Ä¡ÇÏ´Â µ¿¾È ¶Ç´Â Ŭ·¯½ºÅ͸¦ ¾÷±×·¹À̵åÇÏ´Â µ¿¾È Cluster Disk Selection È­¸é¿¡¼­ Ŭ·¯½ºÅÍ ±×·ìÀ» ¼±ÅÃÇÒ ¼ö ÀÖ½À´Ï´Ù. Ŭ·¯½ºÅÍ ±×·ìÀº ±×·ì¿¡ Æ÷ÇÔµÈ Çϳª ÀÌ»óÀÇ °øÀ¯ Ŭ·¯½ºÅÍ µð½ºÅ©·Î ÀÌ·ç¾îÁö¸ç Microsoft¢ç SQL Server¢â °¡»ó ¼­¹ö¸¦ Çϳª¸¸ Æ÷ÇÔÇÒ ¼ö ÀÖ½À´Ï´Ù. Cluster Disk Selection È­¸é¿¡´Â ÀÌ¹Ì °øÀ¯ Ŭ·¯½ºÅÍ µð½ºÅ©°¡ ¸®¼Ò½º·Î Ãß°¡µÈ ±×·ì¸¸ ³ªÅ¸³³´Ï´Ù. Ŭ·¯½ºÅÍ µð½ºÅ©¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº º» ¹®¼­ÀÇ "Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ¸¸µé±â" ÀýÀ̳ª SQL Server 2000 Books OnlineÀÇ "Creating a Failover Cluster" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.

ÁÖÀÇ: ¸ñ·Ï¿¡¼­ ¸¶Áö¸· ±×·ìÀÎ Äõ·³ µð½ºÅ©´Â Ư¼öÇÑ ¸®¼Ò½º·Î Ãë±ÞÇØ¾ß ÇϹǷΠ¼±ÅÃÇÏÁö ¸¶½Ê½Ã¿À. Äõ·³(Quorum) µð½ºÅ©¸¦ ¼±ÅÃÇÏ¸é °æ°í ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books Online¿¡¼­ "Quorum Disk Selection Warning" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.

ÀÛÀº Ŭ·¯½ºÅ͸¦ »ç¿ëÇÒ ¶§´Â Äõ·³(Quorum) µð½ºÅ©°¡ À¯ÀÏÇÑ ¼±Åà Ç׸ñÀÏ ¼öµµ ÀÖ½À´Ï´Ù. Äõ·³(Quorum) µð½ºÅ©´Â Å×½ºÆ® ¸ñÀûÀ¸·Î ¶Ç´Â Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» Ž»öÇϱâ À§ÇÑ ¸ñÀûÀ¸·Î¸¸ »ç¿ëÇϽʽÿÀ.

Áß¿ä: ÇÁ·Î´ö¼Ç(Production) ¸ñÀûÀ¸·Î Äõ·³(Quorum) ±×·ìÀ» »ç¿ëÇÏÁö ¸¶½Ê½Ã¿À.

Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ¼³Ä¡

Microsoft¢ç SQL Server¢â 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¼³Ä¡ÇÒ ¶§ ¾Æ·¡¿Í °°Àº »çÇ×À» µû¶ó¾ß ÇÕ´Ï´Ù.
  • ¿î¿µ üÁ¦°¡ ¿Ã¹Ù¸£°Ô ¼³Ä¡µÇ¾î ÀÖ°í Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)À» Áö¿øÇϵµ·Ï ¼³°èµÇ¾î ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù. Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¼³Ä¡Çϱâ Àü¿¡ ÇØ¾ß ÇÒ ÀÛ¾÷¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Before Installing Failover Clustering" Ç׸ñÀ̳ª º» ¹®¼­ ¾ÕºÎºÐÀÇ "¼³Ä¡ Àü °Ë»ç ¸ñ·Ï" ÀýÀ» ÂüÁ¶ÇϽʽÿÀ. ¼³Ä¡ ¼ø¼­¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº º» ¹®¼­ ¾ÕºÎºÐÀÇ "Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering) ¼³Ä¡" Àý ¶Ç´Â SQL Server 2000 Books OnlineÀÇ "Installing Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.


  • »ç¿ëÇÏ·Á´Â SQL Server µµ±¸, ±â´É ¹× ±¸¼º ¿ä¼Ò°¡ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)¿¡¼­ Áö¿øµÇ´ÂÁöÀÇ ¿©ºÎ¸¦ °í·ÁÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Failover Clustering Support" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.

    ´ÙÀ½Àº Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)¿¡ Áö¿øµÇ´Â µµ±¸, ±â´É ¹× ±¸¼º ¿ä¼Ò¸¦ ¿ä¾àÇÑ °ÍÀÔ´Ï´Ù.


  • Ç¥ Ãà¼ÒÇ¥ È®´ë
    Microsoft °Ë»ö ¼­ºñ½º ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
    º¹¼ö ÀνºÅϽº ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
    SQL Server Enterprise Manager(¿£ÅÍÇÁ¶óÀÌÁî °ü¸®ÀÚ) ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
    ¼­ºñ½º Á¦¾î °ü¸®ÀÚ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
    º¹Á¦ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Creating a Failover Cluster" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
    SQL Profiler(ÇÁ·ÎÇÊ·¯) ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
    SQL Query Analyzer(Äõ¸® ºÐ¼®±â) ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
    SQL ¸ÞÀÏ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using SQL Server Tools with Failover Clustering" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.


  • Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)ÀÌ »ç¿ëÇÏ·Á´Â Á¾¼ÓµÇ´ÂÁöÀÇ ¿©ºÎ¸¦ °í·ÁÇÕ´Ï´Ù. Microsoft¢ç SQL Server¢â 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)°ú »óÈ£ ÀÛ¿ëÇÏ´Â Á¦Ç°Àº ¿©·¯ °¡Áö°¡ ÀÖ½À´Ï´Ù. Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)°¡ Á¦´ë·Î ÀÛµ¿ÇÏ´ÂÁö È®ÀÎÇÏ·Á¸é Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)°ú ´Ù¸¥ Á¦Ç° »çÀÌÀÇ ±âº»ÀûÀÎ Á¾¼Ó¼ºÀ» ÀÌÇØÇØ¾ß ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Failover Clustering Dependencies" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.


  • »õ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µå´Â ¹æ¹ýÀ» °í·ÁÇÕ´Ï´Ù. »õ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ±¸¼ºÀ» ¸¸µå´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Creating a Failover Cluster" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.


  • SQL Server 6.5 ¶Ç´Â SQL Server 7.0 Ŭ·¯½ºÅ͸¦ SQL Server 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)·Î ¾÷±×·¹À̵åÇϱâ À§ÇÑ ÁöħÀ» °ËÅäÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Upgrading to a SQL Server 2000 Failover Cluster" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.


  • Microsoft Distributed Transaction Coordinator(MSDTC) SQL Server 2000ÀÌ ÀϺΠº¹Á¦ ±â´É°ú ºÐ»ê Äõ¸® ¹× 2´Ü°è Ä¿¹Ô Æ®·£Àè¼ÇÀ» ¼öÇàÇÏ·Á¸é Ŭ·¯½ºÅÍ¿¡ Microsoft Distributed Transaction Coordinator(MSDTC)°¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù. Microsoft Windows¢ç 2000À» ¼³Ä¡Çϰí Ŭ·¯½ºÅ͸¦ ±¸¼ºÇÑ ´ÙÀ½¿¡´Â º» ¹®¼­ÀÇ ¾ÕºÎºÐ¿¡¼­ ¼³¸íÇÑ °Íó·³ ¸ðµç ³ëµå¿¡¼­ Ŭ·¯½ºÅÍ ¸¶¹ý»ç(Comclust.exe)¸¦ ½ÇÇàÇÏ¿© Ŭ·¯½ºÅÍµÈ ¸ðµå¿¡¼­ MSDTC¸¦ ½ÇÇàÇϵµ·Ï ±¸¼ºÇØ¾ß ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Failover Clustering Dependencies" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.

Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µå´Â ¹æ¹ý

Microsoft¢ç SQL Server¢â 2000 Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µé·Á¸é Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)°¡ ½ÇÇàµÉ °¡»ó ¼­¹ö¸¦ ¸¸µé¾î ±¸¼ºÇØ¾ß ÇÕ´Ï´Ù. SQL Server¸¦ ¼³Ä¡ÇÏ´Â µ¿¾È °¡»ó ¼­¹ö¸¦ ¸¸µì´Ï´Ù. Microsoft Windows NT¢ç 4.0 ¶Ç´Â Microsoft Windows¢ç 2000Àº °¡»ó ¼­¹ö¸¦ Á¦°øÇÏÁö ¾Ê½À´Ï´Ù.

Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µé·Á¸é ¼­ºñ½º·Î ·Î±×¿ÂÇÏ¿© Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)ÀÇ ¸ðµç ÄÄÇ»ÅÍ¿¡¼­ ¿î¿µ üÁ¦ÀÇ ÀϺηΠµ¿ÀÛÇÒ ¼ö ÀÖ´Â ±ÇÇÑÀ» °¡Áø ·ÎÄà °ü¸®ÀÚ¿©¾ß ÇÕ´Ï´Ù.

°¡»ó ¼­¹öÀÇ ¿ä¼Ò

°¡»ó ¼­¹ö´Â ¾Æ·¡¿Í °°Àº ¿ä¼Ò·Î ±¸¼ºµË´Ï´Ù.
  • Microsoft Cluster Service(MSCS) Ŭ·¯½ºÅÍ ±×·ì¿¡ Æ÷ÇÔµÈ Çϳª ¶Ç´Â ¿©·¯ µð½ºÅ©ÀÇ Á¶ÇÕ

    °¢ MSCS Ŭ·¯½ºÅÍ ±×·ìÀº °¡»ó SQL Server¸¦ Çϳª¸¸ Æ÷ÇÔÇÒ ¼ö ÀÖ½À´Ï´Ù.


  • °¢ °¡»ó ¼­¹öÀÇ ³×Æ®¿öÅ© À̸§. ÀÌ ³×Æ®¿öÅ© À̸§Àº °¡»ó ¼­¹ö À̸§ÀÔ´Ï´Ù.


  • °¢ °¡»ó ¼­¹ö¿¡ ¿¬°áÇÏ´Â µ¥ »ç¿ëµÇ´Â Çϳª ÀÌ»óÀÇ IP ÁÖ¼Ò


  • SQL Server ¸®¼Ò½º, SQL Server Agent ¸®¼Ò½º ¹× Àüü ÅØ½ºÆ® ¸®¼Ò½º¸¦ Æ÷ÇÔÇÏ´Â SQL Server 2000ÀÇ ÀνºÅϽº Çϳª

    °ü¸®ÀÚ°¡ °¡»ó ¼­¹ö ³»ÀÇ SQL Server 2000 ÀνºÅϽº¸¦ Á¦°ÅÇÏ¸é ¸ðµç IP ÁÖ¼Ò¿Í ³×Æ®¿öÅ© À̸§À» Æ÷ÇÔÇÏ¿© °¡»ó ¼­¹öµµ MSCS Ŭ·¯½ºÅÍ ±×·ì¿¡¼­ Á¦°ÅµË´Ï´Ù.


Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)´Â Ŭ·¯½ºÅÍÀÇ ³ëµå¿¡ Âü¿©ÇÏ´Â Çϳª ÀÌ»óÀÇ ½ÇÁ¦ Windows 2000 Advanced Server, Windows 2000 Datacenter Server ¼­¹ö ¶Ç´Â Windows NT 4.0 Enterprise Edition ¼­¹ö¿¡¼­ ½ÇÇàÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª SQL Server °¡»ó ¼­¹ö´Â ³×Æ®¿öÅ©¿¡¼­ Ç×»ó ´ÜÀÏ Windows 2000 Advanced Server ¼­¹ö, Windows 2000 Datacenter Server ¼­¹ö ¶Ç´Â Microsoft Windows NT 4.0 Enterprise Edition ¼­¹ö·Î ³ªÅ¸³³´Ï´Ù.

°¡»ó ¼­¹ö À̸§ ÁöÁ¤

SQL Server 2000Àº Àå¾Ö Á¶Ä¡(Failover) ÀÌÈÄ Á¤»óÀûÀÎ ÀÛµ¿ÀÌ °è¼ÓµÇµµ·Ï Çϱâ À§ÇØ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ³»ÀÇ Æ¯Á¤ ·¹Áö½ºÆ®¸® Ű¿Í ¼­ºñ½º À̸§¿¡ ÀÇÁ¸ÇÕ´Ï´Ù. µû¶ó¼­ ±âº» ÀνºÅϽº¸¦ Æ÷ÇÔÇÏ¿© SQL Server 2000ÀÇ ÀνºÅϽº¿¡ ÁöÁ¤ÇÏ´Â À̸§Àº Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ³»ÀÇ ¸ðµç °¡»ó ¼­¹ö»Ó¸¸ ¾Æ´Ï¶ó Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ±¸¼ºÇÏ´Â ¸ðµç ³ëµå¿¡¼­ °íÀ¯ÇØ¾ß ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ¸ðµç ÀνºÅϽº°¡ ´ÜÀÏ ¼­¹ö·Î Àå¾Ö Á¶Ä¡(Failover)µÇ¸é ÀνºÅϽºÀÇ ¼­ºñ½º À̸§°ú ·¹Áö½ºÆ®¸® ۰¡ Ãæµ¹ÇÕ´Ï´Ù. INST1ÀÌ °¡»ó ¼­¹ö VIRTSRV1¿¡¼­ ¸í¸íµÈ ÀνºÅϽºÀ̸é Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)ÀÇ ´Ù¸¥ ³ëµå¿¡ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ±¸¼ºÀÇ ÀϺημ­ ¶Ç´Â µ¶¸³Çü ¼³Ä¡·Î¼­ INST1À̶ó´Â À̸§À» °¡Áø ¸í¸íµÈ ÀνºÅϽº°¡ ÀÖÀ» ¼ö ¾ø½À´Ï´Ù.

¶ÇÇÑ, °¡»ó ¼­¹ö¿¡¼­ ½ÇÇàµÇ´Â SQL Server 2000ÀÇ Å¬·¯½ºÅÍµÈ ÀνºÅϽº¿¡ ¿¬°áÇϱâ À§ÇØ VIRTUAL_SERVER\ÀνºÅϽº_À̸§ ¹®ÀÚ¿­À» »ç¿ëÇØ¾ß ÇÕ´Ï´Ù. Ŭ·¯½ºÅÍµÈ ÀνºÅϽº°¡ ÀÖ´Â SQL Server 2000ÀÇ ÀνºÅϽº¿¡ ÄÄÇ»ÅÍ À̸§À» »ç¿ëÇÏ¿© ¾×¼¼½ºÇÒ ¼ö ¾ø½À´Ï´Ù. SQL Server 2000Àº ·ÎÄà ¼­¹öÀÇ IP ÁÖ¼Ò¿¡¼­ ¼ö½Å ´ë±âÇÏÁö ¾Ê½À´Ï´Ù. SQL Server 2000À» À§ÇÑ °¡»ó ¼­¹ö¸¦ ¼³Ä¡ÇÏ´Â µ¿¾È »ý¼ºµÈ Ŭ·¯½ºÅÍµÈ IP ÁÖ¼Ò¿¡¼­¸¸ ¼ö½Å ´ë±âÇÕ´Ï´Ù.

»ç¿ë ½Ã °í·Á »çÇ×

Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µé±â Àü¿¡ ¾Æ·¡¿Í °°Àº »çÇ×À» °í·ÁÇϽʽÿÀ.
  • Windows 2000 Address Windowing Extensions(AWE) API¸¦ »ç¿ëÇÏ¿© 3GB ÀÌ»óÀÇ ¸Þ¸ð¸®¸¦ ÀÌ¿ëÇÏ´Â °æ¿ì, SQL ServerÀÇ ÇÑ ÀνºÅϽº¿¡¼­ ±¸¼ºÇÑ »ç¿ë °¡´ÉÇÑ ÃÖ´ë ¸Þ¸ð¸®¸¦ ´Ù¸¥ ³ëµå·Î Àå¾Ö Á¶Ä¡(Failover)ÇÑ ÈÄ¿¡µµ °è¼Ó »ç¿ëÇÒ ¼ö ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù. Àå¾Ö Á¶Ä¡(Failover) ³ëµåÀÇ ½ÇÁ¦(Physical) ¸Þ¸ð¸®°¡ ¿ø·¡ ³ëµåÀÇ ¸Þ¸ð¸®º¸´Ù ÀÛÀ¸¸é SQL ServerÀÇ ÀνºÅϽº°¡ ½ÃÀÛµÇÁö ¾Ê°Å³ª ¿ø·¡ ³ëµå¿¡¼­º¸´Ù ÀÛÀº ¸Þ¸ð¸®¸¦ »ç¿ëÇÏ¿© ½ÃÀÛµÉ ¼ö ÀÖ½À´Ï´Ù. ¾Æ·¡¿Í °°Àº »çÇ×À» È®ÀÎÇÕ´Ï´Ù.
    • Ŭ·¯½ºÅÍÀÇ °¢ ¼­¹ö¿¡¼­ ½ÇÁ¦(Physical) RAMÀÇ ¾çÀÌ µ¿ÀÏÇØ¾ß ÇÕ´Ï´Ù.


    • ¸ðµç ÀνºÅϽºÀÇ ÃÖ´ë ¼­¹ö ¸Þ¸ð¸® ¼³Á¤°ªÀÇ ÇÕ°è°¡ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)ÀÇ °¢ °¡»ó ¼­¹ö¿¡¼­ »ç¿ëÇÒ ¼ö ÀÖ´Â ÃÖ¼ÒÀÇ ½ÇÁ¦(Physical) RAM Å©±âº¸´Ù ÀÛ¾Æ¾ß ÇÕ´Ï´Ù.
    AWE¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Using AWE Memory on Windows 2000" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.


  • º¹Á¦¸¦ À§ÇØ °í°¡¿ë¼º ¼­¹ö°¡ ÇÊ¿äÇϸé Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¿¡¼­ ¹èÆ÷ÀÚ¸¦ ±¸¼ºÇÒ ¶§ MSCS Ŭ·¯½ºÅÍ ÆÄÀÏ °øÀ¯¸¦ ½º³À¼¦ Æú´õ·Î »ç¿ëÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ¼­¹ö¿¡ Àå¾Ö°¡ ¹ß»ýÇÏ¸é ¹èÆ÷ µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÒ ¼ö ÀÖ°í ¹èÆ÷ÀÚ¿¡¼­ º¹Á¦¸¦ °è¼Ó ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

    ¶ÇÇÑ, °Ô½Ã(Publication)¸¦ ¸¸µé ¶§ ½º³À¼¦ ÆÄÀÏÀÇ Ãß°¡ ÀúÀå¼Ò¸¦ À§ÇØ MSCS Ŭ·¯½ºÅÍ ÆÄÀÏ °øÀ¯¸¦ ÁöÁ¤Çϰųª MSCS Ŭ·¯½ºÅ͸¦ ±¸µ¶ÀÚ(Subscriber)°¡ ½º³À¼¦À» Àû¿ëÇÏ´Â À§Ä¡·Î ÁöÁ¤ÇÕ´Ï´Ù. ÀÌ·¸°Ô Çϸé Ŭ·¯½ºÅÍÀÇ ¸ðµç ³ëµå¿Í ½º³À¼¦ ÆÄÀÏ¿¡ ¾×¼¼½ºÇØ¾ß ÇÏ´Â ¸ðµç ±¸µ¶ÀÚ(Subscriber)°¡ ½º³À¼¦ ÆÄÀÏÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books OnlineÀÇ "Publishers, Distributors, and Subscribers" ¹× "Alternate Snapshot Locations" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.


  • Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¿¡ ¾Ïȣȭ¸¦ »ç¿ëÇÏ·Á¸é Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)ÀÇ ¸ðµç ³ëµå¿¡¼­ °¡»ó ¼­¹öÀÇ Á¤½Ä DNS À̸§À» »ç¿ëÇÏ¿© ¼­¹ö ÀÎÁõ¼­¸¦ ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, À̸§ÀÌ test1.widgets.corp.microsoft.com ¹× test2.widgets.corp.microsoft.comÀÎ µÎ ³ëµå·Î ÀÌ·ç¾îÁø Ŭ·¯½ºÅÍ¿Í °¡»ó SQL ServerÀÎ "Virtsql"ÀÌ ÀÖ´Â °æ¿ì¿¡´Â "virtsql.widgets.corp.microsoft.com"ÀÇ ÀÎÁõ¼­¸¦ ±¸ÇÏ¿© µÎ ³ëµå ¸ðµÎ¿¡ ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. ±×·± ´ÙÀ½ ¼­¹ö ³×Æ®¿öÅ© À¯Æ¿¸®Æ¼¿¡¼­ Force protocol encryption È®ÀζõÀ» ¼±ÅÃÇÏ¿© Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¾ÏȣȭÇÕ´Ï´Ù.


  • SQL Server¿¡¼­ BUILTIN/Administrators °èÁ¤À» Á¦°ÅÇÏÁö ¸¶½Ê½Ã¿À. ISALIVE ½º·¹µå´Â SQL Server ¼­ºñ½º °èÁ¤ÀÌ ¾Æ´Ñ Ŭ·¯½ºÅÍ ¼­ºñ½º °èÁ¤ÀÇ ÄÁÅØ½ºÆ®¿¡¼­ ½ÇÇàµË´Ï´Ù. Ŭ·¯½ºÅÍ ¼­ºñ½º´Â Ŭ·¯½ºÅÍÀÇ °¢ ³ëµå¿¡¼­ °ü¸®ÀÚ ±×·ìÀÇ ÀϺο©¾ß ÇÕ´Ï´Ù. BUILTIN/Administrators °èÁ¤À» Á¦°ÅÇϸé ISALIVE ½º·¹µå°¡ ´õ ÀÌ»ó Æ®·¯½ºÆ®µÈ ¿¬°áÀ» ¸¸µé ¼ö ¾ø°í °¡»ó ¼­¹ö¿¡ ¾×¼¼½ºÇÒ ¼ö ¾ø½À´Ï´Ù.


Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ¸¸µé±â: ½ÇÁ¦ ¼³Ä¡

¼³Ä¡ ÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ¸¸µå´Â ±âº» ´Ü°è´Â ¾Æ·¡¿Í °°½À´Ï´Ù.
  1. Ŭ·¯½ºÅÍ µð½ºÅ© ¸®¼Ò½º, IP ÁÖ¼Ò, ³×Æ®¿öÅ© À̸§ µî, °¡»ó ¼­¹ö¸¦ ¸¸µå´Â µ¥ ÇÊ¿äÇÑ Á¤º¸¿Í Àå¾Ö Á¶Ä¡(Failover)¿¡ »ç¿ëÇÒ ¼ö ÀÖ´Â ³ëµå¸¦ È®ÀÎÇÕ´Ï´Ù.

    Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅ͸µ(Failover Clustering)¿¡ »ç¿ëÇÒ Å¬·¯½ºÅÍ µð½ºÅ©´Â ¸ðµÎ ´ÜÀÏ Å¬·¯½ºÅÍ ±×·ì¿¡ ÀÖ°í ¼³Ä¡ ÇÁ·Î±×·¥ÀÌ ½ÇÇàµÇ´Â ³ëµå°¡ ¼ÒÀ¯ÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ±¸¼ºÀº ¼³Ä¡ ÇÁ·Î±×·¥À» ½ÇÇàÇϱâ Àü¿¡ ÀÌ·ç¾îÁ®¾ß ÇÕ´Ï´Ù. Windows NT 4.0 ¶Ç´Â Windows 2000¿¡¼­ Ŭ·¯½ºÅÍ °ü¸®ÀÚ¸¦ »ç¿ëÇÏ¿© ÀÌ·¸°Ô ±¸¼ºÇÕ´Ï´Ù. ¼³Ä¡ÇÒ °¢ °¡»ó ¼­¹ö¸¶´Ù MSCS ±×·ìÀÌ Çϳª¾¿ ÇÊ¿äÇÕ´Ï´Ù.
  2. ¼³Ä¡ ÇÁ·Î±×·¥À» ½ÃÀÛÇÕ´Ï´Ù. ÇÊ¿äÇÑ Á¤º¸¸¦ ¸ðµÎ ÀÔ·ÂÇÏ°í ³ª¸é ¼³Ä¡ ÇÁ·Î±×·¥Àº Ŭ·¯½ºÅÍ¿¡ Æ÷ÇԵǴ °¢ ÄÄÇ»ÅÍÀÇ ·ÎÄà µð½ºÅ©¿¡ SQL Server ¹ÙÀ̳ʸ®ÀÇ »õ ÀνºÅϽº¸¦ ¼³Ä¡Çϰí ÁöÁ¤µÈ Ŭ·¯½ºÅÍ µð½ºÅ©¿¡ ½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º¸¦ ¼³Ä¡ÇÕ´Ï´Ù. ¹ÙÀ̳ʸ®´Â °¢ Ŭ·¯½ºÅÍ ³ëµå¿¡¼­ µ¿ÀÏÇÑ °æ·Î¿¡ ¼³Ä¡µÇ¹Ç·Î °¢ ³ëµå°¡ Ŭ·¯½ºÅÍÀÇ ´Ù¸¥ ¸ðµç ³ëµå¿Í µ¿ÀÏÇÑ ·ÎÄà µå¶óÀÌºê ¹®ÀÚ¸¦ »ç¿ëÇÏ´ÂÁö È®ÀÎÇØ¾ß ÇÕ´Ï´Ù. SQL Server 2000¿¡¼­´Â Àå¾Ö Á¶Ä¡(Failover) µ¿¾È µ¥ÀÌÅͺ£À̽º¸¸ÀÌ Àå¾Ö Á¶Ä¡(Failover)µË´Ï´Ù. SQL Server 6.5 ¹× SQL Server 7.0¿¡¼­´Â Àå¾Ö Á¶Ä¡(Failover) µ¿¾È SQL Server µ¥ÀÌÅͺ£À̽º¿Í ¹ÙÀ̳ʸ® ¸ðµÎ°¡ Àå¾Ö Á¶Ä¡(Failover)µË´Ï´Ù.

    ¾î¶² ÀÌÀ¯·Îµç SQL Server¸¦ ºñ·ÔÇÏ¿© ¸®¼Ò½º¿¡ Àå¾Ö°¡ ¹ß»ýÇϸé SQL Server, SQL Server Agent, Àüü ÅØ½ºÆ® °Ë»ö ¼­ºñ½º ¹× Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster) ±×·ìÀÇ ¸ðµç ¼­ºñ½º°¡ °¡»ó ¼­¹ö¿¡ Á¤ÀÇµÈ »ç¿ë °¡´ÉÇÑ ³ëµå·Î Àå¾Ö Á¶Ä¡(Failover)µË´Ï´Ù.

  3. SQL Server 2000¿¡¼­´Â Àå¾Ö Á¶Ä¡(Failover) µ¿¾È µ¥ÀÌÅͺ£À̽º¸¸ÀÌ Àå¾Ö Á¶Ä¡(Failover)µË´Ï´Ù. SQL Server 6.5 ¹× SQL Server 7.0¿¡¼­´Â Àå¾Ö Á¶Ä¡(Failover) µ¿¾È SQL Server µ¥ÀÌÅͺ£À̽º¿Í ¹ÙÀ̳ʸ® ¸ðµÎ°¡ Àå¾Ö Á¶Ä¡(Failover)µË´Ï´Ù. SQL Server 2000ÀÇ ÀνºÅϽº Çϳª¸¦ ¼³Ä¡ÇÏ¿© »õ °¡»ó ¼­¹ö¿Í ¸ðµç ¸®¼Ò½º¸¦ »ý¼ºÇÕ´Ï´Ù.

ÂüÁ¶

»õ Àå¾Ö Á¶Ä¡ Ŭ·¯½ºÅÍ(Failover Cluster)¸¦ ±¸¼ºÇÏ´Â ¹æ¹ý ¹× Ŭ·¯½ºÅ͸µ°ú °ü·ÃµÈ ´Ù¸¥ ÁÖÁ¦¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server 2000 Books Online¿¡¼­ ¾Æ·¡ Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.
  • Upgrading to a SQL Server 2000 Failover Cluster


  • How to install a one-node failover cluster


  • Failover Clustering FAQ


  • Adding/removing nodes


  • Maintaining


  • Full-text queries


  • Troubleshooting

¼Ó¼º

±â¼ú ÀÚ·á: 243218 - ¸¶Áö¸· °ËÅä: 2007³â 10¿ù 26ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 3.1
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft Windows 2000 Advanced Server
  • Microsoft Windows 2000 Datacenter Server
  • Microsoft SQL Server 2000 Enterprise Edition
Ű¿öµå:?
kbtshoot kbsqlserv2000 kbinterop kbproductlink KB243218

Çǵå¹é º¸³»±â