°²×°SQL Server 2000ʱÈýÖÖ³£¼û³ö´íÐÅÏ¢¼°½â¾ö·½·¨
Çé¿ö£ºÎÒÒÔǰ°²×°¹ýSQL Server 2000£¬Å¶£¬»¹ÓÐSQL Server 2005¡¢MySQLÄØ£¬ºóÀ´ÏµÍ³ÖØ×°ÁË£¬²»¹ýÕâЩӦÓóÌÐò¶¼ÔÚEÅÌÀ²»ÔÚϵͳÅÌÀ¾ÍÔÚ°²×°µÄʱºò³öÏÖÈçÏÂÈý¸ö´íÎó£¬ÔÚ´ËÖð¸ö½â¾ö˵Ã÷ÈçÏ£º
ÎÊÌâÒ»£º
±¨´íÐÅÏ¢£ºÒÔǰµÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú¡£
½â¾ö·½°¸£ºÔËÐÐregedit´ò¿ª×¢²á±í£¬ÕÒµ½ÈçϵÄÏHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session ManagerÖÐÕÒµ½PendingFileRenameOperationsÏîÄ¿£¬¼Çס£¬ÊÇÓÃÊó±êµã»÷Session ManagerÏȻºóÓұ߾ͿÉÒÔ¿´µ½ÓÐÒ»¸öPendingFileRenameOperationsÏîÁË£¬È»ºóÓÒ»÷Êó±êɾ³ýËü¡£
ÎÊÌâ¶þ£º
±¨´íÐÅÏ¢£ºCommand line opeion syntax error, Type Command /? for Help.
½â¾ö·½°¸£º¾²éMicrosoftµÄ°ïÖúÎĵµ£¬ÖªµÀÕâÊÇÒòΪSQL Server 2000µÄ°²×°Ä¿Â¼ÊÇÔÚÒ»¸öÓÐ×ÅÖÐÎÄÃûµÄÎļþĿ¼Ï£¬ËùÒÔ»á³öÏÖÕâÖÖÃüÁî²»ÕýÈ·µÄÌáʾ£¬½â¾ö·½·¨¾ÍÊǰÑÕâ¸öÎļþÖØÃüÃû³ÉÒ»¸ö´¿Ó¢ÎĵÄÃû×Ö£¬²»Òª´øÖÐÎÄ¡£
ÎÊÌâÈý£º
±¨´íÐÅÏ¢£º°²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍC:\WINDOWS\sqlstp.logÁ˽â¸ü¶àÐÅÏ¢¡£
½â¾ö·½°¸£º¼ÈÈ»ÌáʾÎÒÁ˽âC:\WINDOWS\sqlstp.logÀïµÄÐÅÏ¢£¬ÄÇÎÒ¾ÍÈ¥Á˽âÁË£¬Ò»¿´£¬ÄÇlogÎļþµÄ×îºóÊÇÓйØsaµÇ¼³ö´íµÄÐÅÏ¢£¬ºÇºÇ£¬ÎÒ°²×°µÄʱºòÊÇÓÃÁËsaµÄµÇ¼Ãû£¬ÃÜÂëÒ²ÊÇsa¹À¼Æ²»ÐÐÁË£¬ºÃ£¬°²×°µÄʱºòµÇ¼·½Ê½£¬¸Ä³ÉWindowϵǼ¾ÍOKÁË¡£
°¦£¬°²×°Èý´Î²Å³É¹¦£¬É¹É¹ÕâЩСʰɣ¬²»ÖªµÀÄܲ»ÄܰïÆäËûÈËͬÑùµÄ´íÎó¡£
Ïà¹ØÎĵµ£º
×î¼Ñ´ð°¸·½·¨1£º
ÔÚ²éѯ·ÖÎöÒÇÀïÃæÔËÐÐÏÂÃæ´úÂ룺
backup log dbname with NO_LOG
backup log dbname with TRUNCATE_ONLY
DBCC SHRINKDATABASE(dbname)
·½·¨2£º
½øÈëÆóÒµ¹ÜÀíÆ÷£¬Ñ¡ÖÐÊý¾Ý¿â
ËùÓÐÈÎÎñ->·ÖÀëÊý¾Ý¿â
µ½Êý¾Ý¿âÎļþµÄ´æ·ÅĿ¼£¬½«dbname_log.LDFÎļþɾ³ý£¬ÅÂSµÄ»° ......
ǰЩÌì°²×°ÁËSQL Server2005£¬³öÁË2¸ö´íÎó£¬×îÖÕÔÚÍøÉÏÕÒµ½Á˽â¾ö°ì·¨£¬ÏÖÕûÀíһϡ£
´íÎóÒ»£º
½â¾ö·½·¨£º
ÓÃaspnet_regiisʵÓù¤¾ßÐ¶ÔØºÍÖØÐ°²×°Ò»Ï¾ͿÉÒÔÁË¡£
¾ßÌåµÄ²Ù×÷ÈçÏ£º
½øÈëCMD£º
ÊäÈë cd c:\windows\microsoft.net\framework\v2.0.50727£¬½øÈë´ËÎļþ¼ÐĿ¼Ï£¬ÔËÐÐaspnet_regiis -uÐ¶ÔØ
È»ºóÔËÐÐas ......
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö× ......
SET TIMING ON | OFF
SQL> set timing on
SQL> select * from emp where empno = 7369;
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- ----------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK ......
²éѯÓÅ»¯µÄÄ¿µÄÊÇÌá¸ßÊý¾Ý¼ìË÷ËÙ¶È£¬Ìá¸ßÊý¾Ý¼ìË÷Òâζ׿õÉÙ´ÅÅÌ
IO
¶ÁÈ¡»òÕßÂß¼ÄÚ´æ¶ÁÈ¡´ÎÊý£¬ÕâÐèÒª´ÓÁ½¸ö·½ÃæÈëÊÖ£ºÊý¾ÝÒª¾¡¿ÉÄܵĻº´æµ½ÄÚ´æ¡¢¾¡¿ÉÄܵÄʹÓÃË÷Òý¡£ÄÚ´æµÄÎÊÌâ¿ÉÒԲμû
:
http://msdn.microsoft.com/zh-cn/library/ms188284.aspx
£¬±¾ÎÄÖ÷ÒªÊÇÌåÏÖÈçºÎʹÓÃË÷ÒýÀ´Ìá¸ßËÙ¶È¡£¾ßÌå·½·¨£º
1) ......