80 likes | 212 Views
Presented January 8, 2008 at NYExUG Meeting. Case Study - Tips for Troubleshooting your (or a client’s) Exchange 2003 database problems.
E N D
Presented January 8, 2008 at NYExUG Meeting Case Study - Tips for Troubleshooting your (or a client’s) Exchange 2003 database problems Ben SerebinEhlo & Network ConsultantREEF Solutionsben a t reefsolutions . c o mIf you can’t get enough Exchange & technologyread my blog http://ehlotech.blogspot.com
About Ben Serebin • Working in the IT sector since 1996 • Specialty is Exchange Server, Spam Filtering, and Wireless (802.11x) • Hands-on database troubleshooting with Exchange 5.5 (some), 2000 (least), and 2003 (most). • Run own Exchange 2003 Server, Blackberry Exchange Server, and had run Good Mobile Messaging Server.
Overview • Why & how could this corruption happen to my client’s Exchange database? • TLC for Exchange databases • Background on Exchange databases • Approach to Solve Corruption • Web Resources (stick with microsoft.com, msexchange, or other reputable sources) • Recommendations
Why to my pampered Exchange database? • Did you follow all (or many) of the recommended Microsoft configurations? • Are you running file based anti-virus on your Exchange Server? • Do you run 3rd party synchronization software (e.g. Public Folder replication, Database replication, etc)? • Do you have slow internal disks (aka SATA) for your heavily abused Exchange Server? • Do you only have 1GB of RAM? • It does not matter (to some degree), it can happen to anyone. Scary music plays…
Background on Exchange Databases • Exchange 2003 uses 2 types of database files which are ESE based (similar to AD). • .edb database files: a rich-text database file containing message headers, message text, and standard attachments. • .stm database files: a streaming internet content file containing audio, video and other media that are formatted as streams of Multipurpose Internet Mail Extensions (MIME) data. • Exchange 2003 by default installs a Priv1.edb, Priv1.stm, Pub1.edb and Pub1.stm. Priv1 files are the Mailbox Store & Pub1 files are the Public Folder store. Quiz: how many db’s are in a new default install for Exchange 2003. • Exchange 2007 uses 1 type of database file: .edb files. Also, the ESE format has been slightly modified, so you don’t want to attempt a ESE repair or modification using Exchange 2003 ESE database utilities.
Approaches to Solve Corruption Recommend backups before you start this. Only run if your databases are experiencing problems*. • "eseutil /g" - Integrity check in read only mode. • "eseutil /k" - Checksum check for header damage. • "eseutil /p" – Repairs table and page. Perform isinteg next. • "eseutil /d" - defrags db's and reduce the size based on empty space. You can safely run this if you dismount the databases. • "isinteg -s emailsrv -fix -test alltests" - emailsrv = name of server. Used to test and insure all corruption is solved.
Resources • MS Exchange Team Blog about database fixing with eseutil • http://msexchangeteam.com/archive/2004/06/18/159413.aspx • MS Support - Ramifications of running the eseutil /p or edbutil /d /r command in Exchange • http://support.microsoft.com/kb/259851 • MS Exchange.org - isinteg & eseutil demo-ed • http://msexchange.org/tutorials/Exchange-ISINTEG-ESEUTIL.html • MS Support - eseutil checksum feature • http://support.microsoft.com/default.aspx?scid=kb;en-us;823167 • MS Support - eseutil file header damage • http://support.microsoft.com/default.aspx?scid=kb;en-us;825088 • MS Exchange Team Blog on 2007 SP1 Changes for ESE • http://msexchangeteam.com/archive/2007/11/30/447640.aspx
Presented January 8, 2008 at NYExUG Meeting Thank you for attending the NYExUG User Group Meeting.Benefits of Attending Meetings- learn about Exchange related topics- free pizza dinner- free raffles