Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 48
  • Last Modified:

Exchange 2010 - EDB defrag stuck, cancelled and now the DB wont mount

Dear EE

Please can someone assist me.

So, as per the title, I was defragging an EDB. It was stuck on the last part for a few hours...."moving the temp.edb to replace original edb"

After a quick google I endded the task via CTRL + C.

Now the DB wont mount.

I still got the temp.edb file it created.

Any ideas??
0
TTAF4
Asked:
TTAF4
  • 3
  • 3
  • 2
  • +4
7 Solutions
 
AndyIt ConsultantCommented:
What's the error you get when you are trying to mount the DB?

Do you have a backup of the original as you may have corrupted it by ctrl-c?
I would restore from a backup if you have one.
1
 
TTAF4Author Commented:
no backups. this is a client of mine.
0
 
AndyIt ConsultantCommented:
"Never" offline defrag a single DB without a backup!!!

OK, what error do you get?
Is it in a DAG? If it is, remove the failed database copy, delete any files and recreate the database copy.
1
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
Ajit SinghCommented:
As above suggested, be sure to make a copy to another machine before doing offline defrag. Also look into your System and Application Event logs on the Exchange server to see if there have been any critical or warning errors occurring.

using eseutil /ml to figure out what log file is damaged, then deleting it, then trying to mount. Here is an article which lets you how to use the Eseutil function to restore Exchange databases: http://blog.technotesdesk.com/how-to-use-the-eseutil-function-to-restore-exchange-databases/

If the log files are healthy, then perform the Soft recovery with the command Eseutil /r <Log Prefix> /l “Path of the log files” /d “Path of the database”.

Hope this helps!
1
 
Viral RathodConsultantCommented:
Database is clean shutdown or dirty shutdown.

Please run eseutil/mh and post the results.
1
 
AmitIT ArchitectCommented:
I don't see you have much option left, apart from creating dial-tone and restoring data from backup. If no backup, update customer db is lost and cannot be recovered any more. Or you can try out 3rd party tools for edb to pst.
1
 
Viral RathodConsultantCommented:
1
 
Viral RathodConsultantCommented:
If database is dirty shutdown then you need to take the backup and repairs the database.

Do not do anything else first post the results of eseutil /mh
1
 
suriyaehnopCommented:
I believe your db is dirty shutdown that why you won't able t mount it. Run eseutil /mh "path of database"

1. Run soft recovery to clean the db. Restore the log file from latest tape backup

Eseutil /r "E0n" /d <database path> /l <db log path>

2. If soft recovery failed. Run hard repair. Process will take long time. My last hard repair took about 8 hours to complete

Eseutil /p <database path>
1
 
Tej Pratap Shukla ~DexterCommented:
Hi,
Go for repairing the EDB file using ESEUTIL Comands. If after recovering (Soft/Hard) the file successfully then try to mount the file into the Exchange server.
If ESEUTIL commands is not working in your case, then you have to go with any third party tool to recover corrupt Exchange database. I know some popular tool which you could try by downloading its demo version:
- SysTools Exchange Recovery
- PCVITA EDB to PST Converter
- Recovery Tools For Exchange Server

There are many other tools also available in the market, which you can explore by googleness.
1
 
TTAF4Author Commented:
wow thank you all for the many suggestions.

this i what i did to resolve this issue.

i deleted the original db. copied the temp.edb to the original location.

gave it the original name and mounted.

worked like a charm.
0
 
AmitIT ArchitectCommented:
Great it worked in your case. However, going forward avoid using ctrl + c let defrag get completed by its own. Defrag can take long time to complete. Nearly 4GB per hour.
0
 
TTAF4Author Commented:
this is what fixed the problem
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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