• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • Last Modified:

Corrupt Exchange 2003 Database

Hello Experts,

I have a SBS 2003 production server. My database was getting to be too large so I decided to run an offline defrag over the weekend. It failed with Jet error 1022 disk I/O something. I looked into the error and Microsoft said that the database was corrupted. Can I created backup PSTs of everyone's email account to their local machine, create a new exchange database/Information Store and then connect them back to the new database with their emails in tact or is that not possible?  Or is it the wrong thing to do?  They will not upgrade their server yet as it is still under warranty.  I just need help with what is possible and the safest thing to do. I have heard that doing a repair on the database using ESEUTIL could cause some major issues. I also need to minimize downtime for the server.

Thanks in advance,

BJD
0
BJDalfol9
Asked:
BJDalfol9
  • 5
  • 4
1 Solution
 
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
My database was getting to be too large so I decided to run an offline defrag over the weekend. It failed with Jet error 1022 disk I/O something - Did you make a copy of it before running Offline defrag ?

What is the last good backup you have ?

Can I created backup PSTs of everyone's email account to their local machine - Perfect convert OST to PST and then mount database with Blank store.

- Rancy
0
 
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
create a new exchange database/Information Store and then connect them back to the new database with their emails in tact or is that not possible? - I would recommend to keep them as they are as if the corruption is in those emails\data why move it back into the Database ... users can use the earlier information from PST and use the new Mailbox as fresh :)

Converting OST to PST is very good and no data loss and least downtime with all data in place.

- Rancy
0
 
BJDalfol9Author Commented:
Rancy,

I'm not sure about the last "good" backup I have as I have no idea how long it has been corrupted. We use a BDR unit with offsite storage so we have multiple backups that happen a day and a redundancy of a couple weeks. But like I said I don't know when the corruption happened. As far as the OST to PST situation, I can do that. It sounds like the route I'll be taking. Thanks for the idea about a fresh start. That is a good idea :)

Thanks again!

BJD
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Your most welcome just keep me posted.

- Rancy
0
 
BJDalfol9Author Commented:
One more thing. How do I get the fresh mailboxes added after creating the new information store?  Like how do I link them back to Active Directory again?  Does that make sense?
0
 
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
How do I get the fresh mailboxes added after creating the new information store? - You dont need to create any mailboxes once you remove all logs and every file and mount blank users just have to login once and can simply start working.

Thats the reason its said first take OST to PST as if you mount blank and Outlook or OST sync all data will be lost

- Rancy
0
 
lucid8Commented:
First thing I would recommend is to ensure there are no system errors, i.e. check the event logs for the system and application and look specifically for disk related errors, i.e. if an disk subsystem has issues you are bound to repeat this unfortunate process again so I would get them fixed. :-)

Moving forward before you create the new DB you want to;

1. go to each users machine, launch outlook and it will complain it cannot talk to the server and will ask if you want to work offline.  Say yes

2. Once open export the mailbox to PST and then confirm you can open the PST and all data is there.

3. Once that is done for all the users then go to the Exchange server and;

A: either rename the EDB and STM files so that they are different, i.e. if the name before is Mailbox.edb and Mailbox.stm  then name them OLD_Mailbox.edb and .stm or move them off the existing location.  I would recommend renaming since you can still keep the files around for possible recovery by a third party tool (we make on)

B: Now that the database files are renamed or backed up go into the Exchange Management console and attempt to mount the CB

C: Exchange will squawk saying that the database files are missing and if you continue a new database will be created.

D: Say yes and new database files will be created and mounted.

E: As soon as the database is mounted email will be able to be sent and received i.e. all the mailboxes are now available but have no historical email.

F: Now get a good backup

G: Now go to each user and have them open outlook again and attach to the server.  Once connected import the data from the PST files into the new store.

E: Do ensure you get good backups from here on out and also monitor the disk subsystem.
0
 
BJDalfol9Author Commented:
I've requested that this question be deleted for the following reason:

Old
0
 
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
BJDalfol9: Sorry but buddy i guess we should have been awarded for helping rather than deleting the post with comments such as Old.

Wont Object though and leave it to you.

- Rancy
0
 
BJDalfol9Author Commented:
I'm sorry this was just no longer an issue as we are no longer in business with our client because they went out of business.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now