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 Development (2000)  problem about truncate transaction log.

Author  Topic  vb_bv Starting Member 24 Posts Posted - 2002-03-12 : 03:24:02 hi, all, I just had a question about truncate log file from sql server 7, I saw many articles talks about how to truncate the transaction log. Suppose we need to execute "DBCC SHRINKDATABASE or DBCC SHRINKFILE " command, but I tried to use the User Interface mehtod, from the enterprice manager: first select the database, "Shrink" the database, then select "truncate log" , then I found the transcation log seems becomes smaller, does it ok if I do it that way, since after I saw these articles, I am scare I did something wrong... many thanks all your helps! Best Regards