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.
Solved
exchange 2013 database size increases everyday
Posted on 2014-12-19
Hi Experts
I am not a Exchange guy and having a very less knowledge regarding exchange servers.
We have exchange 2013 installed on server 2012. The actual mailbox size i get by running powershell command is around 54GB but the size of mailbox folder itself is around 217GB. Please see below the output of powershell command.
[PS] C:\Windows\system32>Get-Ma
bject Name | fl
Name : Mailbox Database 0303672096
DatabaseSize : 54.13 GB (58,124,730,368 bytes)
AvailableNewMailboxSpace : 62.69 MB (65,732,608 bytes)
Questions:
- Why there is discrepancy of size between Database actual size and folder size.
- what is the solution to overcome this problem
Really need help on this as this server is on VMware and we do not have more space to allocate to this exchange server.
Thanks in advance
Saqib
I am not a Exchange guy and having a very less knowledge regarding exchange servers.
We have exchange 2013 installed on server 2012. The actual mailbox size i get by running powershell command is around 54GB but the size of mailbox folder itself is around 217GB. Please see below the output of powershell command.
[PS] C:\Windows\system32>Get-Ma
bject Name | fl
Name : Mailbox Database 0303672096
DatabaseSize : 54.13 GB (58,124,730,368 bytes)
AvailableNewMailboxSpace : 62.69 MB (65,732,608 bytes)
Questions:
- Why there is discrepancy of size between Database actual size and folder size.
- what is the solution to overcome this problem
Really need help on this as this server is on VMware and we do not have more space to allocate to this exchange server.
Thanks in advance
Saqib
[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
4-
3
2- +1
10 Comments
Active 5 days ago
Have you looked in the folder itself?
By default, both the database and transaction logs are stored in the same location. The logs are only flushed when you do an Exchange aware backup of the server. Are you doing a backup of the server using an Exchange aware backup application?
DO NOT DELETE THE LOGS manually. That will cause you more problems. Verify that is what is happening.
If you do have an Exchange aware backup then ensure that it is set to full backup and to flush the logs (not unheard of for people to set it to copy instead).
Simon.
By default, both the database and transaction logs are stored in the same location. The logs are only flushed when you do an Exchange aware backup of the server. Are you doing a backup of the server using an Exchange aware backup application?
DO NOT DELETE THE LOGS manually. That will cause you more problems. Verify that is what is happening.
If you do have an Exchange aware backup then ensure that it is set to full backup and to flush the logs (not unheard of for people to set it to copy instead).
Simon.
No i am not taking any backups right now. and yes i checked the folder itself under default path i.e. "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox".
We did a migration from 2003 exchange to exchange 2013. May be that would add up some size.
What if i create a new mailbox database and move all mailboxes to new database ? and delete the older database once mailboxes are moved to newer one. Will that be a solution ?
Thanks
We did a migration from 2003 exchange to exchange 2013. May be that would add up some size.
What if i create a new mailbox database and move all mailboxes to new database ? and delete the older database once mailboxes are moved to newer one. Will that be a solution ?
Thanks
Active 2 days ago
As suggested by Simon, you must take backup with exchange aware backup application, that's the correct way to flush the logs for that specific database.
When you migrated exchange 2003 mailboxes to 2013 the move itself generates log files. Every action thats you do in exhange or exchange does results in creation of log file. If you move mailbox from old DB to new that will also create logs.
Bottom line., run full backup.
When you migrated exchange 2003 mailboxes to 2013 the move itself generates log files. Every action thats you do in exhange or exchange does results in creation of log file. If you move mailbox from old DB to new that will also create logs.
Bottom line., run full backup.
Active 5 days ago
Creating a new database is not going to help.
If you aren't going to do a backup, then enable circular logging on the databases. You will need to dismount and then mount the database for the change to take effect. That will stop the logs from being generated at all, but limits your recovery options.
Simon.
If you aren't going to do a backup, then enable circular logging on the databases. You will need to dismount and then mount the database for the change to take effect. That will stop the logs from being generated at all, but limits your recovery options.
Simon.
Thanks for the solutions .
so what i get is that if i take a full backup the logs will flush automatically from the current location and will result in decrease in size of database?
can i use application available in windows server 2012 for exchange backup ?
any useful links regarding the suggested solutions would really help alot.
and thanks again
so what i get is that if i take a full backup the logs will flush automatically from the current location and will result in decrease in size of database?
can i use application available in windows server 2012 for exchange backup ?
any useful links regarding the suggested solutions would really help alot.
and thanks again
Active 2 days ago
Logs are separate files and does not count to the size of database file.edb. Taking the successful backup will save your disk space.
Reducing the size of database is completely a different task.
Check the link below for an idea about using windows backup http://technet.microsoft.com/en-us/library/dd876854%28v=exchg.150%29.aspx
Do some Google search for more info on the same.
Reducing the size of database is completely a different task.
Check the link below for an idea about using windows backup http://technet.microsoft.com/en-us/library/dd876854%28v=exchg.150%29.aspx
Do some Google search for more info on the same.
Active 5 days ago
The built in Windows Backup will do the job, but it isn't a great choice as it isn't very flexible.
Backup Assist is my usual tool for this task. It is cheap, uses the native writers and generally does the job with no fuss.
A backup will reduce the size of the database directory, because by default Exchange stores the databases and transaction logs in the same place.
Simon.
Backup Assist is my usual tool for this task. It is cheap, uses the native writers and generally does the job with no fuss.
A backup will reduce the size of the database directory, because by default Exchange stores the databases and transaction logs in the same place.
Simon.
Can i take a backup without un-mounting the DB in exchange?
Can i take the DB backup while all the exchange services are running?
Can i take the DB backup while all the exchange services are running?
Active 5 days ago
Exchange aware backups are designed to be carried out with Exchange operating.
An Exchange aware backup is the only way that the logs will be flushed.
Simon.
An Exchange aware backup is the only way that the logs will be flushed.
Simon.
Active 3 days ago
Yes you can take backup while exchange services are running without unmounting database
If you do not want to buy third party backup solutions then go for builtin windows server backup
Here are the steps to take backup on exchange 2013 using windows server backup.
http://msexchangeteam.in/how-to-backup-exchange-server-2013-database-part-1/
If you do not want to buy third party backup solutions then go for builtin windows server backup
Here are the steps to take backup on exchange 2013 using windows server backup.
http://msexchangeteam.in/how-to-backup-exchange-server-2013-database-part-1/
Featured Post
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
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.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.
Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
To show how to generate a certificate request 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 Servers >> Certificates…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA).
For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651
If you want to manage em…
Suggested Courses
Course of the Month7 days, 17 hours left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.