Solved

Exchange 2010 DB in Dirty Shutdown after deleting transaction logs

Posted on 2012-03-31
4
1,322 Views
Last Modified: 2012-04-16
Hi,

I made a bit of a noob error last night. I was moving a load of mailboxes over from a database on hard drive 1 which was pretty much full to a new DB on an empty Hard drive, HDD 2.

I all of a sudden saw that HDD 2 had pretty much zero free space, it had generated nearly 60GB of transaction log files. I didn't have time for a backup and it appeared the database had dismounted. I didn't look at the event log and on auto pilot I just started deleting the transaction logs and tried to remount the DB.

I then found the DB was in a dirty shutdown state and eseutil /mh had a jet error of missing transaction logs. Oops.

I quickly started trying to recover the transaction logs, and I have managed to get about 4/5ths of them back, but eseutil /mh still complains of log files missing, which is no real surprise.

I am currently trying eseutil /p on a copy of the DB to see what kind of data loss I'm looking at, I do not have a backup so please don't go there - the mailboxes were being moved in a live environment so there would be mails lost from during the working day if I reverted to an old DB from HDD1.

Is there any way I can limit the damage by taking advantage of what log files I DO have? The thing that really worries me is one of our big, very important mailboxes was in the middle of a move when this happened, and the move request is still marked as "moving". Does anyone know what might happen to this?

Thanks in advance.

PS the box is exchange 2010 SP1 and 2008 R2 standard.
0
Comment
Question by:shiversaint
4 Comments
 
LVL 3

Assisted Solution

by:Padamdeep
Padamdeep earned 167 total points
ID: 37791027
1. If you have DAG then you can look at other copy of database and see if you can bring it to consistent state.

2. If you don't have DAG and this was the only Database and you have deleted some of the required log files then you can't do anything. You can't commit log files partially.

3. If you have all the log files from the time since this Database was created. You can create a New DB from those log files and make use of all the log files which are present as long as those are in sequence.

Regarding your move mailbox query:

Look at the move mailbox logs to see it has rolled back everything or what status it has been failed with.

~ Singh
0
 
LVL 1

Assisted Solution

by:it_david_glover
it_david_glover earned 167 total points
ID: 37791204
If the transaction logs you removed have already been committed to the database then you can try a soft recovery.  This will replay the transaction logs and get you back to a clean shutdown state.

An example soft recovery command I've used is: eseutil /r "E06" /l "D:" /d "D:"

Step by step:  http://www.mikepfeiffer.net/2010/04/getting-an-exchange-database-into-a-clean-shutdown-state-using-eseutil/

I've had a good luck with this and haven't needed to run the hard recovery which will result in data loss.

Let us know how it goes.

David
0
 
LVL 18

Accepted Solution

by:
suriyaehnop earned 166 total points
ID: 37793462
If haven't not be lucky enough when running soft recovery. Everytime this problem happened, I end up with :

E:\Program Files\Exchsrvr\Bin>eseutil /p “directory for DB"

This process will take long time, so if you have a DAG, please use the passive node
0
 

Author Comment

by:shiversaint
ID: 37850949
In the end I had to do a Hard Recovery, which took approximately 30 minutes and there was no data loss. Crisis averted. Thanks all.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Join & Write a Comment

OfficeMate Freezes on login or does not load after login credentials are input.
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now