Home Forums SQL Server 2005 Administering shrinking logfile in SQL 2008 RE: shrinking logfile in SQL 2008
terryj30
SSCommitted
Points: 1896
More actions
February 9, 2009 at 1:33 am
#940293
make sure there are no open transactions before shrinking the log, also insted of using 1000 try ,0 this will take it down to what ever space is free not just to zero bytes.
dbcc opentran (database)
go
and so on.
Terry