SQL Server 2008 (Windows 2008 R2ϵͳ) ÇåÀíÈÕÖ¾·½·¨_SQL SERVERÊý¾Ý¿â_ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤»ùµØ--Powered by WWW.RONGSEN.COM.CN

SQL Server 2008 (Windows 2008 R2ϵͳ) ÇåÀíÈÕÖ¾·½·¨

×÷ÕߣººÚ¿Í·ÀÏßÍø°²SQL½Ì³ÌÍø À´Ô´£ººÚ¿Í·ÀÏßÍø°²SQL½Ì³ÌÍø ä¯ÀÀ´ÎÊý£º0

±¾Æª¹Ø¼ü´Ê£ºSQLÊý¾Ý¿â
ºÚ¿Í·ÀÏßÍø°²ÍøѶ£ºÍ»È»·¢ÏÖijÊý¾Ý¿âµÄÈÕÖ¾ÒѾ­1.5GÁË£¬È»¶øÔ­À´Ê¹ÓõĽضÏÈÕÖ¾µÄÓï¾äÔÚ2008ÖÐÒѾ­Ê§Ð§£¬ÔÚÍøÉÏËÑÑ°ÁËһЩ·½·¨£¬ÑéÖ¤ÏÂÃæ·½·¨ÊÇÓÐЧµÄ£ºÊ×Ïȼì²éÄ¿±êÊý¾Ý¿âµÄ»Ö¸´Ä£Ê½£º

ͻȻ·¢ÏÖijÊý¾Ý¿âµÄÈÕÖ¾ÒѾ­1.5GÁË£¬È»¶øÔ­À´Ê¹ÓõĽضÏÈÕÖ¾µÄÓï¾äÔÚ2008ÖÐÒѾ­Ê§Ð§£¬ÔÚÍøÉÏËÑÑ°ÁËһЩ·½·¨£¬ÑéÖ¤ÏÂÃæ·½·¨ÊÇÓÐЧµÄ£ºÊ×Ïȼì²éÄ¿±êÊý¾Ý¿âµÄ»Ö¸´Ä£Ê½£º

SELECT NAME, recovery_model_desc FROM sys.databases

Èç¹ûÊÇFull£¬ÔòÐèÒª¸ÄΪSimple:

ALTER DATABASE Test SET Recovery simple

 

\
 

 

È»ºóÊÕËõÈÕÖ¾Îļþ£º

DBCC SHRINKFILE (N'test_log' , 10)

µÚÒ»¸ö²ÎÊýÊÇÈÕÖ¾ÎļþÃû£¬µÚ¶þ¸ö²ÎÊýÊÇÄ¿±êÎļþ´óС£¬ÒÔMΪµ¥Î»¡£

µÚÒ»¸ö²ÎÊýÃû¿ÉÒÔÓÃÒÔÏ·½·¨È·¶¨£º

USE DreamFree2010
SELECT NAME, size FROM sys.database_files

Èç´Ë¼´¿É£¬ÈÕÖ¾ÎļþÒѾ­ÊÕËõµ½Ä¿±êµÄ10M¡£

 

\asprT9ah2q9XWHB5ba8FuT77H4PNfDyKxYE0AALqiZTC5ZuthBWhrJg2fChQXPH6jbu43So6rpVkN3wKjSxIIAGWFA1eVlQLgGtmzWtzL8WdPmfutxD9/9dB6gFAZKDBVWTnQWtp93qytYNmtZU13e7dfcyzmUcYVjZOi7jhMJrWCwIoAEWVM3E9hfUUMIU4vUw9vE4AcgfLKiavPoLFka6HTR6tREIYEEADbCgaugvCMHgOAHQAAuqhv6CEAyOEwANsKBq6C8IweA4AdAAC6qG/oIQDI4TAA2woGroLwjBiHacHKukdcvx/1+tt9W0QZBbB8CCqqG/IAQj5nEyEoy2aarjy7eF80AJLKia7PoLQn/Bgsn/BDCRYEHV5NVfEHpNZAtWJyFHy9aVtV1qupLnV00LCuOYwzreevK/HeQMFlRNXv0FodekrQVd3pmz7mXd0jqCvJfGrQOUWFºÚ¿Í·ÀÏßufQXfJn0PGUGFhQ2EzZu/eSL4412s6BQhgIMwYKqyevbtKHX9NGCrfqJUwsCCGBB1WBBCEbCKyXkN/zMH2sLreWgPE4t7rfedM8BqmBB1XhYcDAzC9BE2c+r5uViDiAHBlhQM34WvPS3twBMMrRgU4kmbJn8ZAdgBQuqxqO/IBaEJjK0IMDEgAVV49FfEAtCE1gQQA8sqBqP/oJYEJrAggB6YEHVePQXxILQBBYE0AMLqsajv2AECxZH47VXchNMM1gQQA8sqBqP/oJxLFj712tHSAUWBNADC6rGo79gtBnRDkrDgko4PrBYEEAPLKgaj/6CCS1Ym/M0Z01H5eNoZYeZVbD+LVweQCwIoAcWVI1Hf8FUFqypztzgkm0SFfmF+lu4iBALAuiBBVXj0V8weS1oloPyyZpCMMjfwkWE0SyYunMGIbGDBbXj0V8wn1pQ+JWwDXT7W1ALAqQFC6rGo79gHAsKVV3Te37msrkNjPPnaN0MCwLogQVVw7dpg4Tja4iqBZN3twCYJIbPLNAjLwsWRpJrAFwYHLVg8vsDMBmMnlnJ69EJJi8LQk/BggAaDHivAQtCL8CCABpgwdgWpL8gdAMLAmiABaNakP6C0BksCKABFoxtQfoLQjfiW9B6tYzjjq3DJn88AYZgwdgWbO0vCNBETAsWtq/KC2UvLAj5MMCCMS3Y2l+QvwHIJLGgvDLU4ABh6XAlboQzcHWKZZxTwfgjxMSjvyAWBJloFrxkm7qsXWNqnSyt7WW9MtX8QiKA4GT7rUwje8kaa5VcLy3Y2l8QC4JMTAuOTiXmcpPzzF2a9jI3AwiL48ssLBgBj/6C9AogQpJY8JL4jeouE6dN7sSCoIp1HsIkEwvWZjits6bjbCPcVlQLtvYXpBYEmUw+HTO+BYXdAYLQo1qwyYu+e8kDtv5KD4/+glgQZGJasHYSqf5YHI1w6pH3cjlJAXTD8ejKwYKlrbCzCqy6jfs41g3SWLC1vyAWBJkkM6IAfcTxBVYOFtSrBYXdY+LRXxALgkySWpCKDSaYTK6UsK6XyziXcYRh09SCQrAguEAtCBAWrpqPABaEYGBBgLAkrAUjF2QJwYIQDCwIEBZqwQhgQQgGFgQICxaMgEd/wUy+xa5pºÚ¿Í·ÀÏßfifUoK/FRgQYCwYMEIePQX7Nf390B8RhYEgFCUWFAZj/6CWHAK8Xqcea4CaMAzSxWP/oLRLNh0lUltjbyBOZSwjbkLlhUetCZ4rgJowDNLlez6Cwpv+NV0Je/ospe5DfIzH1V3EfJcBdBgwHsNmmTXXzC4BeVtzLM8hWDrQ9REhOMkdecMQmKn5HNnyp8/yq6/YGQLut+N6YRaECºÚ¿Í·ÀÏßWDCeBRP2FxwiXAVRe3vP+p5fU6nXYRssaD7yrWBBAA2wYCQL0l8QTLxeDXCcAGiABSNZMM/+goWR5EckNIEFATTAgpEsSH9BGBOOEwANolmwVnJU15vbJBdYeAvSXxDGhOMEQIOYteBIb7LnJtOCQji7gQscJwAaxLdgq+SwIGc3sMBxAqBBZAua06Gm86xrrBOnmfsSC0JI4l9R4/VpKZftzctmkj+qAMlrwVYLmvOomcsPC4IKSb5dwVeESiMD6JHkfUFfCzoWkblRt2Dy/oLQa7AggAa9sKDXgPlwxIKZ9BeE/hLZguaMZdOamtjk2dSmjZEipCL+lRLCyuJoXDZLrjoPC+bQXxD6S9pa0H1B9pnLOAAx4ar5eBbMob8g9JfkM6LWyq+2V2tVhwUhN1JdNZ95GRfegpn0F4T+km0tKOzVbWSAmFALRrJgJv0Fob8kv1LCXF/90VyWxzeHra4xd2ldA9ANLBjJgjn0F6wV48kPPvBiUl8tcShCWrBgPAsm7y9YBp194uQVmVSvllT/0Lwmg+RgwUgWzKS/4GjCavxDhzNXZCa1FgRICxaMZMFM+gsK7/fIm7m8l8PrelWwIIAGIwuCBtn1FzRrQXOO1GWhNGpB5KcNFgTQYDAzm/w+TDD/BYtJ2GJHCVjqAAAAAElFTkSuQmCC" />

 

 

\

 

×ܽáһϣº

  1. ¸ÄRecovery modeΪSimple
  2. ÓÃDBCC SHRINKFILEÊÕËõÈÕÖ¾
    ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤·½°¸±¾ÆªÁ¬½Ó£ºhttp://www.rongsen.com.cn/show-19125-1.html
Íøվά»¤½Ì³Ì¸üÐÂʱ¼ä:2012-11-05 01:12:09  ¡¾´òÓ¡´ËÒ³¡¿  ¡¾¹Ø±Õ¡¿
ÎÒÒªÉêÇë±¾Õ¾£ºNµã | ºÚ¿Í·ÀÏß¹ÙÍø |  
רҵ·þÎñÆ÷ά»¤¼°Íøվά»¤ÊÖ¹¤°²È«´î½¨»·¾³£¬ÍøÕ¾°²È«¼Ó¹Ì·þÎñ¡£ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤»ùµØÕÐÉ̽øÐÐÖУ¡QQ:29769479

footer  footer  footer  footer