ͼ 2.17
£¨2£©´Ë½çÃæÖи÷ÏîÑ¡Ïî˵Ã÷ÈçÏÂ
¢Ù ¿ªÊ¼Ê±¼ä£ºÉèÖÃÐè²éѯÀúÊ·Êý¾ÝµÄ¿ªÊ¼Ê±¼ä¡£ ¢Ú ½áÊøÊ±¼ä£ºÉèÖÃÐè²éѯµÄÀúÊ·Êý¾ÝµÄ½áÊøÊ±¼ä¡£ ¢Û ´òÓ¡£º¿É¶Ô²éѯ³öµÄÊý¾Ý½øÐб¨±í´òÓ¡¡£ ¢Ü ÇúÏßͼ£ºÏÔʾÀúÊ·Êý¾ÝÇúÏß¡£
¢Ý Öµ±í£ºÏÔʾËùÓвéѯµÄÀúÊ·Êý¾Ýʱ¼ä¼°¶ÔÓ¦µÄÖµ¡£
£¨3£©×¢ÒâÊÂÏî
¢Ù ÀúÊ·Êý¾Ý¿É²éѯµÄʱ¼ä¶ÎÊÜϵͳ²ÎÊýÖÐÉèÖõÄÀúÊ·Êý¾Ý±£´æÌìÊýµÄÏÞÖÆ£¬²»ÔÚÀúÊ·Êý¾Ý±£´æ·¶Î§ÄÚµÄÀúÊ·Êý¾Ý½«ÎÞ·¨²éѯ¡£
¢Ú ÇëÏÈÉèÖÃÐè²éѯµÄʱ¼ä¶ÎºóÔÙÑ¡ÔñÐè²éѯµÄ¼à²âÁ¿¡£ ¢Û ±¨±í¿É½øÐÐÍøÂç´òÓ¡£¬µ«ÐèÉèÖúÃÍøÂç´òÓ¡»ú¡£
2.2.2±¨¾¯Êý¾Ý²éѯ
£¨1£©²Ù×÷²½Öè
ÔÚ¿Í»§¶Ëϵͳ²Ëµ¥ÏÂÑ¡Ôñ¡°ÏµÍ³²éѯ¡±¡ª¡ª¡°±¨¾¯²éѯ¡±£¬¼´¿É½øÈëµ½±¨¾¯²éѯ½çÃæÈçÏ£º
2¡¢
ͼ 2.18 £¨2£© ´Ë½çÃæÖи÷ÏÄÜÈçÏÂ
¢Ù ¿ªÊ¼Ê±¼ä£ºÉèÖÃÐè²éѯÀúÊ·Êý¾ÝµÄ¿ªÊ¼Ê±¼ä¡£ ¢Ú ½áÊøÊ±¼ä£ºÉèÖÃÐè²éѯµÄÀúÊ·Êý¾ÝµÄ½áÊøÊ±¼ä¡£ ¢Û ´òÓ¡£º¿É¶Ô²éѯ³öµÄÊý¾Ý½øÐб¨±í´òÓ¡¡£ £¨3£©×¢ÒâÊÂÏî
¢Ù ±¨¾¯Êý¾Ý¿É²éѯµÄʱ¼ä¶ÎÊÜϵͳ²ÎÊýÖÐÉèÖõı¨¾¯Êý¾Ý±£´æÌìÊýµÄÏÞÖÆ£¬²»ÔÚ±¨¾¯Êý¾Ý±£´æ·¶Î§Äڵı¨¾¯Êý¾Ý½«ÎÞ·¨²éѯ¡£
¢Ú ÇëÏÈÉèÖÃÐè²éѯµÄʱ¼ä¶ÎºóÔÙÑ¡ÔñÐè²éѯµÄ¼à²âÁ¿¡£ ¢Û ±¨±í¿É½øÐÐÍøÂç´òÓ¡£¬µ«ÐèÉèÖúÃÍøÂç´òÓ¡»ú¡£
¢Ü µ±Ñ¡Ôñ×ó±ßÊ÷ÐÎÁбí×îÉϼ¶Ê±£¬Ôò»áµ÷³öËùÓб¨¾¯Êý¾ÝÐÅÏ¢¡£
2.2.3Óû§²Ù×÷¼Ç¼²é¿´
£¨1£©²Ù×÷²½Öè
ÔÚ¿Í»§¶Ëϵͳ²Ëµ¥ÏÂÑ¡Ôñ¡°ÏµÍ³²éѯ¡±¡ª¡ª¡°²Ù×÷¼Ç¼¡±£¬¼´¿É½øÈëµ½²Ù×÷¼Ç¼½çÃæÈçÏ£º
ͼ 2.19
£¨2£©´Ë½çÃæÖи÷ÏÄÜÈçÏÂ
¢Ù ¿ªÊ¼Ê±¼ä£ºÉèÖÃÐè²éѯÀúÊ·Êý¾ÝµÄ¿ªÊ¼Ê±¼ä¡£ ¢Ú ½áÊøÊ±¼ä£ºÉèÖÃÐè²éѯµÄÀúÊ·Êý¾ÝµÄ½áÊøÊ±¼ä¡£ ¢Û ´òÓ¡£º¿É¶Ô²éѯ³öµÄÊý¾Ý½øÐб¨±í´òÓ¡¡£
¢Ü ²éѯ£ºµã»÷´Ë°´Å¥¿É²éѯÉ趨ʱ¼ä¶ÎÄÚµÄËùÓвÙ×÷¼Ç¼¡£ £¨3£©×¢ÒâÊÂÏî
¢Ù ²Ù×÷¼Ç¼¿É²éѯµÄʱ¼ä¶ÎÊÜϵͳ²ÎÊýÖÐÉèÖõIJÙ×÷¼Ç¼±£´æÌìÊýµÄÏÞÖÆ£¬²»ÔÚ²Ù×÷¼Ç¼±£´æ·¶Î§ÄÚµÄÀúÊ·Êý¾Ý½«ÎÞ·¨²éѯ¡£ ¢Ú ±¨±í¿É½øÐÐÍøÂç´òÓ¡£¬µ«ÐèÉèÖúÃÍøÂç´òÓ¡»ú¡£
Èý ³£¼ûÎÊÌâ¼°½â¾ö°ì·¨
1¡¢Æô¶¯¿Í»§¶Ë²»ÄÜÁ¬½Ó£¬ÏµÍ³ÓÐÈçÏ´íÎó¿ò£¿
ͼ 3.1 ¡ï ½â¾ö·½·¨:
ϵͳµÇ¼ʱÉèÖÃÕýÈ·µÄÊý¾Ý¿âIP£¬ÈçÔ¶³Ì¿Í»§¶Ë³öÏÖ´ËÎÊÌâÇëͬʱ¼ì²éÓëÊý¾Ý¿âÖ÷»úµÄÍøÂçͨѶÊÇ·ñÕý³£¡£¼ì²éÊÇ·ñÓзÀ»ðǽϵͳÆÁ±ÎÁËSQL SERVERÁ¬½ÓµÄ1433¶Ë¿Ú¡£
2¡¢Êý¾Ý¿âÎÞ·¨±¸·Ý»òÌáʾ¡°ÈÕÖ¾ÎļþÒÑÂú´íÎó¡±£¿ ¡ï ½â¾ö·½·¨£º
£¨1£©´ò¿ªSQL 2000²éѯ·ÖÎöÆ÷£¬ÊäÈëÒÔÏÂÃüÁî²¢ÑéÖ¤ÔËÐУ¬ use myserver
backup log myserver with no_log backup log myserver with truncate_only dbcc shrinkdatabase(myserver)
£¨2£©Ò²¿ÉÔÚSQL 2000ÖÐÌí¼ÓÊý¾Ý¿âά»¤¼Æ»®£¬¶ÔÈÕÖ¾¼°±¸·Ý½øÐж¨Ê±¹ÜÀí¡£
3¡¢±¨¾¯Ê±Î´²¦´ò±¨¾¯µç»°£¿ ¡ï ½â¾ö°ì·¨£º
(1) ¼ì²éµç»°ÓïÒô¿¨¼°Çý¶¯ÊÇ·ñÕýÈ·°²×°¡£ (2) ¼ì²éµç»°ÏßÊÇ·ñ°²×°ÕýÈ·¡£ (3) ¼ì²éµç»°ºÅÂëÊÇ·ñÉèÖÃÕýÈ·¡£
(4) ¼ì²é·þÎñ¶ËĿ¼ÏÂÊÇ·ñÕýÈ·µÄ±¨¾¯ÓïÒôÎļþ¡££¨ÓïÒôÎļþÃüÃû¸ù¾ÝÉ豸ID¶øÀ´¡£ÀýÈç±äÁ¿ID U101 µÄÉÏÏÞ±¨¾¯ÎļþΪ U1012.PCM£»ÏÂÏÞ±¨¾¯ÎļþΪ U1013.PCM¡££©
4¡¢ ±¨¾¯Ê±Ã»ÓжàýÌåÓïÒô£¿ ¡ï ½â¾ö°ì·¨£º
(1) ¼ì²é¶àýÌåÒôÏäÊÇ·ñ°²×°ÕýÈ·¡£
(2) ¼ì²é¿Í»§¶Ë°²×°Ä¿Â¼ÏÂÊÇ·ñ´æÔÚÕýÈ·µÄ¶àýÌåÓïÒôÎļþ¡££¨ÓïÒôÎļþÃüÃû¸ù¾ÝÉ豸ID¶øÀ´¡£ÀýÈç±äÁ¿ID U101 µÄÉÏÏÞ±¨¾¯ÎļþΪ U1012.wav£»ÏÂÏÞ±¨¾¯ÎļþΪ U1013.wav¡££© (3) ¼ì²éÉù¿¨¼°Çý¶¯ÊÇ·ñ°²×°ÕýÈ·¡£ (4) ¼ì²éÊÇ·ñÉù¿¨»òÒôÏ仵¡£
Ïà¹ØÍÆ¼ö£º