收缩日志脚本

--------------设定当前处理数据库----------------51Testing软件测试网^
Q@3YjZd
use [qcsiteadmin_db]
?!~5Nb;K5X0go
n!g `6D4U[\`,\7E0-----------------------------------------------

--建立临时表temp0123456789
7a0X'Vaoc Q7O5z7q0--注意如果该表存在会被删除！！！！！！！！！！！！！！
z2BD'Wn&B.L(z+f0if exists (select * from sysobjects where id = object_id(N'[dbo].[temp0123456789]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)51Testing软件测试网ZPnl4d_v/P

FD [Gw"nM0drop table [dbo].[temp0123456789]

@3T"m%RI V!t3O!R6K]c0GO51Testing软件测试网nzE2|9g
-----------------------------------------------

~:X5aZ3E F2o4q0
J cd}*rNT O0dbcc shrinkfile (2)51Testing软件测试网3F:u4NR"u1|

create table temp0123456789 (char1 char(4000))51Testing软件测试网&B,F+V^I+}w&{7X

go51Testing软件测试网iZ-c8I*|*H r$w:X.@ @

declare @i int

C)aOHD
N_0declare @j int51Testing软件测试网},`
V&NA8M

9A@
G-rc0--------------------------------
1tu5y$t8jq0DECLARE @DoTimes       int          --收缩次数，建议为10次
0cEi8sW0set @DoTimes=1051Testing软件测试网a1_&c[:GE k(R
--------------------------------

3x9@@|ov0set @j=051Testing软件测试网iyf8oy5h

t4DfY-V&DO0
3g5I*I(KA'{:p$nK0while (@j < 500)51Testing软件测试网F]KL.o6Qg

?l(TPHd?0begin

a:^$O](T6m8cq\0 select @i = 0 

 while (@i < @DoTimes)51Testing软件测试网6if*G{`)e$j

 begin51Testing软件测试网i0qI;P*S

quD;_7a{:w0   insert into temp0123456789 values ('a')

[!X/bk!Tju0   select @i = @i +1

-h
v;w-U(gpO9Yjl0 end51Testing软件测试网qz`nHff_S

{$mCc1eto0 truncate table temp012345678951Testing软件测试网+}b,l]+x,{4xT J

H1QrL0mR1S0 backup log [qcsiteadmin_db] with truncate_only51Testing软件测试网wr K~fbx

 set @j=@j+151Testing软件测试网6AnEy)f Z8{s$q'r

0oiy^#|x*fQ
I3d0 select @j51Testing软件测试网H@[9wW!G,V0wG

'H,v}:c*Q^]"H+q l0end

qE*b\/P6t0dbcc shrinkfile (2)

go

Cf|In`S#E#fh5G0--------------清除临时表---------------
3K @ E1x9h7e't3B0if exists (select * from sysobjects where id = object_id(N'[dbo].[temp0123456789]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

_)e'ByK N0drop table [dbo].[temp0123456789]51Testing软件测试网v+G@P|!R[W.s M

+N'x8w*N C Wk,i0GO51Testing软件测试网M
la5HJ*yA1B%@&h7D'V
--------------------------------------51Testing软件测试网c{ |-h7oh)uY