Exchange 2010 DB in Dirty Shutdown after deleting transaction logs

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.
shiversaintAsked:
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.

PadamdeepCommented:
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
it_david_gloverCommented:
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
suriyaehnopCommented:
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

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
shiversaintAuthor Commented:
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
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.