Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
akalehzan
Starting Member
21 Posts |
Posted - 2008-04-28 : 13:24:17
|
Dear All,On SQL server 2000I’m trying to shrink the log files using the following scripts:use repository_serverselect name from repository_server.dbo.sysfiles DBCC OPENTRAN BACKUP LOG repository_server WITH TRUNCATE_ONLYDBCC SHRINKFILE(repository_Log , 10) Let’s say The log file’s “repository_Log “ size before shrink is 150000 mb. But the log file’s size does not change after issuing the above script.Thanks for any help.By the way I tried the Gui Enterprise manager shrink database files. That didn’t make any changes as wellThanks for any help.Abrahim |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 13:25:09
|
You've got active data at the end of the transaction log still.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|