• Thanks Sir.

    I take full database and Transaction log backup once a day at night time when there is almost no transaction in database. Can i shrink log file to 50% once a week and make it to minimum and handle this way. Currently Log file is 60 GB and free space in log file drive is 82 GB. Could you please suggest me accordingly with out any negative impact in database especially with out occurring any performance issues.

    Also could you please suggest me right time to shrink log file. Can i do it after Full backup and Log backup.