10/10/07

Exchange Sucks

I have no clue why Microsoft doesn't really design a better concept for Exchange. It works, and it works really well, until something goes wrong and undetected for a few months.

The repairs I ran with my Microsoft Support guy did get the job done... We did eseutil /k on the priv1.edb and priv1.stm files. Priv1.edb was find. No errors. Priv1.stm: a few thousand errors. My tech literally said "Oh My God" twice as the errors scrolled up the screen.

He then informed me that deleting the STM file and recreating it would be the best option for this situation. Repairing the file just wasn't as likely to succeed.

Unfortunately, both the database and our server were in bad shape. The server has very little storage space available on it. It was so low in fact, that we had to do much of our database management on an external USB hard drive and to expedite our troubleshooting, we also used the tape drive to back up the MDBData directory.

Once we got everything done, which we started at 5 PM and ended at 9:30, we made a backup of the MSExchangeIS and proceeded on to basically conclude the ticket. People were able to access their storage, the database was able to be backed up again, and I was even able to do an offline defrag of the database. Things were looking good and we were done long before I thought we would be.

I left the building after speaking with my "on-site boss." Neither of us got home until well after 11pm. I then spoke with Don, my "boss/mentor" down at CMC. We talked on the phone until 2 AM about the service call and what needed to be covered a few other things that needed to be done on site to be sure that we had everything under control. I was finally able to get into bed at 3AM.

I woke up at 7:30 to turn on my cell phone, just incase something happened on site, I went right back to bed.

At 8:30 AM I received a call from my on-site boss. There were problems. Apparently, after the work done on Monday night, now ever one on site who connected to Exchange had lost all of their external emails. They had emails from the local domain, but anything outside of that, including emails that have been saved for years were lost. It caused quite a stir come Tuesday morning. Fortunately, the most affected people were the IT staff.

I spent some time on the phone with Microsoft technicians and eventually we decided that further work was needed on the database. I worked with a new MS Technician for over an hour, before I got a call from the tech that I worked with the night before. We ended up deciding to switch the contact from my new support technician back to my original and continue work. I talked with my support tech and we decided that we needed to back restore the database to an alternative location and then we needed to get a second server up and running and mount the database on that guy to retrieve the data if at all possible.

Getting a decent computer, installing Windows 2000 Server and MS Exchange 2000 SP3 w/ Roll-up was troublesome enough. It was worse when I got back on site and received a call from my support tech at 4:30 and was informed that "Oops, we can't actually do that. It won't work unless everything is really similar." Great. 4 hours wasted. At least I got half an hour of sleep while the server OS was installed by Joel and Mitchell.

So, my support tech and I decided that it would be best to take our database offline, mount the old one and use ExMerge to pull out the six mailboxes that we needed. The process should be relatively quick compared to Monday's work.

Assuming, that is, if it works... Which it didn't.

ExMerge got one mailbox out of six. It was the largest mailbox too, at nearly 2 GB. At least that was something.

We then went and loaded up client machines and pulled their mailboxes off right from outlook instead of trying to do it through exchange. A much slower process, but at least it is much more likely to get the correct data. It seemed that it had. We remounted the "good" exchange database and all we needed to do was import the data back into Exchange.

Right then and there, my tech seemed really interested in getting me off the phone. We had pulled the mailboxes off of the server to back them up and we had reconnected the good exchange database, but we had not restored anything to Exchange.

I managed to talk him into helping me restore a single mailbox and keeping the trouble ticket open for another 24 hours before he closes it. And he quickly ushered me off of the phone. I can understand, the two of us have had busy days, but it was a little crappy there at the end... And I was not exactly pleased about the whole "Make a server by 4pm!" thing either.

~sigh. This is why I cannot stand Exchange.

8 comments:

Anonymous said...

Hi: I saw your post and could not resist leaving a comment. Dude - go to Hosted Exchange 2007! No hassles or fiddling around. And its really not at all expensive. To plug our supplier - check out http://www.123together.com.

be cool

Daniel: "IndigoJake" said...

It's unfortunate that I read this long after I stopped working for that client, but a good suggestion none-the-less! The next time I run into a small office trying to keep alive an old Exchange server, I'll suggest that.

Anonymous said...

"Unfortunately, both the database and our server were in bad shape. The server has very little storage space available on it."

That right there shows you're an amateur. Exchange is for the big boys, it should not be in the hands of people that don't know what they're doing.

Daniel: "IndigoJake" said...

I'm afraid that "Anonymous" on 9/16 missed the point here. Granted, the setup was poor, however, it was not my setup, but a setup that the client already had in-place when they brought CMC in (on a shoe-string budget). I do agree that this client should not have been Exchange in their organization without even a single IT staff member to occasionally check in on the Exchange server (not to mention the unmonitored Citrix setup they had going as well), however it is far from it to blame me for the actions of my client -who made these decisions long before I even knew that their company existed.

The problem is that in this situation, there was no indication to anyone at the organization as to how bad the server was getting. Exchange wasn't sending any entries to any logs that I checked, System Manager was running fine and there didn't seem to be any abnormal entries in Event Viewer.

I am in no way claiming to be an Exchange expert - but one would think that if a server has database corruption, that there would be something a little more prominent than an error after running a diag util.

And please, thoroughly read though my entries before commenting on my experience... Just two paragraphs after that line you cited I clearly state that this was an on-site (contractual) job though my parent company, CMC, and that it was our client that was having issues - some caused by Microsoft Tech Support providing fixes without getting into details about the side-affects that the "fix" would cause. Fortunately, in the end, we were able to get things up and running (and started formulating a plan to upgrade the servers and create a better backup strategy than using tapes over and over and an external USB HDD).

Daniel: "IndigoJake" said...

And for those curious as to how all this ended up in the long run, as CMC and the client were under a long-term support and maintenance contract and working on getting new servers ordered, CMC began preparation for closing its doors in late February, 2008 - at which time, I left the company for a more secure job in Detroit-Metro working with BMC Remedy 7.x and 5.x application software implementations.

Anonymous said...

> That right there shows you're >an amateur. Exchange is for the >big boys, it should not be in the >hands of people that don't know >what they're doing.
9/16/2009
Except that Microsoft packages exchange as part of their SBS server. IS that also for the big boys?

e said...
This comment has been removed by the author.
Daniel: "IndigoJake" said...

Thanks, Anonymous (on 9/18 ), I forgot about SBS. I never implemented it, but my bosses did several times, and at least two of my friends did for companies that had between 10 and 30 employees.

In regard to sendmail, I have never managed a system where it was implemented. Since my training has been more on Microsoft software, I haven't delved much into OSS (and other, non-Microsoft, applications-for the most part). From what I last heard though, Sendmail is a more popular than MSExchange, at least for the large email environments --sounds like Sendmail is more commonly used in large, public, "sign up to get a free email address!" deployments than Exchange is.