SQL Server 2000¡¿MSDE¤Î¥Ð¡¼¥¸¥ç¥ó¤ò¥Á¥§¥Ã¥¯¤¹¤ëhttp://www.atmarkit.co.jp/fwin2k/win2ktips/610sqlver/sqlver.html
¿·µ¬PC¤ËSQLServer2000¤ò¥¤¥ó¥¹¥È¡¼¥ë
¥Ç¥Õ¥©¥ë¥ÈÀßÄê¤Î¥¤¥ó¥¹¥È¡¼¥ë¤ÇOK(¤¢¤¯¤Þ¤Ç¤â¤¦¤Á¤Î¾ì¹ç¤Ï¡¢¤Ç¤¹)
¸½SQLServer¤ÈƱÅù¤ÎSP¤òdownlord¤·Å¬ÍѤ¹¤ëhttp://www.microsoft.com/japan/technet/prodtechnol/sql/2000/downloads/default.mspx
¢¨¥Ç¡¼¥¿¥Ù¡¼¥¹¥³¥ó¥Ý¡¼¥Í¥ó¥È¤À¤±¤Ç¤è¤¤
¢¨¤¿¤À¤·ºÇÄã¤Ç¤âSP3a°Ê¾å¤Ë¤¹¤ëɬÍפ¢¤ê¡Ê¥ï¡¼¥àÂкö¡Ë
ÆÈ¼«¤ËºîÀ®¤·¤¿¥Ç¡¼¥¿¥Ù¡¼¥¹¤òRestore¤·¡¢¸µ¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÈƱÍͤι½À®¤Ë¤¹¤ë¸µ¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÈƱÍͤι½À®¤Ç¤Ê¤¤¤È¡¢master¥Ç¡¼¥¿¥Ù¡¼¥¹Restore¤ÎºÝ¥¨¥é¡¼¤¬½Ð¤ë
master¥Ç¡¼¥¿¥Ù¡¼¥¹¤òRestore,¥·¥ó¥°¥ë¥æ¡¼¥¶¥â¡¼¥É¤Ç¼Â¹Ô¤¹¤ë(²¼µURL»²¾È)http://www.sqlpassj.org/tokushu/backup/06.aspx
¾åµURL¤Ç¤Ï¥³¥Þ¥ó¥É¥³¥Ô¥Ú¤Ç¤¤Ê¤¤¤Î¤Ç¥á¥â
¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤½¤Î£±cd "C:\Program Files\Microsoft SQL Server\MSSQL\Binn"
sqlservr -c -m
¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤½¤Î£²osql -E
RESTORE DATABASE master FROM DISK = '(¤³¤³¤Ëbackup data¤Î¥Ñ¥¹+¥Õ¥¡¥¤¥ë̾)'
go
¢¨¥Ñ¥¹+¥Õ¥¡¥¤¥ë̾¤Ï¤ªÇ¦¤Ó¥Ä¡¼¥ë¤òÆþ¤ì¤Æ¤ª¤¯¤È³Ú
model, msdb¥Ç¡¼¥¿¥Ù¡¼¥¹¤òRestoreÆÃ¤Ë½ñ¤¯¤³¤È¤Ê¤·
ǰ¤Î¤¿¤áÆÈ¼«ºîÀ®¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºÆRestore
SQL Server Agent¤ÎAuto Start
[SQL Server Enterprise Manager]µ¯Æ°→(Local)(Windows NT)¤Î¥×¥í¥Ñ¥Æ¥£¤ò³«¤¯
[General]¥¿¥Ö→[Autostart SQL Server Agent]¤ò¥Á¥§¥Ã¥¯¤·¤Æ[OK]
SQL Server Agent¤ÎÀßÄê[SQL Server Enterprise Manager]µ¯Æ°→(Local)(Windows NT)→[Management]→[SQL Server Agent]¤Î¥×¥í¥Ñ¥Æ¥£¤ò³«¤¯
[Advanced]¥¿¥Ö→[Restart services]¤òξÊý¤È¤â¥Á¥§¥Ã¥¯¤·¤Æ[OK]
- 2009/07/11(ÅÚ) 11:53:10|
- SQL¥µ¡¼¥Ð´ÉÍý
-
| ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¡§0
-
| ¥³¥á¥ó¥È¡§7
SQL Server¤Îǧ¾Ú¥â¡¼¥É¤òÊѹ¹Enterprise Managerµ¯Æ°→[Microsoft SQL Servers]→[SQL Server Group]→[(³ºÅö¤¹¤ëServer̾)]¤ò±¦¥¯¥ê¥Ã¥¯→[¥×¥í¥Ñ¥Æ¥£]
[Security]¥¿¥Ö→¾å¤ÎSecurityÏÈ→[Authentication]¤ò[Windows Only]→[SQL Server and Windows]¤ËÊѹ¹
[Security]¥¿¥Ö→²¼¤ÎStartup service accountÏÈ→[Start and run(ά)]¤ò[This account]→[System account]¤ËÊѹ¹
SQL Server¤ÎPC¼«ÂΤò¸½¥É¥á¥¤¥ó¤«¤éWorkGroup¤ØÊѹ¹[¥Þ¥¤¥³¥ó¥Ô¥å¡¼¥¿]±¦¥¯¥ê¥Ã¥¯→[¥×¥í¥Ñ¥Æ¥£]→[¥Í¥Ã¥È¥ï¡¼¥¯ID]¥¿¥Ö→[¥×¥í¥Ñ¥Æ¥£]¤Ç¥ï¡¼¥¯¥°¥ë¡¼¥×¤ËÊѹ¹→ºÆµ¯Æ°
ºÆµ¯Æ°¸å¡¢TCP/IP¤ÎÀßÄê¤ÇÍ¥ÀèDNS¥µ¡¼¥Ð¤ò¿·¥É¥á¥¤¥óÍѤËÊѹ¹¤¹¤ë
SQL Server¤ÎPC¼«ÂΤòWorkGroup¤«¤é¿·¥É¥á¥¤¥ó¤ØÊѹ¹
¾åµ¤ÈƱÍͤμê½ç&ºÆµ¯Æ°
SQL Server¤Îǧ¾Ú¥â¡¼¥É¤ò¿·¥É¥á¥¤¥óÍѤËÊѹ¹¤¹¤ë[Authentication]¤ò[Windows Only]¤ËÊѹ¹
[Start and run(ά)]¤ò[This account]¤ËÊѹ¹¡£account¤Ï(¥É¥á¥¤¥ó̾)\administrator¤Ç¤è¤·¡£(¥É¥á¥¤¥ó̾)¤ÎÁ°¤Ë\\¤ÏÉÔÍס£
SQL Server¤Îlogon¸¢¸Â¤Ë¿·¥É¥á¥¤¥ó¤Îʬ¤òÄɲÃEnterprise Managerµ¯Æ°→[Microsoft SQL Servers]→[SQL Server Group]→[(³ºÅö¤¹¤ëServer̾)]→[Security]→[Logins]
¤³¤³¤Ç¡¢µì¥É¥á¥¤¥ó¤Î¸¢¸Â¤ò¤Þ¤Í¤·¤Æ¿·¥É¥á¥¤¥ó¤Î¸¢¸Â¤òºîÀ®¡£Êª¤Ë¤è¤Ã¤Æ¤Ï¿·µì¤Î½ÅÊ£ÉԲĤʤΤǵì¤Ï¾Ã¤¹¤³¤È¤Ë¤Ê¤ë¡£
SQL Server Agent¤Î¥¢¥«¥¦¥ó¥È¤òÊѹ¹Enterprise Managerµ¯Æ°→[Microsoft SQL Servers]→[SQL Server Group]→[(³ºÅö¤¹¤ëServer̾)]→[Management]→[SQL Server Agent]→±¦¥¯¥ê¥Ã¥¯¤·¤Æ[¥×¥í¥Ñ¥Æ¥£]
[General]¥¿¥Ö¤Î[Service Startup Account]¤Î[This account]¤Ç(¥É¥á¥¤¥ó̾)\administrator¤È¥Ñ¥¹¥ï¡¼¥É¤òÆþÎϤ·¤Æ´°Î»¡£
- 2009/07/11(ÅÚ) 11:35:13|
- SQL¥µ¡¼¥Ð´ÉÍý
-
| ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¡§0
-
| ¥³¥á¥ó¥È¡§0
º£²ó¤Î¤ªÂêÌÜ
GC¤¬£±¤Ä¤·¤«¤Ê¤¤¤È²¿¤«¤ÈÉ԰¤ʤΤǾéĹ²½¤·¤Æ¤ª¤¯¾ì¹ç¤¬Â¿¤¤¡£¥µ¥¤¥È¤¬Ê¬¤«¤ì¤Æ¤¤¤ë¤Ê¤é¥µ¥¤¥È¤Ë1¤Ä¤Ï¤Û¤·¤¤¡£¤È¤¤¤¦¤ï¤±¤ÇGC¤ò»ý¤Ã¤Æ¤¤¤Ê¤¤DC¤ËÄɲ乤ëÊýË¡¡£
GC¤ÎÄɲÃÊýË¡
1. [Active Directory¥µ¥¤¥È¤È¥µ¡¼¥Ó¥¹]¤òΩ¤Á¾å¤²¤ë
2. [Sites]
¡¡¡¡¡¡ø[(ÌÜŪ¤ÎDC¤¬¤¢¤ë¥µ¥¤¥È)]
¡¡¡¡¡¡¡¡¡¡¡¡ø[Servers]
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ø[ÌÜŪ¤ÎDC]
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ø[NTDS Settings]→[¥×¥í¥Ñ¥Æ¥£]ɽ¼¨
3.[Á´ÈÌ]¥¿¥Ö¤Î[¥°¥í¡¼¥Ð¥ë¥«¥¿¥í¥°]¥Á¥§¥Ã¥¯¤òOn
°Ê¾å¡£
¢¨GC¤È¥¤¥ó¥Õ¥é¥¹¥È¥é¥¯¥Á¥ã¡¦¥Þ¥¹¥¿(FSMO¤Îµ¡Ç½¤Î£±¤Ä)¤ÏÊÌ¡¹¤ÎDC¤ËÀßÄꤹ¤ë¤³¤È¡£
¤¿¤À¤·
¡¦Ã±°ì¥É¥á¥¤¥ó¤Î¥Õ¥©¥ì¥¹¥È¤Î¾ì¹ç
¡¦Á´¤Æ¤ÎDC¤¬GC¤òÊÝ»ý¤¹¤ë¾ì¹ç
¾å¤Î¤¤¤º¤ì¤«¤Î¾ò·ï¤ËÅö¤Æ¤Ï¤Þ¤ë¾ì¹ç¤Ïµ¤¤Ë¤·¤Ê¤¯¤Æ¤è¤¤¡£
- 2007/07/18(¿å) 13:56:55|
- GC
-
| ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¡§0
-
| ¥³¥á¥ó¥È¡§40
º£²ó¤Î¤ªÂêÌÜFSMO¤Îµ¡Ç½¤Ï°Ê²¼¤Î£µ¤Ä¡£´ÉÍý¥Ä¡¼¥ë¤È¤·¤Æ¤Ï£³¼ïÎà¤Ê¤Î¤Ç¡¢¤³¤Î¥Ä¡¼¥ë¤ò¤Þ¤È¤á¤ÆFSMO³Îǧ¡õ°ÜưÍÑ¥³¥ó¥½¡¼¥ë¤òºîÀ®¤¹¤ë¡£
| | FSMOµ¡Ç½ | ´ÉÍý¥Ä¡¼¥ë |
| 1 | ¥¹¥¡¼¥Þ¡¦¥Þ¥¹¥¿ | Active Directory¥¹¥¡¼¥Þ |
| 2 | ¥É¥á¥¤¥ó̾Á°ÉÕ¤±Áàºî¥Þ¥¹¥¿ | Active Directory¥É¥á¥¤¥ó¤È¿®Íê´Ø·¸ |
| 3 | RID | Active Directory¥æ¡¼¥¶¡¼¤È¥³¥ó¥Ô¥å¡¼¥¿ |
| 4 | PDC¥¨¥ß¥å¥ì¡¼¥¿ | Active Directory¥æ¡¼¥¶¡¼¤È¥³¥ó¥Ô¥å¡¼¥¿ |
| 5 | ¥¤¥ó¥Õ¥é¥¹¥È¥é¥¯¥Á¥ã¡¦¥Þ¥¹¥¿ | Active Directory¥æ¡¼¥¶¡¼¤È¥³¥ó¥Ô¥å¡¼¥¿ |
1.FSMO¥³¥ó¥½¡¼¥ë¤ÎºîÀ®
1.1 ¥¹¥¡¼¥Þ¡¦¥¹¥Ê¥Ã¥×¥¤¥ó¤ÎÅÐÏ¿¡£[¥¹¥¿¡¼¥È] ¥Ü¥¿¥ó→[¥Õ¥¡¥¤¥ë̾¤ò»ØÄꤷ¤Æ¼Â¹Ô]→¡Öregsvr32 schmmgmt.dll ¡×¤ÈÆþÎÏ→[OK] ¤ò¥¯¥ê¥Ã¥¯¡£ÅÐÏ¿¤¬Àµ¾ï¤Ë½ªÎ»¤·¤¿¤È¤¤¤¦¥á¥Ã¥»¡¼¥¸¤¬É½¼¨¤µ¤ì¤ë¡£
1.2 [¥¹¥¿¡¼¥È]→[¥Õ¥¡¥¤¥ë̾¤ò»ØÄꤷ¤Æ¼Â¹Ô]→¡Ömmc¡× ¤ÈÆþÎÏ→[OK]
1.3 [¥³¥ó¥½¡¼¥ë] ¥á¥Ë¥å¡¼→[¥¹¥Ê¥Ã¥×¥¤¥ó¤ÎÄɲäȺï½ü]→[ÄɲÃ]
1.4 [Active Directory ¥¹¥¡¼¥Þ]¤òÁªÂò¤·¤Æ[ÄɲÃ]
1.5 [Active Directory¥É¥á¥¤¥ó¤È¿®Íê´Ø·¸]¤òÁªÂò¤·¤Æ[ÄɲÃ]
1.6 [Active Directory¥æ¡¼¥¶¡¼¤È¥³¥ó¥Ô¥å¡¼¥¿]¤òÁªÂò¤·¤Æ[ÄɲÃ]
1.7 [¥³¥ó¥½¡¼¥ë] ¥á¥Ë¥å¡¼→[̾Á°¤òÉÕ¤±¤ÆÊݸ]→¡ÖFSMO¡×¤ÈÆþÎÏ¡£¥Ç¥Õ¥©¥ë¥È¤Ç´ÉÍý¥Ä¡¼¥ë¥Õ¥©¥ë¥À¤Ë¥ê¥ó¥¯¤µ¤ì¤ë¡£
2.¥³¥ó¥½¡¼¥ë¤«¤éFSMO¤ò³Îǧ¤¹¤ë
2.1 ÅÐÏ¿¤·¤¿3¤Ä¤Î¥¹¥Ê¥Ã¥×¥¤¥ó¤ò¤½¤ì¤¾¤ì±¦¥¯¥ê¥Ã¥¯→[Áàºî¥Þ¥¹¥¿]¤Ç¤É¤ÎDC¤ËFSMO¤¬¤¢¤ë¤Î¤«¤¬Ê¬¤«¤ë¡£
3.FSMO¤Î°Üư
3.1 ¥¹¥¡¼¥Þ¡¦¥Þ¥¹¥¿¤Î°Üư
3.1.1 FSMO°ÜưÀè¤ÎDC¤Ç¾åµFSMO¥³¥ó¥½¡¼¥ë¤òºîÀ®¤¹¤ë
3.1.2 [Active Directory¥¹¥¡¼¥Þ]¤ò±¦¥¯¥ê¥Ã¥¯→[¥É¥á¥¤¥ó¥³¥ó¥È¥í¡¼¥é¤ÎÊѹ¹]
3.1.3 [Ǥ°Õ¤ÎDC]¤òÁª¤ó¤Ç[OK]¡£¼«Ê¬¤ÎDC¤¬ÁªÂò¤µ¤ì¤ë
3.1.4 [Active Directory¥¹¥¡¼¥Þ]¤ò±¦¥¯¥ê¥Ã¥¯→[Áàºî¥Þ¥¹¥¿]
3.1.5 [¤³¤Î¥É¥á¥¤¥ó¥³¥ó¥È¥í¡¼¥é¤Ç¥¹¥¡¼¥Þ¤Î½¤Àµ¤¬²Äǽ]¤ò¥Á¥§¥Ã¥¯→[Êѹ¹]
3.2 ¥É¥á¥¤¥ó̾Á°ÉÕ¤±Áàºî¥Þ¥¹¥¿¤Î°Üư
3.2.1 FSMO°ÜưÀè¤ÎDC¤Ç¾åµFSMO¥³¥ó¥½¡¼¥ëΩ¤Á¾å¤²
3.2.2 [Active Directory¥É¥á¥¤¥ó¤È¿®Íê´Ø·¸]¤ò±¦¥¯¥ê¥Ã¥¯→[Áàºî¥Þ¥¹¥¿]
3.2.3 [Êѹ¹]¤ò²¡¤»¤Ð¼«Ê¬¤ÎDC¤Ë°Üư¤¹¤ë
3.3 ¤½¤Î¾3¤Ä¤Îµ¡Ç½¤Î°Üư
3.3.1 FSMO°ÜưÀè¤ÎDC¤Ç¾åµFSMO¥³¥ó¥½¡¼¥ëΩ¤Á¾å¤²
3.3.2 [Active Directory¥æ¡¼¥¶¡¼¤È¥³¥ó¥Ô¥å¡¼¥¿]¤ò±¦¥¯¥ê¥Ã¥¯→[Áàºî¥Þ¥¹¥¿]
3.3.3 ³ºÅö¤¹¤ë£³¤Ä¤Î¥¿¥Ö¤¬¤¢¤ë¤Î¤Ç¡¢¤½¤ì¤¾¤ìÀÚ¤êÂØ¤¨¤Æ[Êѹ¹]
°Ê¾å¡£
Ãí°ÕÅÀ¤È¤·¤Æ¤Ï¡¢¤³¤ÎÁàºî¤Ç¤ÏGC¤ÏÊѹ¹¤µ¤ì¤Ê¤¤¤Î¤Ç¡¢ÊÌÅÓÀßÄꤹ¤ëɬÍפ¬¤¢¤ë¡£
- 2007/07/18(¿å) 10:12:04|
- FSMO
-
| ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¡§0
-
| ¥³¥á¥ó¥È¡§0
¸½¾Ý
DFS¤«¤éÈ´¤±¤¿¤¤DC¤¬¤¢¤ë¾ì¹ç¡¢ÂоݤȤʤë"¥ë¡¼¥ÈÊ£À½Êª"¤ò¶¯À©Åª¤Ëºï½ü(¤³¤Î¤È¤"¶¯À©Åª¤Ëºï½ü¤·¤Þ¤¹¤«¡©"¤È¤¤¤¦¥¦¥£¥ó¥É¥¦¤¬½Ð¤¿¡£½Ð¸½¤¹¤ë¾ò·ï¤ÏÆæ)¤·¤Æ¤·¤Þ¤¦¤È°Ê²¼¤Î¸½¾Ý¤¬µ¯¤¤¿¡£¡£
¡¦DFS¥ë¡¼¥È¥Õ¥©¥ë¥À¤ò[¤³¤Î¥Õ¥©¥ë¥À¤ò¶¦Í¤·¤Ê¤¤]¤Ë¤·¤è¤¦¤È¤·¤Æ¤âÉÔ²Ä
¡¦ºï½ü¤·¤¿¥ë¡¼¥ÈÊ£À½Êª¤òºÆºîÀ®¤·¤è¤¦¤È¤·¤Æ¤â"¤³¤Î¥µ¡¼¥Ð¤Ï´û¤ËDFS¥ë¡¼¥È¤Î¥Û¥¹¥È¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹"¤È¤¤¤¦¥¨¥é¡¼¤¬½Ð¤ÆºîÀ®¤Ç¤¤Ê¤¤
ÂнèÊýË¡
1.Windows2000¥µ¥Ý¡¼¥È¥Ä¡¼¥ë¤ò¥¤¥ó¥¹¥È¡¼¥ë¡£Win2000CD:\SUPPORT\TOOLS\setup.exe¤ò¼Â¹Ô¤·¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë¤³¤È¡£
2.¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤Ç°Ê²¼¤Î¥³¥Þ¥ó¥É¤ò¼Â¹Ô¡£
dfsutil /addroot:(DFS¥ë¡¼¥È) /server:(¥µ¡¼¥Ð̾) /share:(¶¦Í̾)
¡¡DFS¥ë¡¼¥È…DFS¥ë¡¼¥È¤Î¥Õ¥©¥ë¥À̾
¡¡¥µ¡¼¥Ð̾…¥ë¡¼¥ÈÊ£À½Êª¤òºï½ü¤·¤¿¥µ¡¼¥Ð̾
¡¡¶¦Í̾…DFS¥ë¡¼¥È¤Î¥Õ¥©¥ë¥À¤Î¶¦Í̾¡£¥Õ¥©¥ë¥À̾¤È¤¿¤Ö¤óƱ¤¸
¤³¤ì¤ò¼Â¹Ô¤¹¤ë¤È¡¢ºï½ü¤·¤¿(¤è¤¦¤Ë¸«¤¨¤Æ¤¤¤¿)¥ë¡¼¥ÈÊ£À½Êª¤¬ºÆÅÐÏ¿¤µ¤ì¤ë¡£ ¤½¤Î¸å¡¢(¶¯À©±¾¡¹¤Î¥¦¥£¥ó¥É¥¦¤¬½Ð¤Ê¤¤¤³¤È¤òµ§¤Ã¤Æ)ºÆÅÙºï½ü¤¹¤ë¤Ê¤ê¤¹¤ë¡£¤¦¤Á¤Î´Ä¶¤Ç¤Ï£²ÅÙÌܤϤ¹¤ó¤Ê¤êºï½ü¤Ç¤¤¿¡£
- 2007/07/17(²Ð) 20:02:50|
- DFS.
-
| ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¡§0
-
| ¥³¥á¥ó¥È¡§0