Exchange 2010 Journaling - Journal DB Sizing

I am tasked to establish journaling on a small Exchange 2010 on prem environment.  I am running Exchange STD so I will be doing the entire DB.  I have one single DB that is 42GB.  I do not know the message volume for the 75 user mailboxes.
My intent is to create and re-point the journaling to a new Journal Mailbox based on Calendar year if possible.  Log file generation for the day is about 500MB if that helps with daily volume calculation.

Is there a Best Practice for sizing needs so I can create a new LUN for the Journaling DB?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hi simply create a journaling mailbox, and you can if you like creat a journaling database. As im sure yoy know the journaling mailbox will keep all emails regardless of whether the emails are kept or deleted. I reset my journals quarterly to keep the size of the mailbox down and also provides a better time frame of recovery when searching for the mails. Is the server physical or virtual
Thomas GrassiSystems AdministratorCommented:
you know the database will continue to grow so best to have another drive for the new LUN and the mailbox for Journaling.

I also wrote a script to export the journaling inbox to a pst file

I run this weekly

You do not want your inbox to get too large.

The PST files are more manageable to open at a later time.

If you need help with a script let me know

winandtellAuthor Commented:
Hi Thomas,

Yes, it is a separate new LUN.  I would appreciate any scripting to automate exporting to a pst to allow for offloading and easier searches.
I also thought of creating new Journal Mailboxes periodically to segregate dates as well.

Thomas GrassiSystems AdministratorCommented:

the batch file that is in task manager is this

echo off
del c:\util\journal.txt
C:\Windows\System32\WindowsPowerShell\v1.0\PowerShell.exe -PSConsoleFile "D:\Program Files\Microsoft\Exchange Server\V14\Bin\ExShell.psc1" -Command "./journal.ps1"

The power shell script is here

$today = Get-Date -Format "MMddyyyy"
$Folder = "\\\volume_1\email\journal\journal-$today"
[System.Threading.Thread]::CurrentThread.CurrentCulture = [System.Globalization.CultureInfo]::CreateSpecificCulture("en-us")

add-pssnapin Microsoft.*

$start = (get-date).adddays(-7).toString('MM/dd/yyyy')
$end = (get-date).toString('MM/dd/yyyy')
$filter = "(Received -gt '"+$start+"') -and (Received -lt '"+$end+"')"

New-MailboxExportRequest –Mailbox journal -FilePath "$folder.pst" -ContentFilter "$filter" -confirm:$false -verbose -baditemlimit 15 >>c:\util\journal.txt

$timeout = new-timespan -Minutes 10
$ticker = [diagnostics.stopwatch]::StartNew()

while ($ticker.elapsed -lt $timeout) {    
    ##$Completed = Get-MailboxExportRequest -mailbox journal | Where {$_.Status -eq “Completed”} >>c:\util\journal.txt
       if (Get-MailboxExportRequest -mailbox journal | Where {$_.Status -eq “Completed”}) {       
              search-mailbox -identity journal -searchquery "Received:($start..$end)"  -deletecontent >>c:\util\journal.txt -force       
       start-sleep -seconds 60
Get-MailboxExportRequest | Where {$_.Status -eq “Completed”} >>c:\util\journal.txt
Get-MailboxExportRequest | Where {$_.Status -eq “Completed”} | Remove-MailboxExportRequest -confirm:$false >>c:\util\journal.txt

Open in new window

This runs weekly

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
winandtellAuthor Commented:
Great details and extra kudos on the automation
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.