We help IT Professionals succeed at work.

Corrupt exchange database

dexterhome
dexterhome asked
on
912 Views
Last Modified: 2012-06-27
Hi Guys.

I have only just noticed some issue with the exchange database.
1. It does not appear to be backing up correctly.
2. I can not move the mailboxes to another database.

This is reported in verious errors 474 and 217-1018 (see screen shots)

Note: Because of limitations in my tape backups all the backups are corrupt.

Note: At this point the database appears to be working correctly with no loss of data

Please can someone advise the best way to check the database for issues and how to repair it.
exchange2007-issue.jpg
exchange2007-issue2-eventlog.jpg
eXCHNGE2007-ISSUE-BACKUP1.jpg
Exchange2007-issues-backup2.jpg
Comment
Watch Question

Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
Firstly it would a big downtime....
1. Preferably get users outlook in cache so that we would have the data in cache mode ..
2. Make a copy of the database files ??
3. Two Options
a. Repair, defrag and Isinteg the database ....
b. Restore from Backup ...
There could be loss of data as Repair would remove the corrupted data from the Exchange database

Author

Commented:
Understood.
Before that could I:
Restore a posibley corrupt backup to an RSG and do the repair work on that datbase and see if I could mount it.  If it mounts I could then attempt to replay the logs file into it.
Does this have an logic to it.
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
Understanding and analyzing -1018, -1019, and -1022 Exchange database errors
http://support.microsoft.com/kb/314917

XADM: Extensible Storage Engine Event IDs 474 and 477 Are Logged When You Try to Back Up the Information Store Database
http://support.microsoft.com/kb/810411

Ramifications of running the eseutil /p or edbutil /d /r command in Exchange
http://support.microsoft.com/kb/259851/
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
Once reapired you cannot replay any logs as it has a new Rand value and cannot associate the Database to another Rand value logs ...

Author

Commented:
Ok.
Is there any way of getting the mailboxes to move to another DB.
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
Is the System Attendant Mailbox alive ??
If so is none of the mailboxes moving ??
Lastly you can just do few things to ensure that you have a good database
1. Repair the database ..... data loss
2. Take the Exmerge from mailboxes ..... playing with some permissions and again there would be data loss as it would also not move any data out
3. Outlook in cache mode take the data to PST from Outlook ..... no data loss as all mailbox data is converted to PST.

Author

Commented:
How do I check the system attendant mailbox.
The main (only) maildatabase created is working.  None of the mailboxes can be moved.
All machines are in cached mode.  If I repair the database and it removes some corrupt data - will the cached data just put it back again once reconnected.
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
You would see the mailbox on the first Mailbox store created on the Exchange server and is named as System Administrator ......
No way we have to take the data from OSt or cache Outlook to PST .... we cannot put it back as it would mean that the corruption would be carried back to the database ..... we will have to make use of those certain mails from the PST itself .....
For example if you have 10 mails in Outlook for userA and we repair the database and about 4 mails for userA were corrputed and you did not take the PST so when you mount the database which haas information that userA has 6 mails in his mailbox and you connect Outlook to Exchange the OSt would sync with the Mailbox on the server and see that i only have 6 and delete the 4 mails that are not inthe mailbox on the server in Outlook cache mode .........

Remember what you see in cache is what  the contents are on the Mailbox on Exchange Server. so if Exchange mailbox has 5 OST would have 5 until you move a mail from PST to Outlook cache it would sync with the mailbox but if OST has 10 and mailbox has 5 then OST would go to 5 removing whats not in the mailbox

Author

Commented:
I can not see the system attendant mailbox.  
Could I use the dail tone restore option or will that have an issue once a new rand value has been created by repairing the database.
Expert of the Quarter 2009
Expert of the Year 2009

Commented:
Why can't you move the mailboxes to another database?
Your screenshots are from Exchange 2007, therefore you have multiple Exchange databases available to you. Up to 4 on the standard edition.
If the data appears to be working correctly then a move to another mailbox database using move mailbox would be the only option I would consider.

If the screenshots are showing an error on the move mailbox, then you need to post the text, because the resolution is too low. Exchange 2007 has an option to copy the error to the clipboard.

Simon.
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
In EMC you wont see the System Attendant Mailbox ..... you will have to run the command from EMS
Get-MailboxStatistics

Author

Commented:
Rancy - I have ran the command as advised and it did find a systemmailbox - appears to have found one per active database. (see pic)
Mestha - I tried again with same result (using EMC) the error did not give me the option to save the text - I have modified the screen shots (hope this is better)

systemmailbox.jpg
exchange-mailbox-move-error.jpg
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
The screen shot shows the System Mailbox and not System Attendant Mailbox

Author

Commented:
Here is the pasted results - I appear to have no attendant mailbox
DisplayName               ItemCou
-----------               -------
Despatch                  16
Gail Wakefield - Pyramid  1715
Products Ltd
Bruce Hunter - Pyramid Pr 4241
oducts Ltd
Tim Pearce - Pyramid Prod 983
ucts Ltd
Kevin Haywood - Pyramid P 3704
roducts Ltd
Ken Austin - Pyramid Prod 174
ucts Ltd
Info @ - Pyramid Products 28
 Ltd
Dan Hunter - Pyramid Prod 771
ucts Ltd
server admin              3
John Coram - Pyramid Prod 76
ucts Ltd
Quality @ - Pyramid Produ 2
cts Ltd
Claire Scott - Pyramid Pr 854
oducts Ltd
IT Manager @ - Pyramid Pr 166
oducts Ltd
Andrew Higgins - Pyramid  793
Products Ltd
Customerservice@ - Pyrami 10
d Products Ltd
Kevin Ball - Pyramid Prod 5657
ucts Ltd
Rob Higgins - Pyramid Pro 8283
ducts Ltd
Will Hodgson - Pyramid Pr 2203
oducts Ltd
Louise James - Pyramid Pr 1073
oducts Ltd
Qing Guo - Pyramid Produc 328
ts Ltd
Microsoft System Attendan 0
t
Orders @ - Pyramid Produc 8
ts Ltd
warehouse                 16
Brian Dooley - Pyramid Pr 7403
oducts Ltd
Michaela Philpott - Pyram 8741
id Products Ltd
Dexter Tyers - Pyramid Pr 101
oducts Ltd
Sales @ - Pyramid Product 90
s Ltd
Dave Wallis - Pyramid Pro 393
ducts Ltd
SystemMailbox{9EC5B82A-30 402
DA-45F8-9DAD-94F7C35A242B
}
test user                 9
Garry Cole - Pyramid Prod 5236
ucts Ltd
WARNING: The database 'SVR2\DB1\M
'svr2.pyramid.local' is not mount
WARNING: The database 'SVR2\Recov
accessed on server 'svr2.pyramid.
SystemMailbox{0BCFD3CB-57 402
B8-438C-BBE4-EA252032AF2C

Open in new window

Author

Commented:
I have now noticed that I can not get a specific mailbox using EMS
Ran:  get-mailbox (lists all mailboxes)
Ran:  get-mailbox -"dexter tyers" (or) get-mailbox -despatch (returns error relating to accessing domain controller.
could this be the system attendant causing this.
Another thought is that the domain controller had to be restarted last month.  The exchange server was not restarted or any services restarted - could this be my issue.  Is it becuase the exchange services need to be restarted after the domain controller has been restarted.  If this could be part of the issue please advise which services require restarting.
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
You have that at
41: Microsoft System Attendant 0

If you run
Get-Mailbox -Identity "Dave Wallis"
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
Also you can try with
Get-Mailbox -Identity "Email address"

Author

Commented:
All services are running and the required ones are set to automatic.
My mistake with the getmailbox command - I was not putting identity.
Expert of the Quarter 2009
Expert of the Year 2009

Commented:
CTRL-C copies the text to the clipboard.

The System Mailbox is created automatically. If you have more than one database then it could be elsewhere.
If you only have one database, create another one and then restart the information store. The system mailbox will then be created automatically in one of the database stores if the system detects that it is missing.

Simon.

Author

Commented:
Here are the results of the move mail box command through EMS
Rancy has pointed out that I DO have a system attendant mailbox - I did not think to look for Miscrosoft at the front of it.


[PS] C:\Documents and Settings\serveradmin>get-mailbox -identity "test user" | m
ove-mailbox -targetdatabase fstdb2
WARNING: An unexpected error has occurred and debug information is being
generated: Could not load file or assembly 'Interop.Migbase, Version=8.0.0.0,
Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies.
The system cannot find the file specified.
Move-Mailbox : Could not load file or assembly 'Interop.Migbase, Version=8.0.0.
0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies
. The system cannot find the file specified.
At line:1 char:49
+ get-mailbox -identity "test user" | move-mailbox  <<<< -targetdatabase fstdb2
[PS] C:\Documents and Settings\serveradmin>

Open in new window

Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
Hi Mestha,
we have both
41: Microsoft System Attendant 0
66: SystemMailbox{0BCFD3CB-57 402B8-438C-BBE4-EA252032AF2C
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
Try the move mailbox from EMC if not then run this command from EMS
Move-Mailbox -identity "Alias" -TargetMailbox "Server Name\Storage Group Name\Mailbox Database Name"
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
Just run
Get-Mailbox -identity "email address" and see if you get the information dump
Expert of the Quarter 2009
Expert of the Year 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I have just tried creating a new mailbox in a different database and could - then tried moving that mailbox to another database and same error -
The advise regarding Exchange and not the database seams correct.
I am at RU8 - can I just run SP2 and then RU8/9 afterwards.  If this can be done what then - this could have issues with my plugins (policy patrol)
Expert of the Quarter 2009
Expert of the Year 2009

Commented:
Rollups go in to the service pack. If you install Exchange 2007 SP2 then you do not have to install anything else, as there are no rollups for SP2 yet.

Simon.

Author

Commented:
I must be at SP1 | RU8 then - where can I check this.
Is their any known issues with SP2 - I have win server 2003 /65 - sp2
Expert of the Quarter 2009
Expert of the Year 2009

Commented:
The version is shown in EMC, under Server Config. It will say something like Version 8.2 (Build 176.2).
That is Exchange 2007 (8.0) SP2 (.2).

No problems with SP2 that I am aware of. As with most Exchange service packs it has been rock solid.

Simon.
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
SP2 has been much better compared to RU's so you can surely upgrade also can you copy the error in a notepad and share it with us ??

Author

Commented:
The move mailbox error is pasted in the code section somewhere above.
The backup error from event viewer is attached

error.txt
Manpreet SIngh KhatraSolutions Architect, Project Lead
CERTIFIED EXPERT
Top Expert 2013

Commented:
We might have to get it repaired nothing much as its going bad only also you will not be able to take any Online backups of the DB as of now ....
Expert of the Quarter 2009
Expert of the Year 2009

Commented:
Nothing in this question leads me to believe the database is corrupt. I think it is the Exchange binaries with the problem, which is why installing Exchange 2007 SP2 would be a good step, as it replaces the bulk of the binaries.

Simon.

Author

Commented:
I have also been chasing the possible cause of the crash before doing too much + bosses require strict planning on the steps.
Finally found that I may have tempromental write issue on a single drive in the raid array - now this drive has been removed I feel more confident continuing.
my plan (based on all info provided) is to:
1. file copy database to at least get a stable backup again.
2. install SP2 + test check functioanility
If this does not solve the issue we will cross that bridge then.
Dexter.

Author

Commented:
I installed SP2 with no issues.
The database still did not allow backup (same error)
I can however move mailboxes to another database.  I tested this new database for backup and restoration and it worked fine.
So I have started to move the rest of the mailboxes.
I will keep you informed.

Author

Commented:
Thanks guys.
I have now moved the mailboxes to another DB and it appears all ok.
The move mailboxes only worked after SP2 installed.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.