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