How to reduce SQL Server log files (1/2)

How to reduce SQL Server log files
You can shrink the log file to the size you want. Copy the code to the Query Analyzer, and then modify the 3 parameters (database tutorial name, log file name, and target log file size) and run it (I've used it many times)

-----

　

Set NOCOUNT on

Declare @logicalfilename sysname,

@maxminutes int,

@new Size int

Use Marias-the database name to manipulate

Select @logicalfilename = ' Marias_log ',--log file name

@maxminu TES =--limit on time allowed to wrap log.

@newsize = 100-the size of the log file you want to set (m)

--Setup/initialize

Declare @originalsize int

Select @originalsize = Size

From Sysfiles

WHERE name = @logicalfilename

Select ' Original size of ' + db_name () + ' log is ' +

Convert (varchar, @originalsize) + ' 8k pages or ' +

Convert (varchar (@originalsize *8/1024)) + ' MB '

From Sysfiles

WHERE name = @logicalfilename

CREATE TABLE Dummytrans

(Dummycolumn char (8000) NOT NULL)

Declare @counter int,

@starttime datetime,

@trunclog varchar (255)

Home 1 2 last page