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)
 How to reduce log file size

Author  Topic 

eaglet_zhang
Starting Member

1 Post

Posted - 2000-12-21 : 22:49:42
Hi !
I want to reduce database log file size ,so run "dbcc shrinkfilie(...)" script to reduce the log file size . but the size doesn't change. I have setted "truncated log at checkpoint " db option is true
before do it. I want to know why?
Thanks a lot!

thanks
   

- Advertisement -