·¢²¼Ê±¼ä : ÐÇÆÚËÄ ÎÄÕÂÊý¾Ý¿âʵÑ鱨¸æÒ» - ͼÎĸüÐÂÍê±Ï¿ªÊ¼ÔĶÁ
2¡¢Êý¾Ý¿âÑ¡ÔñµÄÊÇĬÈÏλÖã¬Òª¸Ä±ä·¾¶£¬ÓÒ¼ü¡ª¡ªÊôÐÔ¡ª¡ªÊý¾Ý¿âÉèÖã¬Ìîд·¾¶±£´æ¼´¿É¡£
ʵÑé¶þ SQL Server³£ÓùÜÀí¹¤¾ßºÍʹÓÃ
ʵÑéÄ¿µÄ
1. Àí½â·þÎñµÄ¸ÅÄÕÆÎÕSQL Server·þÎñµÄÆô¶¯¡¢ÔÝÍ£ºÍÍ£Ö¹¡£
2. ÊìϤSQL ServerÅäÖùÜÀí¹¤¾ßµÄʹÓã¬ÕÆÎÕʹÓùÜÀí¹¤¾ß²é¿´Êý¾Ý¿âÐÅÏ¢µÄ·½·¨¡£ 3. ÕÆÎÕ°ïÖúÎĵµµÄʹÓÃ
ʵÑéÒªÇó
1. ʹÓöàÖÖ·½·¨Æô¶¯¡¢ÔÝÍ£ºÍÍ£Ö¹SQL Server·þÎñ¡£ 2. ʹÓùÜÀí¹¤¾ß²é¿´µ±Ç°Êý¾Ý¿âÐÅÏ¢¡£
ʵÑéÄÚÈÝ
1. Æô¶¯¡¢ÔÝÍ£ºÍÍ£Ö¹SQL Server·þÎñ¡£ 2. ²é¿´°ïÖúÎĵµ
ʵÑé²½ÖèÓë½á¹û
ʵÑé²½Öè
£¨1£©ÒÀ´Î¡±¼ÆËã»ú¡±¡ª¡ª¡°¹ÜÀí¡±¡ª¡ª¡°·þÎñºÍÓ¦Óýø³Ì¡±¡ª¡ª¡°·þÎñ¡±£¬´ò¿ª·þÎñÏî £¨2£©ÕÒµ½Ò»ÏîÃûΪ¡°SQL Server (MSSQLSERVER)¡±µÄ·þÎñ£¬²é¿´ÆäÃèÊöºÍ״̬¡£
£¨3£©Í£Ö¹¸Ã·þÎñ¡£ £¨4£©Æô¶¯¸Ã·þÎñ¡£ £¨5£©ÔÝÍ£¸Ã·þÎñ¡£ £¨6£©»Ö¸´¸Ã·þÎñ¡£
£¨7£©ÔÚSQL ServerÅäÖùÜÀíÆ÷Öг¢ÊÔÖظ´ÉÏÊö²Ù×÷¡£
£¨8£©ÔÚSQL ServerÅäÖùÜÀíÆ÷Öл¹¿ÉÒԲ鿴µ½SQL Server·þÎñÕ¼ÓõĶ˿ںͱ¾»úIPµØÖ·¡£µã»÷×ó²à¡°MSSQLSERVERµÄÐÒ顱ѡÔñ¡°TCP/IP¡±,È»ºóÑ¡ÔñIPµØÖ·Ñ¡Ï¡£¿ÉÒÔ¿´µ½¶Ë¿ÚºÅ¡£
£¨9£©Ê¹ÓÃÃüÁîNET¹ÜÀíMSSQLSERVER·þÎñ¡£Í£Ö¹·þÎñ¡£ÃüÁNET STOP MSSQLSERVER £¨10£©Æô¶¯·þÎñ¡£ÃüÁNET START MSSQLSERVER £¨11£©ÔÝÍ£·þÎñ¡£ÃüÁNET PAUSE MSSQLSERVER
£¨12£©ÖØпªÆô·þÎñ¡£ÃüÁNET CONTINUE MSSQLSERVER £¨9£©~£¨12£©½ØͼÈçÏ£º
ÇëÄãÁ·Ï°
1. ÉÏÍø²éÕÒÔÚosqlÃüÁîµÄ×÷ÓúÍʹÓ÷½·¨£¬²¢Ê¹ÓøÃÃüÁîµÇ¼SQL Server²é¿´°æ±¾¡£
OSQL ¡ª£¿ÃüÁî¿É²é¿´osqlÃüÁîµÄÓ÷¨
*ͨ¹ýÃüÁî¿ÉÖª¸ÃÊý¾Ý¿â°æ±¾ÎªSQL 2012 11.0 NT x64 ÉÏͼÁоÙÁËOSQLµÄһЩ³£ÓÃÃüÁî¡£
·ÖÎöÓëÌÖÂÛ:
SQL serverµÄÓ¦Óýø³ÌÎÒ·þÎñ»áÓжà¸ö£¬ÓÈÆäÊÇ·þÎñ£¬Í£Ö¹»òÔÝÍ£ÁËijЩӦÓýø³ÌºÍ·þÎñ£¬¶¼¿ÉÄÜÊÇÊý¾Ý¿âÎÞ·¨Õý³£µÄʹÓÃ,ËùÒÔ²»ÒªÍ£Ö¹Ïà¹Ø½ø³ÌºÍ·þÎñ¡£
ʵÑéÈý ´´½¨Êý¾Ý¿â
ʵÑéÄ¿µÄ
1. ÕÆÎÕÔÚͼÐνçÃæÏ´´½¨Êý¾Ý¿âµÄ·½·¨¡£ 2. ÕÆÎÕʹÓÃSQLÓï¾ä´´½¨Êý¾Ý¿âµÄ·½·¨¡£
3. ÊìϤSQL Server Management StudioµÄ»·¾³¡£
ʵÑéÒªÇó
1. ÊìÁ·Ê¹ÓÃÁ½ÖÖ·½·¨´´½¨Êý¾Ý¿â¡£
ʵÑéÄÚÈÝ
´´½¨Êý¾Ý¿â¡£
ʵÑé²½ÖèºÍ½á¹û£º
£¨Â·¾¶Ñ¡Ôñ±¾»úϵͳĬÈϵÄ·¾¶£©
£¨1£©Ã÷È·ÐèÇó¡£
£¨2£©Ê¹ÓÃÏòµ¼´´½¨ÉÏËßÃèÊöµÄÊý¾Ý¿â¡£
£¨3£©µ¥»÷¡°Á¬½Ó¡±°´Å¥£¬±ã¿ÉÒÔ½øÈ롾SQL Server Management Studio¡¿´°¿Ú¡£
£¨4£©ÔÚ¡°Êý¾Ý¿â¡±½ÚµãÉÏÓÒ»÷£¬µ¯³öÈçÏÂͼËùʾµÄ¿ì½Ý²Ëµ¥£¬Ñ¡Ôñ¡°Ð½¨Êý¾Ý¿â¡±ÃüÁî¡£ £¨5£©ÔÚ¡°³£¹æ¡±Êý¾ÝÒ³µÄ¡°Êý¾Ý¿âÃû³Æ¡±Îı¾¿òÖУ¬ÊäÈëÒª´´½¨µÄÊý¾Ý¿âÃû³ÆºÍÆäËûÊôÐÔ