How to manual delete the transaction logs
It is known to all that we can make the fully backup to clean up the transaction logs of exchange 2007. Besides that, how could I manually delete the transactions logs.
January 11th, 2011 10:50pm

Manually deleting transaction logs are not supported in any way. There are two ways to get rid of transaction logs: 1) perform a full backup (or incremental) to flush the logs or 2) enable circular logging on the database. If you pick #2, it will have recovery implications as you will only be able to restore up to the point of your last good backup.Tim Harrington | MVP: Exchange | MCITP: EMA 2007/2010, MCITP: Server 2008, MCTS: OCS | Blog: http://HowDoUC.blogspot.com | Twitter: @twharrington
Free Windows Admin Tool Kit Click here and download it now
January 11th, 2011 11:13pm

Tim, But at this moment, I will need to delete the transaction logs manually. Is there any way?
January 12th, 2011 1:42am

Manually removing transaction log files that are not required To correctly remove excess transaction log files, follow these steps: Stop all the databases in the storage group. Verify the state of each database file in the particular storage group. Perform one of the following actions: If one or more of the databases are in a Dirty Shutdown or Inconsistent state, determine which transaction log files can be removed without affecting database consistency. If all the databases are in a Clean Shutdown or Consistent state, you may remove all the transaction log files except for the current transaction log file. Removing the current log file when all databases are in a Clean Shutdown state will cause a reset of the log file sequence. This does not prevent databases from starting. However, a reset of the log file sequence affects the ability to roll a database forward from a previous backup if the situation occurs. Copy all the transaction log files that you want to remove to a different location before you permanently remove them from the transaction log hard disk. Notes: Do not permanently delete the transaction log files until you have successfully completed a full online backup of all the databases in the storage group. For more detail information ,you can access http://support.microsoft.com/kb/240145
Free Windows Admin Tool Kit Click here and download it now
January 12th, 2011 3:26am

Tim, But at this moment, I will need to delete the transaction logs manually. Is there any way? Enable circular logging on the databases. This will truncate the logs correctly. If you eventually want to get logs to where they don't automatically truncate (for DR reasons) then you can disable circular logging at any time.Tim Harrington | MVP: Exchange | MCITP: EMA 2007/2010, MCITP: Server 2008, MCTS: OCS | Blog: http://HowDoUC.blogspot.com | Twitter: @twharrington
January 12th, 2011 8:50am

You can enable online maintenance on the database.
Free Windows Admin Tool Kit Click here and download it now
January 12th, 2011 10:19am

You can enable online maintenance on the database.
January 12th, 2011 10:20am

On Wed, 12 Jan 2011 08:20:44 +0000, Jianlong Xiong wrote: >Manually removing transaction log files that are not requiredTo correctly remove excess transaction log files, follow these steps: 1. Stop all the databases in the storage group. 2. Verify the state of each database file in the particular storage group. Perform one of the following actions: If one or more of the databases are in a Dirty Shutdown or Inconsistent state, determine which transaction log files can be removed without affecting database consistency. If all the databases are in a Clean Shutdown or Consistent state, you may remove all the transaction log files except for the current transaction log file. Removing the current log file when all databases are in a Clean Shutdown state will cause a reset of the log file sequence. This does not prevent databases from starting. However, a reset of the log file sequence affects the ability to roll a database forward from a previous backup if the situation occurs. 3. Copy all the transaction log files that you want to remove to a >different location before you permanently remove them from the transaction log hard disk. > >Notes: Do not permanently delete the transaction log files until you have successfully completed a full online backup of all the databases in the storage group. > >For more detail information ,you can access http://support.microsoft.com/kb/240145 The important part in this is that you'll be creating a ne log file generation and it immediately invalidates your previous backups. So, if you do this be sure to make a full/normal Exchange-aware backup immediately. Yes, now -- don't wait. --- Rich Matheisen MCSE+I, Exchange MVP --- Rich Matheisen MCSE+I, Exchange MVP
Free Windows Admin Tool Kit Click here and download it now
January 12th, 2011 10:01pm

On Wed, 12 Jan 2011 13:44:49 +0000, TWHarrington wrote: >But at this moment, I will need to delete the transaction logs manually. Is there any way? Enable circular logging on the databases. This will truncate the logs correctly. If you eventually want to get logs to where they don't automatically truncate (for DR reasons) then you can disable circular logging at any time. Yup. That's the safe way to do this. --- Rich Matheisen MCSE+I, Exchange MVP --- Rich Matheisen MCSE+I, Exchange MVP
January 12th, 2011 10:01pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics