April 09, 2007

Exchange 2007 Queue Database - Moving it

Here's an odd one. Whilst starting work on the demo's for the upcoming events in Sweden (15/16 May) I was trying to be a smart arse and be economic with the amount of space I gave to the VMware images. Anyway, upshot was that the c:\ drive became too small for the HT to be able to work properly and once the threshold is reached the MSExchangeMailSubmissionService won't actually deliver messages, even if the MSExchangeTransport and MSExchangeMailSubmissionService are both started. There is a warning in the event log to say that mail submission isn't working so don't worry, you'll know there's a problem.

No problems then. Dive into PowerShell to change the location of the queue. What could be simpler? I knew it wasn't in the GUI so obviously it's in PowerShell. Errrrr, nooooo, not so much. For some odd reason the online help tells us it's actually time to delve into notepad.

in the \bin directory you will see EdgeTransport.exe.config file. Edit that in Notepad and change the following two lines:

add key="QueueDatabasePath" value = "d:\newplace"
add key="QueueDatabaseLoggingPath" value = "d:\another-newplace"


Then stop and start the MSExchangeTransport service. Check and make sure the files are recreated in the new location. Armed with a nice working VMware image I delved into PowerShell with the intention of finding the correct command and then knocking an email to the helpy authory people in Redmond for correction in the next run. Again, not so much.

I wonder why the help doesn't (yet?) point you at PowerShell?

2 comments:

Anonymous said...

Mark,

I have a UI tool that automates mving the DB, want to give it a try?
we have been using it internally in the Edge perf team

Send me email to eliask@microsoft.com, and I'll forward it to you.


Thanks

Elias

Matt said...

I'm pretty sure you just saved my life, job, and sanity.

Gracias, fine sir.