_SQL SERVER数据库_黑客防线网安服务器维护基地--Powered by WWW.RONGSEN.COM.CN

作者:黑客防线网安SQL教程网 来源:黑客防线网安SQL教程网 浏览次数:0

本篇关键词:SQL数据库

突然发现某数据库的日志已经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)

第一个参数是日志文件名,第二个参数是目标文件大�訫为单位

第一个参数名可以用以下方法确定:

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收缩日志

    希望这篇的文章能够对您有所帮助,如果您觉得这篇网站维护教程有用的话,别忘了推荐给您的朋友哦!如果您有好的经验方法,不妨拿出来和大家一起分享:假如每个人都拿出一个经验,那么我们都将额外的获取一堆他人的经验。
请记住本站永久域名:(黑客防线网安服务器维护方案维护基地)Www.Rongsen.Com.Cn
    黑客防线网安服务器维护方案本篇连接:http://code.rongsen.com.cn/show-19125-1.html
网站维护教程更新时间:2012-11-05 01:12:09  【打印此页】  【关闭
0
顶一下
0
踩一下
我要申请本站N点 | 黑客防线官网 |  
专业服务器维护及网站维护手工安全搭建环境,网站安全加固服务。黑客防线网安服务器维护基地招商进行中!QQ:29769479

footer  footer  footer  footer