Home Forums SQL Server 7,2000 Backups transaction log to large!!! (can't shrink file) RE: transaction log to large!!! (can't shrink file)

  • 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