1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Exchange DB maintenance work

Discussion in 'Software' started by Theprof, Aug 20, 2010.

  1. Theprof

    Theprof Petabyte Poster Forum Leader

    4,570
    68
    196
    This weekend I'll be doing some DB maintenance work... It will involve an ISInteg and potentially a DB defrag. Before proceeding with the maintenance I will be sure to make a backup of the database.

    Do you guys have any recommendations? the database size is 375GB!!! which is insane! I am guessing the ISInteg might take a while? as I know for a fact a defrag will as well.
     
    Certifications: A+ | CCA | CCAA | Network+ | MCDST | MCSA | MCP (270, 271, 272, 290, 291) | MCTS (70-662, 70-663) | MCITP:EMA | VCA-DCV/Cloud/WM | VTSP | VCP5-DT | VCP5-DCV
    WIP: VCAP5-DCA/DCD | EMCCA
  2. LukeP

    LukeP Gigabyte Poster

    1,194
    41
    90
    I think weekend might not be enough to be honest.
    ESEutil took 17 hours (+ISINTEG) to go through 55GB database last time I was doing it.

    Unless that was something unusual and I was just unlucky.

    edit: Changed hours from 27 to 17 (typo)
     
    Last edited: Aug 20, 2010
    WIP: Uhmm... not sure
  3. Theprof

    Theprof Petabyte Poster Forum Leader

    4,570
    68
    196
    Both took you 27 hours? or just the ESEutil? My guess is that they would both take roughly around the same amount of time to complete unless there are DB corruptions.

    Also can you stop an ESEUtil and ISINTeg while it's running? or will it screw up the DB?
     
    Last edited: Aug 20, 2010
    Certifications: A+ | CCA | CCAA | Network+ | MCDST | MCSA | MCP (270, 271, 272, 290, 291) | MCTS (70-662, 70-663) | MCITP:EMA | VCA-DCV/Cloud/WM | VTSP | VCP5-DT | VCP5-DCV
    WIP: VCAP5-DCA/DCD | EMCCA
  4. LukeP

    LukeP Gigabyte Poster

    1,194
    41
    90
    Sorry mate. Typo there 17 hours.

    You should be able to kill the eseutil process (not sure about the consequences) but when restarted it will start again from a scratch (it won't start off where it left).

    It took me 17 hours just for ESEUtil and about the same for ISInteg.
    ESEUTIL and ISINTEG run at about the same speed which in theory is 4-6GB per hour (from my experience closer to 3-4 GB per hour). I guess the more messy database there is the longer it takes.

    edit: We did have corruptions though

    edit 2: For the record I was running it on Dell R710 - Quad core 2.4GHz - 32GB RAM running from 15k RPM SAS drives in RAID 1 (System was doing nothing but this and it was for testing purposes so out of production = no other load on the server)
     
    Last edited: Aug 20, 2010
    WIP: Uhmm... not sure
  5. LukeP

    LukeP Gigabyte Poster

    1,194
    41
    90
    I've just been told that if there's no errors in the database ISInteg can even run at 10GB/hour. Still with 375GB database you're looking at roughly 100 hours in total I reckon.
     
    WIP: Uhmm... not sure
  6. Theprof

    Theprof Petabyte Poster Forum Leader

    4,570
    68
    196
    I see... I am pretty sure there are errors on our DB which makes me believe that it will take longer than expected...
     
    Certifications: A+ | CCA | CCAA | Network+ | MCDST | MCSA | MCP (270, 271, 272, 290, 291) | MCTS (70-662, 70-663) | MCITP:EMA | VCA-DCV/Cloud/WM | VTSP | VCP5-DT | VCP5-DCV
    WIP: VCAP5-DCA/DCD | EMCCA
  7. LukeP

    LukeP Gigabyte Poster

    1,194
    41
    90
    As I said, ours was corrupted . Also the above timing are for corrupted database and ESEUTIL /P process as well as ISInteg -fix. I think defrag should take less time (not sure, never done it).

    So in a shorter way the worst scenario. Would it be possible to grab a copy of the database and work on the copy first (stand-alone machine). This way you can run eseutil and isinteg tests during the week and check what's wrong before you commit to lenghty repair process (possibly unnecessary)?
     
    WIP: Uhmm... not sure
  8. zebulebu

    zebulebu Terabyte Poster

    3,748
    330
    187
    With a DB that size, even with an excellent disk subsystem, running isinteg or eseutil is going to take at least two days for each - in a 'best case' scenario. You'll need to schedule two weekends - one to run isinteg and fix 'soft' errors and then, if that doesn't resolve your problems, the next weekend to run eseutil and fix anything at the low level. Be warned - make SURE you have a backup that works. ESEUTIL & ISINTEG aren't the b***ards they used to be - back in the day ESEUTIL especially seemed to destroy Exchange 5.5 DBs as regularly as it fixed them - but it's still a pretty destructive tool. If you're currently in the situation where Exchange still works, I'd argue that the best thing to do would be a migration to a new server. If you can't do that for budget reasons, at least make sure you take a full Exchange backup and verify it first before you do either an offline defrag or run isinteg -fix.
     
    Certifications: A few
    WIP: None - f*** 'em
  9. Theprof

    Theprof Petabyte Poster Forum Leader

    4,570
    68
    196
    My colleague and I came across an article on experts-exchange stating that by moving a mailbox over to another exchange mailbox store, the exchange server will "cleanse" the mailboxes before moving them over, and if the mailbox is really corrupted the move won't happen. Can anyone confirm that?
     
    Certifications: A+ | CCA | CCAA | Network+ | MCDST | MCSA | MCP (270, 271, 272, 290, 291) | MCTS (70-662, 70-663) | MCITP:EMA | VCA-DCV/Cloud/WM | VTSP | VCP5-DT | VCP5-DCV
    WIP: VCAP5-DCA/DCD | EMCCA
  10. Theprof

    Theprof Petabyte Poster Forum Leader

    4,570
    68
    196
    Noted! thanks Zeb.
     
    Certifications: A+ | CCA | CCAA | Network+ | MCDST | MCSA | MCP (270, 271, 272, 290, 291) | MCTS (70-662, 70-663) | MCITP:EMA | VCA-DCV/Cloud/WM | VTSP | VCP5-DT | VCP5-DCV
    WIP: VCAP5-DCA/DCD | EMCCA
  11. craigie

    craigie Terabyte Poster

    3,020
    173
    155
    When moving to exchange 2007/2010 you specify how many corruptions are allowed eg 10 per mailbox.

    Best advice is to get users to delete or archive mails, then dismount stores and back them up. Next do what Zen said mate.
     
    Certifications: CCA | CCENT | CCNA | CCNA:S | HP APC | HP ASE | ITILv3 | MCP | MCDST | MCITP: EA | MCTS:Vista | MCTS:Exch '07 | MCSA 2003 | MCSA:M 2003 | MCSA 2008 | MCSE | VCP5-DT | VCP4-DCV | VCP5-DCV | VCAP5-DCA | VCAP5-DCD | VMTSP | VTSP 4 | VTSP 5
  12. Theprof

    Theprof Petabyte Poster Forum Leader

    4,570
    68
    196
    Would anybody know if performing an ESEUTIL or a ISINTEG and then killing the process would damage the database?
     
    Certifications: A+ | CCA | CCAA | Network+ | MCDST | MCSA | MCP (270, 271, 272, 290, 291) | MCTS (70-662, 70-663) | MCITP:EMA | VCA-DCV/Cloud/WM | VTSP | VCP5-DT | VCP5-DCV
    WIP: VCAP5-DCA/DCD | EMCCA
  13. Theprof

    Theprof Petabyte Poster Forum Leader

    4,570
    68
    196
    Thanks bud!
     
    Certifications: A+ | CCA | CCAA | Network+ | MCDST | MCSA | MCP (270, 271, 272, 290, 291) | MCTS (70-662, 70-663) | MCITP:EMA | VCA-DCV/Cloud/WM | VTSP | VCP5-DT | VCP5-DCV
    WIP: VCAP5-DCA/DCD | EMCCA
  14. Theprof

    Theprof Petabyte Poster Forum Leader

    4,570
    68
    196
    nvm I figured it out... it might damage the db to a point where you can't mount it back on if we cancel it while it's writing to the db trying to fix it. However this is more of a hit or miss scenario because some people say they never had any issues after canceling.
     
    Certifications: A+ | CCA | CCAA | Network+ | MCDST | MCSA | MCP (270, 271, 272, 290, 291) | MCTS (70-662, 70-663) | MCITP:EMA | VCA-DCV/Cloud/WM | VTSP | VCP5-DT | VCP5-DCV
    WIP: VCAP5-DCA/DCD | EMCCA
  15. Sparky
    Highly Decorated Member Award

    Sparky Zettabyte Poster Moderator

    10,191
    299
    319
    Would have to agree.

    If it’s working (and just about to be decommissioned) then just migrate the mailboxes as you need to.
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) Security+ Network+ A+
    WIP: Exchange 2007\2010

Share This Page

Loading...