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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Shrink the log files

Author  Topic 

akalehzan
Starting Member

21 Posts

Posted - 2008-04-28 : 13:24:17
Dear All,

On SQL server 2000
I’m trying to shrink the log files using the following scripts:


use repository_server

select name from repository_server.dbo.sysfiles
DBCC OPENTRAN

BACKUP LOG repository_server WITH TRUNCATE_ONLY
DBCC 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 well


Thanks 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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -