ͻȻ·¢ÏÖ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" />
×ܽáһϣº
- ¸ÄRecovery modeΪSimple
- ÓÃDBCC SHRINKFILEÊÕËõÈÕÖ¾