SQL Server Version--SQL 数据库版本号 日志清理教程
SQL Server VersionArticle Body
SQL Server 2012
11.0.2316SQL Server 2012 CU112 Apr 2012
11.0.2100.6SQL Server 2012 RTM7 Mar 2012
SQL Server 2008 R2
10.50.2789.0SQL Server 2008 R2 SP1 CU317 Oct 2011
10.50.2772.0SQL Server 2008 R2 SP1 CU216 Aug 2011
10.50.2769.0SQL Server 2008 R2 SP1 CU116 Sep 2011
10.50.2500.0SQL Server 2008 R2 SP111 Jul 2011
10.50.1807.0SQL Server 2008 R2 CU1019 Oct 2011
10.50.1804.0SQL Server 2008 R2 CU923 Aug 2011
10.50.1797.0SQL Server 2008 R2 CU816 Sep 2011
10.50.1777.0SQL Server 2008 R2 CU716 Jun 2011
10.50.1765.0SQL Server 2008 R2 CU621 Feb 2011
10.50.1753.0SQL Server 2008 R2 CU520 Dec 2010
10.50.1746.0SQL Server 2008 R2 CU418 Oct 2010
10.50.1734.0SQL Server 2008 R2 CU317 Aug 2010
10.50.1720.0SQL Server 2008 R2 CU225 Jun 2010
10.50.1702.0SQL Server 2008 R2 CU118 May 2010
10.50.1600.1SQL Server 2008 R2 RTM12 Apr 2010
SQL Server 2008
10.00.5768SQL Server 2008 SP3 CU222 Nov 2011
10.00.5766SQL Server 2008 SP3 CU118 Oct 2011
10.00.5500SQL Server 2008 SP36 Oct 2011
10.00.4323SQL Server 2008 SP2 CU721 Nov 2011
10.00.4321SQL Server 2008 SP2 CU620 Sep 2011
10.00.4316SQL Server 2008 SP2 CU518 Jul 2011
10.00.4285SQL Server 2008 SP2 CU416 May 2011
10.00.4279SQL Server 2008 SP2 CU321 Mar 2011
10.00.4272SQL Server 2008 SP2 CU217 Jan 2011
10.00.4266SQL Server 2008 SP2 CU115 Nov 2010
10.00.4000SQL Server 2008 SP229 Sep 2010
10.00.2850SQL Server 2008 SP1 CU1619 Sep 2011
10.00.2847SQL Server 2008 SP1 CU1518 Jul 2011
10.00.2816SQL Server 2008 SP1 CU1322 Mar 2011
10.00.2812SQL Server 2008 SP1 CU1416 May 2011
10.00.2808SQL Server 2008 SP1 CU1217 Jan 2011
10.00.2804SQL Server 2008 SP1 CU1115 Nov 2010
10.00.2799SQL Server 2008 SP1 CU1021 Sep 2010
10.00.2789SQL Server 2008 SP1 CU919 Jul 2010
10.00.2775SQL Server 2008 SP1 CU817 May 2010
10.00.2766SQL Server 2008 SP1 CU715 Mar 2010
10.00.2757SQL Server 2008 SP1 CU618 Jan 2010
10.00.2746SQL Server 2008 SP1 CU524 Nov 2009
10.00.2734SQL Server 2008 SP1 CU422 Sep 2009
10.00.2723SQL Server 2008 SP1 CU321 Jul 2009
10.00.2714SQL Server 2008 SP1 CU218 May 2009
10.00.2710SQL Server 2008 SP1 CU116 Apr 2009
10.00.2531SQL Server 2008 SP17 Apr 2009
10.00.1835SQL Server 2008 RTM CU1015 Mar 2010
10.00.1828SQL Server 2008 RTM CU918 Jan 2009
10.00.1823SQL Server 2008 RTM CU816 Nov 2009
10.00.1818SQL Server 2008 RTM CU721 Sep 2009
10.00.1812SQL Server 2008 RTM CU621 Jul 2009
10.00.1806SQL Server 2008 RTM CU518 May 2009
10.00.1798SQL Server 2008 RTM CU417 Mar 2009
10.00.1787SQL Server 2008 RTM CU319 Jan 2009
10.00.1779SQL Server 2008 RTM CU217 Nov 2008
10.00.1763SQL Server 2008 RTM CU122 Sep 2008
10.00.1600SQL Server 2008 RTM6 Aug 2008
SQL Server 2005
9.00.5266SQL Server 2005 SP4 CU321 Mar 2011
9.00.5259SQL Server 2005 SP4 CU222 Feb 2011
9.00.5254SQL Server 2005 SP4 CU120 Dec 2010
9.00.5000SQL Server 2005 SP417 Dec 2010
9.00.4325SQL Server 2005 SP3 CU1521 Mar 2011
9.00.4317SQL Server 2005 SP3 CU1421 Feb 2011
9.00.4315SQL Server 2005 SP3 CU1320 Dec 2010
9.00.4311SQL Server 2005 SP3 CU1218 Oct 2010
9.00.4309SQL Server 2005 SP3 CU1117 Aug 2010
9.00.4305SQL Server 2005 SP3 CU1023 Jun 2010
9.00.4294SQL Server 2005 SP3 CU919 Apr 2010
9.00.4285SQL Server 2005 SP3 CU816 Feb 2010
9.00.4273SQL Server 2005 SP3 CU721 Dec 2009
9.00.4266SQL Server 2005 SP3 CU619 Oct 2009
9.00.4230SQL Server 2005 SP3 CU517 Aug 2009
9.00.4226SQL Server 2005 SP3 CU416 Jun 2009
9.00.4220SQL Server 2005 SP3 CU321 Apr 2009
9.00.4211SQL Server 2005 SP3 CU217 Feb 2009
9.00.4207SQL Server 2005 SP3 CU120 Dec 2008
9.00.4053SQL Server 2005 SP3 GDR (Security Update)13 Oct 2009
9.00.4035SQL Server 2005 SP316 Dec 2008
9.00.3356SQL Server 2005 SP2 CU1721 Dec 2009
9.00.3355SQL Server 2005 SP2 CU1619 Oct 2009
9.00.3330SQL Server 2005 SP2 CU1518 Aug 2009
9.00.3328SQL Server 2005 SP2 CU1416 Jun 2009
9.00.3325SQL Server 2005 SP2 CU1321 Apr 2009
9.00.3315SQL Server 2005 SP2 CU1217 Feb 2009
9.00.3310SQL Server 2005 SP2 Security Update10 Feb 2009
9.00.3301SQL Server 2005 SP2 CU1115 Dec 2008
9.00.3294SQL Server 2005 SP2 CU1020 Oct 2008
9.00.3282SQL Server 2005 SP2 CU918 Aug 2008
9.00.3257SQL Server 2005 SP2 CU816 Jun 2008
9.00.3239SQL Server 2005 SP2 CU714 Apr 2008
9.00.3233SQL Server 2005 QFE Security Hotfix8 Jul 2008
9.00.3228SQL Server 2005 SP2 CU618 Feb 2008
9.00.3215SQL Server 2005 SP2 CU517 Dec 2007
9.00.3200SQL Server 2005 SP2 CU415 Oct 2007
9.00.3186SQL Server 2005 SP2 CU320 Aug 2007
9.00.3175SQL Server 2005 SP2 CU228 Jun 2007
9.00.3161SQL Server 2005 SP2 CU115 Apr 2007
9.00.3152SQL Server 2005 SP2 Cumulative Hotfix7 Mar 2007
9.00.3077SQL Server 2005 Security Update10 Feb 2009
9.00.3054SQL Server 2005 KB9344585 Apr 2007
9.00.3042.01SQL Server 2005 "SP2a"5 Mar 2007
9.00.3042SQL Server 2005 SP21 Feb 2007
9.00.2047SQL Server 2005 SP1
9.00.1399SQL Server 2005 RTM1 Nov 2005
SQL Server 2000
8.00.2039SQL Server 2000 SP4
8.00.0760SQL Server 2000 SP3
8.00.0534SQL Server 2000 SP2
8.00.0384SQL Server 2000 SP1
8.00.0194SQL Server 2000 RTM
SQL Server 7
7.00.1063SQL Server 7 SP4
7.00.0961SQL Server 7 SP315 Dec 2000
7.00.0842SQL Server 7 SP220 Mar 2000
7.00.0699SQL Server 7 SP115 Jul 1999
7.00.0623SQL Server 7 RTM
SQL Server 6.5
6.50.416SQL Server 6.5 SP5a
6.50.415SQL Server 6.5 SP5
6.50.281SQL Server 6.5 SP4
6.50.258SQL Server 6.5 SP3
6.50.240SQL Server 6.5 SP2
6.50.213SQL Server 6.5 SP1
6.50.201SQL Server 6.5 RTM
SqlServer2012清除日志文件
右键数据库-->任务-->收缩-->文件进入收缩文件页面，按照如下配置就可以了
有时候收缩并不成功，这是因为 数据库还没有设置为简单模式，操作如下：右击数据库名->点'属性'->点'选项'->恢复模式改成'简单'->点'确定'按钮,
之后再重复上面的操作，即可完成。
页:
[1]