你是用向导做还是代码呢?
给你一段代码试试
(转发)给你一段CODE.在SQL ANALYZER中运行,可以立即收缩日志.
run below script,you will shrink you database log files immediately,
in my experience,you need to run the script for 3 or 4 minutes before
stopping it manually
good luck!!!/* Run "select * from sysfiles to get fileid you want to shrink"*/
use northwind
go
dbcc shrinkfile(2,notruncate)
dbcc shrinkfile(2,truncateonly)
create table t1(char1 char(4000))
go
declare @i int
select @i=0
while(1=1)
begin
while(@i<100)
begin
INSERT INTO T1 VALUES ('A')
SELECT @I=@I+1
END
TRUNCATE table T1
BACKUP LOG northwind with truncate_only
end
go你也可以设置SQL SERVER自动收缩,
sp_dboption 'database','autoshrink','true'
sp_dboption 'database','trunc. log on chkpt.','true'
给你一段代码试试
(转发)给你一段CODE.在SQL ANALYZER中运行,可以立即收缩日志.
run below script,you will shrink you database log files immediately,
in my experience,you need to run the script for 3 or 4 minutes before
stopping it manually
good luck!!!/* Run "select * from sysfiles to get fileid you want to shrink"*/
use northwind
go
dbcc shrinkfile(2,notruncate)
dbcc shrinkfile(2,truncateonly)
create table t1(char1 char(4000))
go
declare @i int
select @i=0
while(1=1)
begin
while(@i<100)
begin
INSERT INTO T1 VALUES ('A')
SELECT @I=@I+1
END
TRUNCATE table T1
BACKUP LOG northwind with truncate_only
end
go你也可以设置SQL SERVER自动收缩,
sp_dboption 'database','autoshrink','true'
sp_dboption 'database','trunc. log on chkpt.','true'
@SQLSTR VARCHAR(300)
SELECT @DATABASENAME = 'sheep'IF ISNULL(@DATABASENAME, '') = '' OR NOT EXISTS(SELECT name FROM master.dbo.sysdatabases WHERE name = @DATABASENAME)
SELECT @DATABASENAME = DB_NAME()
--PRINT @DATABASENAMESELECT @SQLSTR = 'BACKUP LOG ' + @DATABASENAME + ' WITH NO_LOG ' + CHAR(10) +
'DBCC SHRINKDATABASE(' + @DATABASENAME + ', TRUNCATEONLY)' + CHAR(10) +
'USE ' + @DATABASENAME + CHAR(10) +
'DECLARE @LOGNAME VARCHAR(30)' + CHAR(10) +
'SELECT @LOGNAME = RTRIM(name) FROM dbo.sysfiles WHERE (status & 0x40) <> 0' + CHAR(10) +
'EXEC(''DBCC SHRINKFILE('' + @LOGNAME + '', TRUNCATEONLY)'')'
--PRINT @SQLSTR
EXEC(@SQLSTR)
GO
dbcc shrinkfile(logfilename, TRUNCATEONLY)
先备份日志,然后再收缩日志文件.