Solved

Way to Reduce Size of Exchange 2003 Transaction Logs While Preserving Incremental Backup Ability?

Posted on 2006-07-07
11
418 Views
Last Modified: 2010-03-06
We've got limited space on our exchange server. Although the db is only about 16gb, and we've got 55 gb, believe it or not the daily transaction logs build up to almost fill the drive to capacity each day. If our backup fails for some reason, the store dismounts because the disk is full.

Is there a way to reduce the volume of transaction logs without compromising our ability to do incremental backups or any other big issues?

Cheers,

Jay
0
Comment
Question by:jbreg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
11 Comments
 
LVL 96

Expert Comment

by:Lee W, MVP
ID: 17056639
This may not be the best answer, but.... why don't you just get more disk space?
0
 
LVL 104

Expert Comment

by:Sembee
ID: 17056781
Are you doing full backups every day?
If not, then you should. I don't do incremental backups of Exchange unless really tight on backup space. With a store of 16gb you shouldn't have any difficulties doing a full backup every day.

You can't compress transaction logs, as that will kill the performance of the server.

Simon.
0
 
LVL 8

Expert Comment

by:bilbus
ID: 17064112
cant you put the logs and the store on a seperate HDs?
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:jbreg
ID: 17065863
We do backups (incrementally) each day but the backups truncate the transaction logs. This is because we back up to a remote location over the Net (making full backups difficult because of bandwidth considerations).

Can't put logs and store on separate HDD as there is no other drive on the machine with nearly enough capacity.

I suppose we could add another few disks to the machine and store the logs there, but I'd rather not do that if there is some other way. The transaction logs are building up 30+ gb per day prior to the backup.
0
 
LVL 96

Accepted Solution

by:
Lee W, MVP earned 250 total points
ID: 17065914
I think your backup plan is not sufficient.  And the server lacks capacity.  You may be able to work around things, but your BEST option is to manage the server in a manner that makes sense.  Add capacity and change your backup plan.  You need to do full backups that truncate the transaction logs - if the remote backups won't cut it, then you need a different backup solution.  Probably an external hard disk or two cycled so you can take one off site.
0
 

Author Comment

by:jbreg
ID: 17065924
The backups we do do truncate the transaction logs, I just was interested as to why they grow from 0 to 30gb each day (they are truncated each night) and whether anything can be done about it.
0
 
LVL 104

Expert Comment

by:Sembee
ID: 17066537
A daily 30gb of transaction logs is an awful lot of email. If your database isn't growing by that much, then a lot of email is not being retained by the store.

Have you run perfmon or use message tracking to see what sort of message numbers are going through the server?

Simon.
0
 

Author Comment

by:jbreg
ID: 17067474
Not really--can you suggest exactly how?
0
 
LVL 104

Assisted Solution

by:Sembee
Sembee earned 250 total points
ID: 17068494
First thing I would do is run the Exchange Best Practises tool on the machine.

http://www.microsoft.com/technet/prodtechnol/exchange/downloads/2003/analyzers/default.mspx

Message tracking needs to be turned on.
http://www.amset.info/exchange/message-tracking.asp

For perfmon, click Start, Run and type perfmon.
Change the type of display to Report by pressing CTRL and R

Then you need to add counters to the system. You can delete the ones that already there as they aren't relevant to this problem.

The counters are since the server or services were last restarted.

I would probably start with SMTP Server performance objects.

Inbound Connections Total
Messages Delivered Total
Messages Received Total
Messages Sent Total
Total Messages Submitted

Then move on to MSEXCHANGEIS Mailbox

Messages Submitted
Messages Sent
Messages Delivered

Repeat with the same counters for MSEXCHANGEIS Public

That will give you some idea of the message flow.

I can't tell you what is high or low numbers because every site is different.
However if you have 10 users and you have processed 250,000 messages since the server was last rebooted (which, if you are keeping it up to date will be at most 25 days ago) that would mean that your users are sending 1000 messages a day or 41 messages an hour - 24 hours a day, seven days a week.

You can get Perfmon to tell you how long the server has been up - (System, System Up time) but it shows it in seconds.

Simon.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question