Home Forums SQL Server 7,2000 Backups Cannot shrink log file 2 (LOG FILE) because all logical log files are in use. RE: Cannot shrink log file 2 (LOG FILE) because all logical log files are in use.

  • February 27, 2007 at 12:26 am

    #691975

    What is the recovery model you have ?

    1. Backup the transaction log.

    2. Shrink it.

    3 Create a maintenanace plan to do the backup regularly.

     

    Minaz Amin

     

    "More Green More Oxygen !! Plant a tree today"