Exchange 2003 store wont mount

Hi, I was running a defrag on a 100GB database. Unfortunately the defrag crashed at about 90% due to lack of space.

When I try to restart the defrag it fails with error -540 database streaming mismatch.

Now the dB wont mount.

Below is the result of a eseutil /mh dump.
PS: I don't have the temporary database from the first defrag. They were deleted.

What is the best way to recover? I dont have a flat dB copy or backup, so I would prefer a repair option.



E:\Program Files\Exchsrvr\bin>eseutil /mh "G:\second sg mailbox store a-e\a-
b"

Microsoft(R) Exchange Server Database Utilities
Version 6.5
Copyright (C) Microsoft Corporation. All Rights Reserved.

Initiating FILE DUMP mode...
         Database: G:\second sg mailbox store a-e\a-e.edb
   Streaming File: G:\second sg mailbox store a-e\a-e.STM

        File Type: Database
   Format ulMagic: 0x89abcdef
   Engine ulMagic: 0x89abcdef
 Format ulVersion: 0x620,11
 Engine ulVersion: 0x620,11
Created ulVersion: 0x620,11
     DB Signature: Create time:03/27/2010 23:05:22 Rand:431616798 Computer:
         cbDbPage: 4096
           dbtime: 110739144 (0x699bec8)
            State: Clean Shutdown
     Log Required: 0-0 (0x0-0x0)
   Streaming File: Yes
         Shadowed: Yes
       Last Objid: 40919
     Scrub Dbtime: 0 (0x0)
       Scrub Date: 00/00/1900 00:00:00
     Repair Count: 0
      Repair Date: 00/00/1900 00:00:00
 Old Repair Count: 0
  Last Consistent: (0x0,0,0)  03/28/2010 07:43:20
      Last Attach: (0x0,0,0)  03/27/2010 23:05:23
      Last Detach: (0x0,0,0)  03/28/2010 07:43:20
             Dbid: 2
    Log Signature: Create time:00/00/1900 00:00:00 Rand:0 Computer:
       OS Version: (5.2.3790 SP 2)

Previous Full Backup:
        Log Gen: 0-0 (0x0-0x0)
           Mark: (0x0,0,0)
           Mark: 00/00/1900 00:00:00

Previous Incremental Backup:
        Log Gen: 0-0 (0x0-0x0)
           Mark: (0x0,0,0)
           Mark: 00/00/1900 00:00:00

Current Full Backup:
        Log Gen: 0-0 (0x0-0x0)
           Mark: (0x0,0,0)
           Mark: 00/00/1900 00:00:00

Current Shadow copy backup:
        Log Gen: 0-0 (0x0-0x0)
           Mark: (0x0,0,0)
           Mark: 00/00/1900 00:00:00

     cpgUpgrade55Format: 0
    cpgUpgradeFreePages: 0
cpgUpgradeSpaceMapPages: 0

       ECC Fix Success Count: none
   Old ECC Fix Success Count: none
         ECC Fix Error Count: none
     Old ECC Fix Error Count: none
    Bad Checksum Error Count: none
Old bad Checksum Error Count: none

Operation completed successfully in 4.219 seconds.


E:\Program Files\Exchsrvr\bin>

LVL 1
susnewyorkAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

megs28Commented:
Use this command:  ESEUTIL /P priv1.edb /I

Make sure you have 110% of free space available. for the temp databases.
You may want to make an offline copy of the logs, edb, and stm files before attempting another repair
At this point you may have also lost data, so be sure to make proper backups in the future.

See http://technet.microsoft.com/en-us/library/aa997215(EXCHG.65).aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
susnewyorkAuthor Commented:
Sorry. I forgot to post result of eseutil /mh for the STM. Here it is:

E:\Program Files\Exchsrvr\bin>eseutil /mh "G:\second sg mailbox store a-e\a-e.
m"

Microsoft(R) Exchange Server Database Utilities
Version 6.5
Copyright (C) Microsoft Corporation. All Rights Reserved.

Initiating FILE DUMP mode...
         Database: G:\second sg mailbox store a-e\a-e.stm

        File Type: Streaming File
   Format ulMagic: 0x89abcdef
   Engine ulMagic: 0x89abcdef
 Format ulVersion: 0x620,11
 Engine ulVersion: 0x620,11
Created ulVersion: 0x620,11
     DB Signature: Create time:05/03/2009 01:14:00 Rand:874776860 Computer:
         cbDbPage: 4096
           dbtime: 0 (0x0)
            State: Clean Shutdown
     Log Required: 0-0 (0x0-0x0)
         Shadowed: Yes
       Last Objid: 0
     Scrub Dbtime: 0 (0x0)
       Scrub Date: 00/00/1900 00:00:00
     Repair Count: 0
      Repair Date: 00/00/1900 00:00:00
 Old Repair Count: 0
  Last Consistent: (0x3F284,1DEC,1F0)  00/00/1900 00:00:00
      Last Attach: (0x3F283,22B7,16)  00/00/1900 00:00:00
      Last Detach: (0x0,0,0)  00/00/1900 00:00:00
             Dbid: 0
    Log Signature: Create time:08/05/2007 11:05:06 Rand:922297584 Computer:
       OS Version: (5.2.3790 SP 2)

Previous Full Backup:
        Log Gen: 0-0 (0x0-0x0)
           Mark: (0x0,0,0)
           Mark: 00/00/1900 00:00:00

Previous Incremental Backup:
        Log Gen: 0-0 (0x0-0x0)
           Mark: (0x0,0,0)
           Mark: 00/00/1900 00:00:00

Current Full Backup:
        Log Gen: 0-0 (0x0-0x0)
           Mark: (0x0,0,0)
           Mark: 00/00/1900 00:00:00

Current Shadow copy backup:
        Log Gen: 0-0 (0x0-0x0)
           Mark: (0x0,0,0)
           Mark: 00/00/1900 00:00:00

     cpgUpgrade55Format: 0
    cpgUpgradeFreePages: 0
cpgUpgradeSpaceMapPages: 0

Operation completed successfully in 3.406 seconds.


0
susnewyorkAuthor Commented:
I am waiting for a flat file copy of the current dB to complete before attempting a repair using:
ESEUTIL /P priv1.edb /I   to repair while suppressing file mismatch.
 

0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

AkhaterCommented:
DO NOT run eseutil /p right now your database is in clean shutdown

find the place where your logfiles resides create a new folder and MOVE (do NOT delete) all files that are NOT edb and STM

i.e move all logfiles and check files to it. you should keep ONLY the edb and STM (IF they are in the same directory)

then try to mount the database again, if it works then you can delete the folder you have created if it doesn't work then you should think of running the /P
0
susnewyorkAuthor Commented:
I moved logs to new folder but database would not mount. Any other ideas before I try /P



0
AkhaterCommented:
what is the error in event log ?
0
susnewyorkAuthor Commented:
Error 0xfffffde4 starting Storage Group /DC=ad/DC=domain/CN=Configuration/CN=company/CN=Microsoft Exchange/CN=compnay/CN=Administrative Groups/CN=First Administrative Group/CN=Servers/CN=SUSEXBACK01/CN=InformationStore/CN=Second Storage Group on the Microsoft Exchange Information Store.
MDB failed to start.
Error 0xfffffde4 starting Storage Group /DC=ad/DC=susinc/CN=Configuration/CN=company/CN=Microsoft Exchange/CN=company/CN=Administrative Groups/CN=First Administrative Group/CN=Servers/CN=SUSEXBACK01/CN=InformationStore/CN=Second Storage Group on the Microsoft Exchange Information Store.
MDB failed to start.


0
AkhaterCommented:
0
susnewyorkAuthor Commented:
Unfortunately I don't have the temp files anymore. This kb won't work for me. Is my only option /P ?
0
Satya PathakLead Technical ConsultantCommented:
Can you please provide me ESE event id error code like - jet etc.
0
AkhaterCommented:
Too bad !

Give /p a try

Good luck
0
jigansCommented:
Susnewyork - you are panicking for no reason.. Solution for this one is too simple.. Your STM file is corrupted... Rename it to something else, recreate STM file using KB article below and all shall be well..

http://support.microsoft.com/kb/555146

Couple of things you would want to keep inmind
1. Do a flat copy of MDBDATA Directory to a USB prior to doing anything - including All logs, EDBs and STMS.
2. Disable AV Scan @ file and Exchange IS store during these operations


Regards,
J...
0
susnewyorkAuthor Commented:
jigans, thanks for the suggestion however rebuilding the stm will cause data loss for OWA users.
0
susnewyorkAuthor Commented:
In the end I resorted to my 3rd party backup application and restored the dB to RSG, and then copied the edb and stm back to the production server.

Thankfully this worked. Thank you everyone for your suggestions.

0
susnewyorkAuthor Commented:
I will be splitting points between megs28 and Akhater for their suggestions.

FYI: I called Microsoft Support who would not touch the case since I am running Exchange 2003 on VMWare.


0
susnewyorkAuthor Commented:
In the end, none of these solutions would work without major data loss. I had to resort to 3rd party backup application.

Thank you everyone who helped me out.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.