Completed Offline Defrag of exchange 2003 db

FattyPo
FattyPo used Ask the Experts™
on
I have completed an offline defragementation of the exchange db which has cleaned out 20GB of white space.

This has all worked, how do i know go about replacing the current 65GB priv1.edb with the new tempcfg.edb database?

Do i just delete the current DB (i have a back) and cut and paste the new DB and rename it?

Many thanks

David
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Awarded 2009
Top Expert 2010
Commented:
If you have the space I would rename the current DB to priv1old.edb then rename the temporary file to priv1.edb and place it in the correct location.
Awarded 2009
Top Expert 2010

Commented:
That way if there is a problem toucan just rename the original back and you can still provide service.
Mark DamenERP System Manager

Commented:
When I do an offline defrag, it copies the temp DB back into the correct place automatically - have you checked that this has not already happened, and also did it error out?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Awarded 2009
Top Expert 2010

Commented:
It can defrag to a specific temp file if you tell it to, this will not copy back automatically
Awarded 2009
Top Expert 2010
Commented:
See here: http://support.microsoft.com/kb/192185 

Last command on the page
Mark DamenERP System Manager

Commented:
Reading that MS article confirms what I said, it would only leave the temporary one separate and the original in place if you used the additon /p switch.  Otherwise it copies the temp db over the original - I normally use the /t option to redirect to another partition with much more space.

Try leave the /p in future.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial