Home Forums SQL Server 7,2000 Backups transaction log to large!!! (can't shrink file) RE: transaction log to large!!! (can't shrink file)
Levi Justus
SSCommitted
Points: 1923
More actions
May 26, 2003 at 3:17 am
#458480
Hi..
Please truncate the transaction log before shrinking the Logfile..check the below command to do it.
dump tran Database_Name with no_log
Now use the dbcc shrikfile command.
levi
Jesus My Saviour