Home Forums SQL Server 2005 Backups Can't shrink transaction log on sql server 2005 Standard edition, 64 bit RE: Can't shrink transaction log on sql server 2005 Standard edition, 64 bit
Sreekanth B
SSCertifiable
Points: 6145
More actions
July 10, 2014 at 8:37 am
#1728416
np...So after changing it back to FULL, have you shceduled T-Log backups?
Make sure you have got regular T-Log Backups scheduled for any database which is in "FULL" recovery model. If not, the same issue(gigantic log file) will re-occur.