Avatar of sglee
sglee

asked on 

Single vs Multiple Exchange Database file

Hi,
 
 I have Exchange Server 2010 with a single mailbox database with about 30 mailboxes and file size is 230GB.
 Recently it crashed, failed to mount and I had to repair exchange database. Even after I got it mounted, due to some corrupted mailboxes, I ended up creating a second mailbox database and moved some mailboxes from original database into newly created database.
I have not thought about this, but I am thinking that it may be a good idea to split these 30 mailboxes into several mailbox database files in stead of a single file.

Here is my thought:

First, when I have to perform a database repair, it would take less time.
Second, when the computer loses the power, corrupting exchange database files, there is a chance some files might be in good shape.

However since I have not managed multiple exchange database files, I like to listen to other experts about Pros and Cons.

Thanks.
Exchange

Avatar of undefined
Last Comment
sglee
SOLUTION
Avatar of Tom Cieslik
Tom Cieslik
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of sglee
sglee

ASKER

Computer has a UPS. However it got locked  up for unknown  reason and I could not get to desktop screen to shut it down properly; therefore I had no choice but to hold power button down.
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

And what postmortem have you done to determine why that happened?  It's not always easy or even possible to tell... but you need to look at your system and try to understand why it's not performing as it should.  Make sure your backups are good.  Things will happen... BUT, this should not be a common occurrence... if it's anywhere near a common thing, you need to take steps to prevent it before you start breaking up the exchange database (not saying it's a bad idea - or a good idea - but rather an idea that should be addressed LATER).
SOLUTION
Avatar of Tom Cieslik
Tom Cieslik
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of sglee
sglee

ASKER

@Tom
I would have tried remote shutdown had I known this command then. I will try it in the future.
@Lee
I did not get a chance to save event viewer log immediately after the server freeze due to many issues that I had to address.
Since I did not increase the size of event files from default - 1024, the events that I could have looked for are gone by now. It has been 10 days.
On the day of freeze, I stopped windows server backup to preserve the previous day of good exchange backup just in case I need to restore exchange database. On the 2nd day I resumed the backup.
If it is possible, I could try to restore event viewer as of next day of freeze to see what I can find.
Avatar of Mahesh
Mahesh
Flag of India image

as long as you are having single mailbox database server, no matter how many databases you create, it won't help since server crash will affect all databases
For 30 mailboxes I wouldn't recommend 2nd server in DAG for HA to avoid outage and issues, but that could be an option
Probably you can check suitable O365 plan and move your mailboxes, it will be better option as far as I think
ASKER CERTIFIED SOLUTION
Avatar of Vick Vega
Vick Vega
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of sglee
sglee

ASKER

@Lee
“And what postmortem have you done to determine why that happened?” —> Not sure 100%, but I found out that an old external USB HD has gone bad beyond repair via Seatools.
I had it unplugged (when I powered the server off ) until few days ago. When I finally plugged it back to the server, it only displayed the drive letter and failed to display capacity and free space information. That is when I brought it to my computer and ran Seatools & teied “Fix-all” option (but failed to fix).
Exchange
Exchange

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

213K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo