Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1941
  • Last Modified:

Exchange 2010 EDB files growing exponenetially

I have 5 databases on my exchange 2010 DAG cluster 2 servers in the cluster running w2k8 Ent.
The 5 database are each at least 80 GB that is the edb file not even including log files. :(

I am running out of space. I have been using windows backup tool on w2k8 server to backup my server but it does not truncate the logs. Not sure if that is part of the reason the edb file is growing so big.

Anyways need help with reducing the size of the edb and then eventually having the logs to truncate after backup.
The formeri is more important at this time.


0
cchibonga
Asked:
cchibonga
  • 6
  • 5
  • 3
1 Solution
 
Alan HardistyCo-OwnerCommented:
You may have a user who has a POP3 account that is pulling mail from an Exchange mailbox and then delivering the messages to the Exchange mailbox, causing a loop.

Are you using POP3 on your server?
0
 
Alan HardistyCo-OwnerCommented:
Please have a read of the following article for details of how to backups your Exchange server properly and purge the Exchange log files:

http://www.experts-exchange.com/Software/Server_Software/Email_Servers/Exchange/A_2452-Backing-up-Exchange-2010-Information-Store-using-Windows-Backup.html
0
 
lucid8Commented:
You definitely want to resolve your backup issues first as Alan pointed out, however once thats done if you are still seeing a large amount of growth then look at the following;

There was an issue where iPhones caused runaway transactions logs and I believe it was resolved with IOS 4.0.1. http://msexchangeteam.com/archive/2010/06/30/455342.aspx

If you have users with iPhones or Smart Phones using ActiveSync then one of the quickest ways to see if this is the issue is to have users shot those phones off to see if the problem is resolved.  If it is one or more iPhones then perhaps look at what IOS they are on and get them to update to the latest version or adjust the activesynce connection timeout.  Although I personally would want to know where it came from first.

If its not the above then perhaps this will help you track down the cause http://blogs.msdn.com/b/scottos/archive/2007/07/12/rough-and-tough-guide-to-identifying-patterns-in-ese-transaction-log-files.aspx?PageIndex=2#comments 

You should also check out ExMon since you can use it to confirm which mailbox is unusually active , and then take the appropriate action.
 http://www.microsoft.com/downloads/en/details.aspx?FamilyId=9A49C22E-E0C7-4B7C-ACEF-729D48AF7BC9&displaylang=en  
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
cchibongaAuthor Commented:
@ AlanHardisty
I have tried that backup method & im still getting the error saying " backup failed and was unable to remove or delete logs" something to that effect

We are not using a POP3 server. The only thing close to that is we have yahoo contacts that we forward emails to.

@ Lucid8
We have always had Iphones pulling email from exchange 2003 b4 upgrading to exchange 2010. so i don't see why that would start happening now. I'll try to follow the links you gave me.
0
 
lucid8Commented:
Regarding your backups;

1. What product are you using to backup the databases?

2. If its not the MS WBAdmin I would suggest you stop the services of whatever product you are using and change over to the WBAdmin until you get that working

3. Before you start lets check to see if your VSS writers are having an issue so
3.a Open Powershell
3.b Run "VSSadmin List Writers"
3.c examine the results and see if there are any errors, if so then you need to resolve those issues first.

4. If your VSS writers are all ok then here is a decent overview of how to use WBadmin and I would suggest that you get this working before working with a 3rd party backup product.
http://www.msexchange.org/articles_tutorials/exchange-server-2010/high-availability-recovery/uncovering-new-exchange-2010-volume-snapshot-vss-plug-in-part1.html

Please note if you place database file and logs in two different disks, you should select both to backup, otherwise the logs will not be truncated.

More information on troubleshooting VSS issues which occur with Windows Server Backup (WBADMIN) on Windows Server 2008 and Server 2008 R2 http://technet.microsoft.com/en-us/library/ee692290(WS.10).aspx
0
 
lucid8Commented:
Regarding the iPhones issue, just because it was running fine in 2003 doesn't mean it will not cause a problem in 2010.  Biggest thing is to ensure your iPhones users are using the latest IOS.  Could of course be something different and if so the other links I sent you should be helpful
0
 
cchibongaAuthor Commented:
@Lucid
i run the "VSSadmin List Writers" it was free of any errors so that part is good.
I have been using wb admin to backup the databases. been following the same steps outlined in the artilcle but no success. I have a w2k8 enterprise 64bit OS with Ex2010 enterprise not sure if that is what is different.
But my logs re not getting truncated.
0
 
Alan HardistyCo-OwnerCommented:
Are there any errors in the Application Event log around the time of the backup that might show a problem somewhere?
0
 
lucid8Commented:
1. How much space are the Logs currently taking up?
2. When was the last time you had a good backup?
3. Were you ever using another Backup Product?
4. As Alan asked, whats happening in the application logs during the time of the backup?
5. What is the specific error you are getting from the backup when it fails?
0
 
cchibongaAuthor Commented:
1)at least 40 GB for each database
2) like 3 dayas ago
3) I have been using windows server backup, until 2 weeks ago when i started using DPM but is is finding some of the databases in inconsistent state
4) it shows backups go through fine
5)when i backup the whole disk with the databases it goes through fine. bus as soon as i try to backup the information store ore just the mailbox folder it errors saying the "the backup failed and could delete or remove some of the logs"
0
 
cchibongaAuthor Commented:
What can i do to reduce the size of my databases? i have a DAG cluster so maybe if i can defrag the databases on one of the servers then once that is done switch databases to the other and then defrag the other.
can you please provide me with a step by step instructions on this issue?

thanks!
0
 
lucid8Commented:
I think the main issue here is to get your logs under control since they are taking up a large amount of space and I see no reason to do a defrag at this time since as you say you have 40GB of LOGS per database, correct?

DPM
When you say you are trying to backup the information store or mailbox folder are you doing this as a file level backup?  Sounds like thats what you are doing since to backup exchange you would backup the Information Store but you would not point to the location of the physical files.

WBADMIN
1. when you used WBAdmin did you have it setup to truncate the logs?
2. If yes to # 1 I assume it was working properly?
3. If Yes to # 2 then I would suggest that the first thing you do is use WBAdmin to backup and truncate the logs to get them under control and then we come back to DPM
0
 
cchibongaAuthor Commented:
fixed the issue by deleting the stray logs that from each server and making sure that both servers are consistent. have the same logs basically.
0
 
cchibongaAuthor Commented:
none of the other solutions fixed it
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 6
  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now