,
ugg
| Back to logs list
326378 2010 年 12 月 09 日 14:30 Reading (loading. ..) Comments (0) Category: SQL database
the actual size of the database is 600MB, the actual size of the log file for the 33MB, but the log file space is 2.8GB! try a variety of ways, SHIRNK DATABASE, TRUNCATE LOG FILE, no way to shrink the file. In any case, this should be considered a BUG it SQL Server.
Expert Answer: Locate the following code, you can shrink the log file to your desired size. COPY the code in the Query Analyzer, and then modify one of the three parameters (database name, log file name,
ugg ムートンブーツ, and target the size of the log file), run it.
SET NOCOUNT ON
DECLARE @ LogicalFileName sysname,
@ MaxMinutes INT,
@ NewSize INT
USE Marias
- to operate the database name
SELECT @ LogicalFileName = 'Marias_log'
- log file name
@ MaxMinutes = 10,
- Limit on time allowed to wrap log.
@ NewSize = 100
- you want to set the log file size (M)
- Setup / initialize
DECLARE @ OriginalSize int
SELECT @ OriginalSize = size
FROM sysfiles
WHERE name = @ LogicalFileName
SELECT 'Original Size of '+ db_name () +' LOG is' +
CONVERT (VARCHAR (30), @ OriginalSize) + '8K pages or' +
CONVERT (VARCHAR (30), (@ OriginalSize * 8 / 1024)) + 'MB'
FROM sysfiles
WHERE name = @ LogicalFileName
CREATE TABLE DummyTrans
(DummyColumn char (8000) not null)
DECLARE @ Counter INT,
UGG オーストラリア,
@ StartTime DATETIME,
UGG AUSTRALLIA,
@ TruncLog VARCHAR (255)
SELECT @ StartTime = GETDATE (),
@ TruncLog = 'BACKUP LOG'
+ db_name () + 'WITH TRUNCATE_ONLY'
DBCC SHRINKFILE (@ LogicalFileName ,
ugg ブーツ, @ NewSize)
EXEC (@ TruncLog)
- Wrap the log if necessary.
WHILE @ MaxMinutes> DATEDIFF
(mi, @ StartTime, GETDATE ()) - time has not expired
AND @ OriginalSize = (SELECT size
FROM sysfiles WHERE name = @ LogicalFileName)
AND (@ OriginalSize * 8 / 1024)> @ NewSize
BEGIN - Outer loop.
SELECT @ Counter = 0
WHILE ((@ Counter <@ OriginalSize / 16)
AND (@ Counter <50000))
BEGIN - update
INSERT DummyTrans VALUES ('Fill Log' )
DELETE DummyTrans
SELECT @ Counter = @ Counter + 1
END
EXEC (@ TruncLog)
END
SELECT 'Final Size of' + db_name () + 'LOG is '+
CONVERT (VARCHAR (30),
UGG ブーツ 格安, size) +' 8K pages or '+
CONVERT (VARCHAR (30), (size * 8 / 1024)) +' MB '
FROM sysfiles
WHERE name = @ LogicalFileName
DROP TABLE DummyTrans
SET NOCOUNT OFF