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

  • Thanks very much, Sreekanth.

    I was told by the SAs that they were doing Arcserve backups on the DB, but after you replied, I checked further, and found they were only doing full backups, so the log has been growing for a very long time.

    I set the DB to simple, cleared the log, set it to full, and did a full backup, and now everything is ok.