Hi Craig, Once you've truncated the log(e.g. backup og db_name with truncate_only), make sure to release the space by shrinking the log file. Unless you are interested in growing old watching SQL shrink the DB file as well, make sure you shrink ONLY the log file.
Best regards, Christoph --- In Axapta-Knowledge-Village@yahoogroups.com, "David Casas" <[EMAIL PROTECTED]> wrote: > > Hi, > > Posibly you have a transaction in the end of the transaction log file, for this reason the full backup with transactional not reduce the used space. > > Do the following: > > backup log namebbdd with no_log > > With this, all the transactions finished was deleted (you have in the backup file), and put the others at the beginning of the file. > > Regards. > > David > > > From: Craig Fidler > Sent: Tuesday, August 26, 2008 12:45 PM > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [Axapta-Knowledge-Village] SQL transaction Log backup file > > > > Hi All, > > > > Using Ax4.0 SP 2 the sql transaction log backup file has grown to 103gig. > > > > I have tried doing a full backup with a log file truncate but it does not reduce in size. > > > > How do I reduce the SQL transaction Log backup file size? > > > > > > Thanks >
