Post reply

Shrink transaction log file

  • October 7, 2005 at 2:20 am

    #110423

    Hi

        I 've set the file properties of both data files and transaction log file to "Automatically grow file" and maximun file size to "unrestricted file growth". The data file is OK but the transaction log file bigger and bigger and i can't shrink anymore.When i changed to "restrict file growth" option and give some amount, it shows the alert "The transaction log file is full ..."  or something like that when i worked on the database. 

    How can i shrink for that transaction log file,please? Is there better solution to solve that problem? Please advice me.

    Thanks.

  • October 7, 2005 at 3:25 am

    #595797

    If you don't save the transaction log file, change the database recovery option to simple (not full), if you want to solve force, detach your database, delete the log file and then attach again your database, check the recovery option, if the recovery mode "full" change to "simple".

  • October 7, 2005 at 3:35 am

    #595798

    Hi,

    Have you tried to backup the transaction log file.

    If you have did that it will reduce the size and you can shrink the trnsaction log file.

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply