The common T-SQL script to shrink/truncate log file is using the script below USE [foo] GO DBCC SHRINKFILE(foo_log, 1) But, if the script runs on SQL Server 2008 instance, it will fail. You still have the same log file size, nothing change (shrink) . In other word you cannot shrink the log file. To solve… Continue reading
Posts tagged "truncate"
Shrink the log file on mssql server 2000
sql server 2000 one of most powerful and easy to use database application. It’s nicely handle giga size data. Unfortunately the growth of the log file can be very frustrating. Sometimes there’s a certain difficulty when we want to shrink the log file, mainly because the database still running a process. usually we can use… Continue reading