Link to home
Start Free TrialLog in
Avatar of Safeserve
SafeserveFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL 2000 Transaction Log and "DBCC SHRINKFILE"

Hi,

I've got a problem with an SQL Server in that the transaction log has grown too large and filled the disk.

As such, I performed a backup of the transaction logs, and then tried to use the DBCC SHRINKFILE T-SQL command to shrink the file.

However, when I run the command it immidiately returns "The command(s) completed successfully" and nothing happens to the file.

I tried to run it using SQL Server Management Studio 2005 from another machine in the domain, and the graphical interface here confirms that the log file is 97% free space, but again when I run it it says "Executing" for a few seconds, and completes without error, again without changing the size of the log file.

There is nothing in the EventLog that suggests an error either.

This is the T-SQL command I ran (though I have tried several other permutations): -
DBCC SHRINKFILE (N'MyDB_LOG.LDF', 0, TRUNCATEONLY)

What am I doing wrong???

Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of Cedric_D
Cedric_D

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Safeserve

ASKER

Hi, thanks for the help.

No luck with CHECKPOINT either, but once I changed it to simple it shrank correctly.