Microsoft SQL Server 2000 Desktop Engine(Windows)À» »ç¿ëÇÏ´Â Windows SharePoint ServicesÀÇ ¼³Ä¡¸¦ ¹é¾÷ÇÏ°í º¹¿øÇÏ´Â ¹æ¹ý

±â¼ú ÀÚ·á: 833797 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

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

¿ä¾à

ÀÌ ¹®¼­¿¡¼­´Â Microsoft SQL Server 2000 Desktop Engine(Windows)(WMSDE)À» »ç¿ëÇÏ´Â Windows SharePoint ServicesÀÇ ¼³Ä¡¸¦ ¹é¾÷ÇÏ°í º¹¿øÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù. WMSDE¸¦ »ç¿ëÇÑ Windows SharePoint Services ¼³Ä¡¸¦ ¹é¾÷Çϱâ À§Çؼ­´Â °íÀ¯ÇÑ ¿ä±¸ »çÇ×ÀÌ ÇÊ¿äÇÕ´Ï´Ù. Stsadm.exe ¸í·ÉÁÙ µµ±¸ ¶Ç´Â Osql.exe ¸í·ÉÁÙ µµ±¸¸¦ »ç¿ëÇÏ¿© Windows SharePoint Services ÄÜÅÙÆ®¸¦ ¹é¾÷ÇÏ°í º¹¿øÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¹®¼­¿¡´Â Windows SharePoint Services À¥ »çÀÌÆ®¸¦ ¹é¾÷ÇÏ°í º¹¿øÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ Á¤º¸°¡ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. ¶ÇÇÑ ÀÌ ¹®¼­¿¡¼­´Â Windows SharePoint Services ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ ¹é¾÷ÇÏ¿© ¹é¾÷ÀÌ ¼öÇàµÈ µ¿ÀÏ ¼­¹ö¿¡ µ¥ÀÌÅ͸¦ º¹¿øÇÏ´Â ¹æ¹ý°ú Windows SharePoint Services°¡ ½ÇÇàµÇ´Â ´Ù¸¥ ¼­¹ö¿¡ µ¥ÀÌÅ͸¦ º¹¿øÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

¼Ò°³

ÀÌ ¹®¼­¿¡¼­´Â Microsoft SQL Server 2000 Desktop Engine(Windows)À» µ¥ÀÌÅͺ£À̽º Çü½ÄÀ¸·Î »ç¿ëÇÒ °æ¿ì Microsoft Windows SharePoint Services¸¦ ¹é¾÷ÇÏ°í º¹¿øÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù.

Microsoft SQL Server 2000¿¡ Æ÷ÇÔµÈ Enterprise Management ±¸¼º ¿ä¼Ò°¡ WMSDE¿¡´Â Æ÷ÇԵǾî ÀÖÁö ¾Ê±â ¶§¹®¿¡ WMSDE·Î ±¸ÇöµÈ Windows SharePoint Services ¼³Ä¡¸¦ ¹é¾÷Çϱâ À§Çؼ­´Â °íÀ¯ÇÑ ¿ä±¸ »çÇ×ÀÌ ÇÊ¿äÇÕ´Ï´Ù. Windows SharePoint Services¸¦ ¼³Ä¡ÇÒ ¶§ µ¥ÀÌÅͺ£À̽º Çü½ÄÀ¸·Î WMSDE¸¦ »ç¿ëÇÏ´Â °æ¿ì Stsadm.exe ¸í·ÉÁÙ µµ±¸³ª Osql.exe ¸í·ÉÁÙ µµ±¸¸¦ »ç¿ëÇÏ¿© Windows SharePoint Services ÄÜÅÙÆ®¸¦ ¹é¾÷ÇÏ°í º¹¿øÇÒ ¼ö ÀÖ½À´Ï´Ù. µ¥ÀÌÅÍ´Â Á¤±âÀûÀ¸·Î ¹é¾÷ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ¼­¹ö¿¡ ¾÷µ¥ÀÌÆ®¸¦ Àû¿ëÇϱâ Àü¿¡µµ µ¥ÀÌÅ͸¦ ¹é¾÷ÇÒ °ÍÀ» ±ÇÀåÇÕ´Ï´Ù.

Windows SharePoint Services À¥ »çÀÌÆ® ¹é¾÷ ¹× º¹¿ø



Microsoft Windows SharePoint ServicesÀÇ °æ¿ì ¼­¹ö ¶Ç´Â ¼­¹ö ÆÊ¿¡¼­ È£½ºÆõǴ °³º° À¥ »çÀÌÆ®¸¦ ¹é¾÷ÇÏ°í º¹¿øÇÒ ¼ö ÀÖ½À´Ï´Ù. ¼Õ»óµÈ À¥ »çÀÌÆ®¸¦ ±³Ã¼ÇØ¾ß Çϰųª ·Ñ¹éÇÒ º¯°æ ³»¿ëÀÌ Æ÷ÇԵǾî ÀÖ´Â »çÀÌÆ®¸¦ ±³Ã¼ÇØ¾ß ÇÒ ¶§ À¥ »çÀÌÆ®¸¦ ¹é¾÷ÇÏ°í º¹¿øÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, ÀǵµÇÏÁö ¾Ê°Ô »èÁ¦µÈ ¸ñ·ÏÀ̳ª ¸ñ·Ï Ç׸ñÀ» º¹±¸ÇØ¾ß ÇÒ ¼ö ÀÖ½À´Ï´Ù.

À¥ »çÀÌÆ®¸¦ ¹é¾÷ÇÒ °æ¿ì »çÀÌÆ®ÀÇ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â µ¥ÀÌÅ͸¦ ¹é¾÷ÇÕ´Ï´Ù. ¹é¾÷ÇÏ´Â µ¥ÀÌÅÍ¿¡´Â À¥ »çÀÌÆ®ÀÇ À¥ ÆäÀÌÁö, ¹®¼­ ¶óÀ̺귯¸® ¶Ç´Â ¸ñ·ÏÀÇ ÆÄÀÏ, º¸¾È ¹× ±ÇÇÑ ¼³Á¤, ±â´É ¼³Á¤ µîÀÌ Æ÷ÇԵ˴ϴÙ. ¹é¾÷ ÇÁ·Î¼¼½º¸¦ ÅëÇØ ÀÌ·¯ÇÑ ¸ðµç µ¥ÀÌÅÍ°¡ Æ÷ÇÔµÈ ´ÜÀÏ ÆÄÀÏÀÌ ¸¸µé¾îÁý´Ï´Ù. À¥ »çÀÌÆ®¸¦ ¹é¾÷ÇÑ ÈÄ¿¡´Â µ¿ÀÏ À§Ä¡ ¶Ç´Â »õ·Î¿î À§Ä¡¿¡ À¥ »çÀÌÆ®¸¦ º¹¿øÇÒ ¼ö ÀÖ½À´Ï´Ù.

°³º° ÇÏÀ§ »çÀÌÆ®°¡ ¾Æ´Ñ ÃÖ»óÀ§ À¥ »çÀÌÆ®¸¸ ¹é¾÷ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÃÖ»óÀ§ À¥ »çÀÌÆ®¸¦ ¹é¾÷ÇÑ ÈÄ¿¡ ¸¸µé¾îÁö´Â ÆÄÀÏ¿¡ ÃÖ»óÀ§ À¥ »çÀÌÆ®ÀÇ ÇÏÀ§ »çÀÌÆ®°¡ Æ÷ÇԵ˴ϴÙ. Stsadm.exe ¸í·ÉÁÙ µµ±¸¸¦ »ç¿ëÇÏ¿© Windows SharePoint Services À¥ »çÀÌÆ®¸¦ ¹é¾÷ÇÏ°í º¹¿øÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft Windows SharePoint Services 2.0 °ü¸®ÀÚ °¡À̵åÀÇ "¹é¾÷ ¹× ¸¶À̱׷¹À̼Ç(Backup and Migration)" Àå¿¡¼­ "À¥ »çÀÌÆ® ¹é¾÷ ¹× º¹¿ø(Backing Up and Restoring Web Sites)" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ.

Windows SharePoint Services ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º ¹é¾÷ ¹× º¹¿ø

WMSDE¸¦ »ç¿ëÇÑ ÀϹÝÀûÀÎ Windows SharePoint Services ¼³Ä¡ÀÇ °æ¿ì Windows SharePoint Services¿¡¼­ ±¸¼º µ¥ÀÌÅͺ£À̽º Çϳª¿Í ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Çϳª¸¦ ¸¸µì´Ï´Ù. Ưº°ÇÑ Windows SharePoint Services ±¸ÇöÀÇ °æ¿ì¿¡´Â ±¸¼º µ¥ÀÌÅͺ£À̽º Çϳª¸¸ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. ÇÏÁö¸¸ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º´Â Çϳª ÀÌ»ó Á¸ÀçÇÒ ¼ö ÀÖ½À´Ï´Ù.

µû¶ó¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¸ ¹é¾÷ÇÏ¸é µÇ¸ç ±¸¼º µ¥ÀÌÅͺ£À̽º´Â ¹é¾÷ÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇÒ ¶§ »õ·Î¿î ±¸¼º µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÏ´õ¶óµµ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇÒ ¼ö ÀÖ½À´Ï´Ù.

ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º ¹é¾÷

ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ ¹é¾÷ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.

1´Ü°è: Windows SharePoint Services °¡»ó ¼­¹ö°¡ ÇöÀç »ç¿ëÇÏ´Â ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º ¹®¼­È­

Windows SharePoint Services °¡»ó ¼­¹ö°¡ ÇöÀç »ç¿ëÇÏ´Â ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ ¹®¼­È­ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. SharePoint Áß¾Ó °ü¸®¸¦ ½ÃÀÛÇÕ´Ï´Ù.
  2. °¡»ó ¼­¹ö ±¸¼º¿¡¼­ °¡»ó ¼­¹ö ¼³Á¤ ±¸¼ºÀ» ´©¸¨´Ï´Ù.
  3. °¡»ó ¼­¹ö ¸ñ·Ï ÆäÀÌÁö¿¡¼­ È®ÀåÇÑ Ã¹ ¹ø° °¡»ó ¼­¹öÀÇ À̸§À» ´©¸¨´Ï´Ù. ¿¹¸¦ µé¾î, ±âº» À¥ »çÀÌÆ®¸¦ ´©¸¨´Ï´Ù.
  4. °¡»ó ¼­¹ö ¼³Á¤ ÆäÀÌÁöÀÇ °¡»ó ¼­¹ö °ü¸®¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º °ü¸®¸¦ ´©¸¨´Ï´Ù.
  5. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º °ü¸® ÆäÀÌÁöÀÇ µ¥ÀÌÅͺ£À̽º À̸§ ¿­¿¡ Ç¥½ÃµÈ µ¥ÀÌÅͺ£À̽ºÀÇ À̸§À» Àû¾î µÓ´Ï´Ù.
  6. À¥ ¼­¹ö¿¡¼­ ±¸¼ºµÈ °¢ °¡»ó ¼­¹ö¿¡ ´ëÇØ 3´Ü°èºÎÅÍ 5´Ü°è±îÁö ¹Ýº¹ÇÕ´Ï´Ù.


2´Ü°è: ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ º¹»çº»À» ÀúÀåÇϱâ À§ÇÑ ¹é¾÷ Æú´õ ¸¸µé±â

ÇÏµå µð½ºÅ©¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ º¹»çº»À» ÀúÀåÇϱâ À§ÇÑ Æú´õ¸¦ ¸¸µå½Ê½Ã¿À.

±âº»ÀûÀ¸·Î OSQL Äõ¸® ¿¹Á¦´Â ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ º¹»çº»À» ´ÙÀ½ Æú´õ¿¡ ÀúÀåÇÕ´Ï´Ù.
Drive:\Program Files\Microsoft SQL Server\Mssql$Sharepoint\Backup
ÀÌ Æú´õ´Â WMSDE¿¡ ÀÇÇØ ¸¸µé¾îÁöÁö ¾Ê½À´Ï´Ù. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ º¹»çº»À» ÀúÀåÇÏ´Â µ¥ ÀÌ Æú´õ¸¦ »ç¿ëÇÏ·Á¸é Á÷Á¢ ¸¸µé¾î¾ß ÇÕ´Ï´Ù.



3´Ü°è: OSQL ¸í·ÉÁÙ µµ±¸¸¦ »ç¿ëÇÏ¿© ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º ¹é¾÷

OSQL ¸í·ÉÁÙ µµ±¸¸¦ »ç¿ëÇÏ¿© ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ ¹é¾÷ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. ½ÃÀÛÀ» ´©¸£°í ½ÇÇàÀ» ´©¸¨´Ï´Ù.
  2. ¿­±â »óÀÚ¿¡ cmd¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.
  3. ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ÁÙÀ» ÀÔ·ÂÇÏ°í °¢ ÁÙ ³¡¿¡¼­ Enter Å°¸¦ ´©¸¨´Ï´Ù. ¿©±â¼­ ServerNameÀº ¼­¹öÀÇ À̸§ÀÔ´Ï´Ù.
    osql -S ServerName\sharepoint -E
    backup database STS_ServerName_1 To Disk = 'Drive:\program files\microsoft sql server\mssql$sharepoint\backup\sts_ServerName_1'
    GO
  4. ¹é¾÷ÇÏ·Á´Â °¢ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ 3´Ü°è¸¦ ¹Ýº¹ÇÕ´Ï´Ù.
  5. QUIT¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.

ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º º¹¿ø

ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇÏ°í ´Ù½Ã °¡»ó ¼­¹ö¿¡ Ãß°¡ÇÒ °æ¿ì Windows SharePoint Services°¡ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¿¡ ¾÷µ¥ÀÌÆ®°¡ ÇÊ¿äÇÑÁö ¿©ºÎ¸¦ °¨ÁöÇÒ ¼ö ÀÖÀ¸·Á¸é Ãß°¡ ´Ü°è¸¦ ¼öÇàÇØ¾ß ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, Windows SharePoint ServicesÀÇ ¹é¾÷À» ¼öÇàÇÑ ÈÄ Windows SharePoint Services¿¡ ¾÷µ¥ÀÌÆ®¸¦ Àû¿ëÇÒ °æ¿ì ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ °¡»ó ¼­¹ö¿¡ º¹¿øÇÑ ÈÄ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽ºµµ ¾÷µ¥ÀÌÆ®ÇØ¾ß ÇÕ´Ï´Ù. °¡»ó ¼­¹ö¿¡ º¹¿øÇÑ ÈÄ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽ºµµ ¾÷µ¥ÀÌÆ®ÇÏ·Á¸é °¡»ó ¼­¹ö¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ Á¦°ÅÇÏ°í, OSQL ¸í·ÉÁÙ µµ±¸¸¦ »ç¿ëÇÏ¿© ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇÑ ´ÙÀ½, SharePoint Áß¾Ó °ü¸®¸¦ »ç¿ëÇÏ¿© °¡»ó ¼­¹ö¿¡ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ ´Ù½Ã Ãß°¡ÇØ¾ß ÇÕ´Ï´Ù.

ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.

1´Ü°è: °¡»ó ¼­¹ö¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Á¦°Å

°¡»ó ¼­¹ö¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ Á¦°ÅÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. SharePoint Áß¾Ó °ü¸®¸¦ ½ÃÀÛÇÕ´Ï´Ù.
  2. °¡»ó ¼­¹ö °ü¸®¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º °ü¸®¸¦ ´©¸¨´Ï´Ù.
  3. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º °ü¸® ÆäÀÌÁö¿¡¼­ ¹é¾÷À¸·ÎºÎÅÍ º¹¿øÇÏ·Á´Â ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽ºÀÇ À̸§À» ´©¸¨´Ï´Ù.
  4. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º ¼³Á¤ °ü¸® ÆäÀÌÁöÀÇ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Á¦°Å ¿µ¿ª¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Á¦°Å È®ÀζõÀ» ¼±ÅÃÇÕ´Ï´Ù.
  5. È®ÀÎÀ» ´©¸¨´Ï´Ù.


2´Ü°è: SQL Server 2000 Desktop Engine(Windows)À» ÀϽà ÁßÁöÇÏ¿© ´Üµ¶ Àá±Ý ÇØÁ¦

WMSDE¸¦ ÀϽà ÁßÁöÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. ½ÃÀÛÀ» ´©¸£°í ½ÇÇàÀ» ´©¸¨´Ï´Ù.
  2. ¿­±â »óÀÚ¿¡ cmd¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.
  3. ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ÁÙÀ» ÀÔ·ÂÇÏ°í °¢ ÁÙ ³¡¿¡¼­ Enter Å°¸¦ ´©¸¨´Ï´Ù.

    net pause mssql$sharepoint
    net continue mssql$sharepoint
  4. exit¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.



3´Ü°è: OSQL ¸í·ÉÁÙ µµ±¸¸¦ »ç¿ëÇÏ¿© ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º º¹¿ø

OSQL ¸í·ÉÁÙ µµ±¸¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. ½ÃÀÛÀ» ´©¸£°í ½ÇÇàÀ» ´©¸¨´Ï´Ù.
  2. ¿­±â »óÀÚ¿¡ cmd¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.
  3. ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ÁÙÀ» ÀÔ·ÂÇÏ°í °¢ ÁÙ ³¡¿¡¼­ Enter Å°¸¦ ´©¸¨´Ï´Ù. ¿©±â¼­ ServerNameÀº ¼­¹öÀÇ À̸§ÀÔ´Ï´Ù.
    osql -S ServerName\sharepoint -E
    restore database STS_ServerName_1 from Disk = 'Drive:\program files\microsoft sql server\mssql$sharepoint\backup\sts_ServerName_1'
    GO
  4. º¹¿øÇÏ·Á´Â °¢ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ 3´Ü°è¸¦ ¹Ýº¹ÇÕ´Ï´Ù.
  5. QUIT¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.
Âü°í º¹¿ø ÀÛ¾÷À» ¼öÇàÇÒ ¶§ ´ÙÀ½°ú À¯»çÇÑ ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³¯ ¼ö ÀÖ½À´Ï´Ù.
µ¥ÀÌÅͺ£À̽º°¡ »ç¿ë ÁßÀ̾ ´Üµ¶À¸·Î ¾×¼¼½ºÇÒ ¼ö ¾ø½À´Ï´Ù.
ÀÌ ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³ª¸é º» ¹®¼­ÀÇ 2´Ü°è: SQL Server 2000 Desktop Engine(Windows)À» ÀϽà ÁßÁöÇÏ¿© ´Üµ¶ Àá±Ý ÇØÁ¦ ÀýÀÇ ÀýÂ÷¸¦ ¹Ýº¹ÇϽʽÿÀ.

4´Ü°è: º¹¿øÇÑ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ °¡»ó ¼­¹ö¿¡ Ãß°¡

º¹¿øÇÑ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ °¡»ó ¼­¹ö¿¡ Ãß°¡ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. SharePoint Áß¾Ó °ü¸®¸¦ ½ÃÀÛÇÕ´Ï´Ù.
  2. °¡»ó ¼­¹ö ±¸¼º¿¡¼­ °¡»ó ¼­¹ö ¼³Á¤ ±¸¼ºÀ» ´©¸¨´Ï´Ù.
  3. °¡»ó ¼­¹ö ¸ñ·Ï ÆäÀÌÁö¿¡¼­ µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇÑ °¡»ó ¼­¹öÀÇ À̸§À» ´©¸¨´Ï´Ù.
  4. °¡»ó ¼­¹ö ¼³Á¤ ÆäÀÌÁöÀÇ °¡»ó ¼­¹ö °ü¸®¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º °ü¸®¸¦ ´©¸¨´Ï´Ù.
  5. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º °ü¸® ÆäÀÌÁöÀÇ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Ãß°¡¸¦ ´©¸¨´Ï´Ù.
  6. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Ãß°¡ ÆäÀÌÁöÀÇ µ¥ÀÌÅͺ£À̽º Á¤º¸ ¿µ¿ª¿¡¼­ µ¥ÀÌÅͺ£À̽º ¼­¹ö ¼³Á¤ ÁöÁ¤À» ´©¸¥ ´ÙÀ½ µ¥ÀÌÅͺ£À̽ºÀÇ À̸§°ú µ¥ÀÌÅͺ£À̽º ¼­¹öÀÇ À̸§À» ÁöÁ¤ÇÕ´Ï´Ù.
  7. µ¥ÀÌÅͺ£À̽º ¿ë·® ¼³Á¤ ¿µ¿ªÀÇ °æ°í À̺¥Æ®°¡ ¹ß»ýµÇ±â ÀüÀÇ »çÀÌÆ® ¼ö »óÀÚ¿¡ ¿øÇÏ´Â ¼ýÀÚ¸¦ ÀÔ·ÂÇÕ´Ï´Ù.
  8. È®ÀÎÀ» ´©¸¨´Ï´Ù.
  9. Ãß°¡ÇÏ·Á´Â °¢ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ 2´Ü°èºÎÅÍ 8´Ü°è±îÁö ¹Ýº¹ÇÕ´Ï´Ù.


ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ ´Ù¸¥ ¼­¹ö¿¡ º¹¿ø

ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ ´Ù¸¥ ¼­¹ö¿¡ º¹¿øÇØ¾ß ÇÏ´Â »óȲÀÌ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, Windows SharePoint Services À¥ »çÀÌÆ®¿¡¼­ µ¥ÀÌÅÍ°¡ ½Ç¼ö·Î »èÁ¦µÈ °æ¿ì Àüü ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽ºÀÇ º¹¿øÀ» ¿øÇÏÁö ¾ÊÀ» ¼ö ÀÖ½À´Ï´Ù. ¸¶Áö¸· ¹é¾÷ ÀÛ¾÷ÀÌ ¼öÇàµÈ ÈÄ »çÀÌÆ®¿¡ Ãß°¡µÈ Ãß°¡ µ¥ÀÌÅÍ°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. ÀÌ¿Í °°Àº »óȲ¿¡¼­´Â ´Ù¸¥ ¼­¹ö¿¡ Windows SharePoint Services¸¦ ¼³Ä¡ÇÑ ´ÙÀ½ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ »õ·Î¿î ¼­¹ö¿¡ º¹¿øÇÕ´Ï´Ù. ±âÁ¸ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ »õ·Î¿î ¼­¹ö¿¡ º¹¿øÇÏ°í º¹¿øÇÑ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ °¡»ó ¼­¹ö¿¡ Ãß°¡ÇÑ ÈÄ¿¡´Â »õ·Î¿î ¼­¹öÀÇ ¼­¹ö À̸§À» »ç¿ëÇÏ¿© Windows SharePoint Services¿¡ ¿¬°áÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, http://ServerNameÀ» »ç¿ëÇÏ¿© À¥ »çÀÌÆ®¿¡ ¿¬°áÇÒ ¼ö ÀÖ½À´Ï´Ù. À¥ »çÀÌÆ®¿¡´Â ¸¶Áö¸· ¹é¾÷ ½Ã Á¸ÀçÇß´ø µ¥ÀÌÅÍ°¡ Ç¥½ÃµË´Ï´Ù.

ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ ´Ù¸¥ ¼­¹ö¿¡ º¹¿øÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.

1´Ü°è: ´Ù¸¥ ¼­¹ö¿¡ Windows SharePoint Services ¼³Ä¡
  1. Microsoft Windows Server 2003ÀÌ ½ÇÇàµÇ´Â ´Ù¸¥ ¼­¹ö¿¡ Windows SharePoint Services¸¦ ¼³Ä¡ÇÕ´Ï´Ù. Windows SharePoint Services ¼³Ä¡ ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft Windows SharePoint Services 2.0 °ü¸®ÀÚ °¡À̵åÀÇ "¼³Ä¡(Installation)" ÀåÀ» ÂüÁ¶ÇϽʽÿÀ.
  2. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ º¹»çº»À» ±âÁ¸ ¼­¹ö¿¡¼­ »õ·Î¿î ¼­¹ö·Î º¹»çÇÕ´Ï´Ù.


2´Ü°è: OSQL ¸í·ÉÁÙ µµ±¸¸¦ »ç¿ëÇÏ¿© ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º º¹¿ø

OSQL ¸í·ÉÁÙ µµ±¸¸¦ »ç¿ëÇÏ¿© ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. ½ÃÀÛÀ» ´©¸£°í ½ÇÇàÀ» ´©¸¨´Ï´Ù.
  2. ¿­±â »óÀÚ¿¡ cmd¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.
  3. ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ÁÙÀ» ÀÔ·ÂÇÏ°í °¢ ÁÙ ³¡¿¡¼­ Enter Å°¸¦ ´©¸¨´Ï´Ù. ¿©±â¼­ ServerNameÀº ¼­¹öÀÇ À̸§ÀÔ´Ï´Ù.
    osql -S ServerName\sharepoint -E
    restore database STS_ServerName_1 from Disk = 'Drive:\program files\microsoft sql server\mssql$sharepoint\backup\sts_ServerName_1'
    GO
  4. º¹¿øÇÏ·Á´Â °¢ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ 3´Ü°è¸¦ ¹Ýº¹ÇÕ´Ï´Ù.
  5. QUIT¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.


3´Ü°è: SQL ±ÇÇÑ ±¸¼º

SharePoint Áß¾Ó °ü¸®¸¦ »ç¿ëÇÏ¿© ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ °¡»ó ¼­¹ö¿¡ Ãß°¡ÇÒ ¼ö ÀÖµµ·Ï SQL ±ÇÇÑÀ» ±¸¼ºÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. ½ÃÀÛÀ» ´©¸£°í ½ÇÇàÀ» ´©¸¨´Ï´Ù.
  2. ¿­±â »óÀÚ¿¡ cmd¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.
  3. ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ÁÙÀ» ÀÔ·ÂÇÏ°í °¢ ÁÙ ³¡¿¡¼­ Enter Å°¸¦ ´©¸¨´Ï´Ù. ¿©±â¼­ ServerNameÀº ¼­¹öÀÇ À̸§ÀÔ´Ï´Ù.
    osql -S ServerName \sharepoint -E sp_addsrvrolemember 'nt authority\network service', 'sysadmin'
    GO
  4. exit¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.
Âü°í ÀÌ ÀýÂ÷´Â ³×Æ®¿öÅ© ¼­ºñ½º °èÁ¤À» SQL sysadmin ¿ªÇÒ¿¡ Ãß°¡ÇÕ´Ï´Ù. ³×Æ®¿öÅ© ¼­ºñ½º °èÁ¤Àº WMSDE¸¦ »ç¿ëÇÑ ¼³Ä¡¸¦ À§ÇØ Windows SharePoint Services¿¡¼­ »ç¿ëµÇ´Â ±âº» Windows °èÁ¤ÀÔ´Ï´Ù. Windows SharePoint Services´Â ³×Æ®¿öÅ© ¼­ºñ½º °èÁ¤ ÄÁÅؽºÆ®¿¡¼­ ½ÇÇàµÇ¾î WMSDE¿¡ ¿¬°áÇÕ´Ï´Ù. ¿ø°Ý SQL ¼­¹ö¸¦ ±¸ÇöÇÏ°í µµ¸ÞÀÎ °èÁ¤À» »ç¿ëÇÒ °æ¿ì µ¥ÀÌÅͺ£À̽º¸¦ °¡»ó ¼­¹ö¿¡ Ãß°¡Çϱâ Àü¿¡ µµ¸ÞÀÎ °èÁ¤À» dbo(µ¥ÀÌÅͺ£À̽º ¼ÒÀ¯ÀÚ)·Î ±¸¼ºÇØ¾ß ÇÕ´Ï´Ù.

SQL Server 2000 Desktop Engine(Windows)¿¡¼­ Microsoft SQL Server·ÎÀÇ ¸¶À̱׷¹À̼ǿ¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft Windows SharePoint Services 2.0 °ü¸®ÀÚ °¡À̵åÀÇ "¹é¾÷ ¹× ¸¶À̱׷¹À̼Ç(Backup and Migration)" Àå¿¡¼­ "WMSDE¿¡¼­ SQL Server·Î ¸¶À̱׷¹À̼Ç(Migrating from WMSDE to SQL Server)" Ç׸ñÀ» ÂüÁ¶ÇϽʽÿÀ. ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
828815
(http://support.microsoft.com/kb/828815/ )
Windows SharePoint Services ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ °ü¸®ÇÒ ¶§ "<Database_Name> µ¥ÀÌÅͺ£À̽º°¡ ÀÌ¹Ì ÀÖ½À´Ï´Ù." ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³­´Ù


4´Ü°è: °¡»ó ¼­¹ö¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Á¦°Å

°¡»ó ¼­¹ö¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ Á¦°ÅÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. SharePoint Áß¾Ó °ü¸®¸¦ ½ÃÀÛÇÕ´Ï´Ù.
  2. °¡»ó ¼­¹ö °ü¸®¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º °ü¸®¸¦ ´©¸¨´Ï´Ù.
  3. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º °ü¸® ÆäÀÌÁö¿¡¼­ ¼­¹ö¿¡ Windows SharePoint Services¸¦ ¼³Ä¡ÇÒ ¶§ ¸¸µé¾îÁø µ¥ÀÌÅͺ£À̽ºÀÇ À̸§À» ´©¸¨´Ï´Ù.
  4. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º ¼³Á¤ °ü¸® ÆäÀÌÁöÀÇ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Á¦°Å ¿µ¿ª¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Á¦°Å È®ÀζõÀ» ¼±ÅÃÇÕ´Ï´Ù.
  5. È®ÀÎÀ» ´©¸¨´Ï´Ù.


5´Ü°è: º¹¿øÇÑ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ °¡»ó ¼­¹ö¿¡ Ãß°¡

º¹¿øÇÑ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º¸¦ °¡»ó ¼­¹ö¿¡ Ãß°¡ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. Áß¾Ó °ü¸® ÆäÀÌÁöÀÇ °¡»ó ¼­¹ö ±¸¼º¿¡¼­ °¡»ó ¼­¹ö ¼³Á¤ ±¸¼ºÀ» ´©¸¨´Ï´Ù.
  2. °¡»ó ¼­¹ö ¸ñ·Ï ÆäÀÌÁö¿¡¼­ °¡»ó ¼­¹öÀÇ À̸§À» ´©¸¨´Ï´Ù.
  3. °¡»ó ¼­¹ö ¼³Á¤ ÆäÀÌÁöÀÇ °¡»ó ¼­¹ö °ü¸®¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Ãß°¡¸¦ ´©¸¨´Ï´Ù.
  4. °¡»ó ¼­¹ö ¼³Á¤ ÆäÀÌÁöÀÇ °¡»ó ¼­¹ö °ü¸®¿¡¼­ ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º °ü¸®¸¦ ´©¸¨´Ï´Ù.
  5. ÄÜÅÙÆ® µ¥ÀÌÅͺ£À̽º Ãß°¡ ÆäÀÌÁöÀÇ µ¥ÀÌÅͺ£À̽º Á¤º¸ ¿µ¿ª¿¡¼­ µ¥ÀÌÅͺ£À̽º ¼­¹ö ¼³Á¤ ÁöÁ¤À» ´©¸¥ ´ÙÀ½ µ¥ÀÌÅͺ£À̽ºÀÇ À̸§°ú µ¥ÀÌÅͺ£À̽º ¼­¹öÀÇ À̸§À» ÁöÁ¤ÇÕ´Ï´Ù.
  6. µ¥ÀÌÅͺ£À̽º ¿ë·® ¼³Á¤ ¿µ¿ªÀÇ °æ°í À̺¥Æ®°¡ ¹ß»ýµÇ±â ÀüÀÇ »çÀÌÆ® ¼ö »óÀÚ¿¡ ¿øÇÏ´Â ¼ýÀÚ¸¦ ÀÔ·ÂÇÕ´Ï´Ù.
  7. È®ÀÎÀ» ´©¸¨´Ï´Ù.


6´Ü°è: SQL ±ÇÇÑÀ» ´Ù½Ã ¿ø·¡ ¼³Á¤À¸·Î ±¸¼º

SQL Server ±ÇÇÑÀ» ´Ù½Ã ¿ø·¡ ¼³Á¤À¸·Î ±¸¼ºÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
  1. ½ÃÀÛÀ» ´©¸£°í ½ÇÇàÀ» ´©¸¨´Ï´Ù.
  2. ¿­±â »óÀÚ¿¡ cmd¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.
  3. ¸í·É ÇÁ·ÒÇÁÆ®¿¡¼­ ´ÙÀ½ ÁÙÀ» ÀÔ·ÂÇÏ°í °¢ ÁÙ ³¡¿¡¼­ Enter Å°¸¦ ´©¸¨´Ï´Ù. ¿©±â¼­ ServerNameÀº ¼­¹öÀÇ À̸§ÀÔ´Ï´Ù.
    osql -S ServerName \sharepoint -E sp_dropsrvrolemember 'nt authority\network service', 'sysadmin'
    GO
  4. exit¸¦ ÀÔ·ÂÇÑ ´ÙÀ½ Enter Å°¸¦ ´©¸¨´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÂüÁ¶

Microsoft Windows SharePoint Services 2.0 °ü¸®ÀÚ °¡À̵带 ±¸ÇÏ·Á¸é ´ÙÀ½ Microsoft À¥ »çÀÌÆ®¸¦ ¹æ¹®ÇϽʽÿÀ.
http://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-a6a4-3e33fa13d230&displaylang=en
(http://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-a6a4-3e33fa13d230&displaylang=en)
(¿µ¹®)
Windows SharePoint Services¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ Microsoft À¥ »çÀÌÆ®¸¦ ÂüÁ¶ÇϽʽÿÀ.
http://www.microsoft.com/technet/windowsserver/sharepoint/default.mspx
(http://www.microsoft.com/technet/windowsserver/sharepoint/default.mspx)
(¿µ¹®)




Microsoft Á¦Ç° °ü·Ã ±â¼ú Àü¹®°¡µé°ú ¿Â¶óÀÎÀ¸·Î Á¤º¸¸¦ ±³È¯ÇϽ÷Á¸é Microsoft ´º½º ±×·ì
(http://support.microsoft.com/newsgroups/default.aspx)
¿¡ Âü¿©ÇϽñ⠹ٶø´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

¼Ó¼º

±â¼ú ÀÚ·á: 833797 - ¸¶Áö¸· °ËÅä: 2007³â 2¿ù 20ÀÏ È­¿äÀÏ - ¼öÁ¤: 2.2
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft Windows SharePoint Services
Å°¿öµå:?
kbhowto kbbackup kbwebservices KB833797
À§·Î °¡±â | Çǵå¹é º¸³»±â

Çǵå¹é º¸³»±â

 
À§·Î °¡±âÀ§·Î °¡±â