Exchange 2003 Unable to - An attempt to open the compressed file "D:\Mailboxes\Mailbox Database.edb" for read / write access failed because it could not be converted to a normal file.

Somehow during the clean up for the drive that hosts the mailbox.edb file, it became compressed.  I've tried using the command line- compact /u /s command to decompress it as well as going into the advanced properties and unchecking 'Compress contents to save disk space' on the file- however neither techniques not seem to apply or remove the compression attribute.  The file is still blue and has a 'C' in the attribute column.  If i open the advance attributes the check is back in the box.  I've rebooted and attempted these two techniques a few times without success.

MSExchangeIS (2536) First Storage Group: An attempt to open the compressed file "D:\Mailboxes\Mailbox Database.edb" for read / write access failed because it could not be converted to a normal file.  The open file operation will fail with error -4005 (0xfffff05b).  To prevent this error in the future you can manually decompress the file and change the compression state of the containing folder to uncompressed.  Writing to this file when it is compressed is not supported.

Obviously all users are unable to connect to the exchange server to send/receive email.
Help!
Dez99Asked:
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.

piattndCommented:
I think you posted a double question, but remove compression from the folder containing the database file first, then remove compression from the file.
0
Dez99Author Commented:
The folder containing the file does not have compression enabled.
0
Red-KingIT ManagerCommented:
First stop all Exchange services and try the uncompress operation again. Exchange may have a lock on the file/folder preventing it from completing the uncompress operation.

If that doesn't work you can try this slightly more complicated attempt.

If you have an uncompressed disk available that you can copy the .edb file to you can try moving it there.

1. Take a backup copy of the database to another location
2. Dismount the database in Exchange System Manager
3. Create a folder where you are going to copy the file to and make sure it has these permissions:
Administrators: Full Control
Authenticated Users: Read and Execute, List Folder Contents, Read
Creator Owner: None
Server Operators: Modify, Read and Execute, List Folder Contents, Read, Write
System: Full Control
4. Copy the file to the new location (I'd use robocopy)
5. Ensure the file is not compressed in the new location by checking it's properties
6. Rename the .edb file in the original location (to make sure exchange can't find it and doesn't try to copy it over the new file you've created)
7. In Exchange System Manager right-click on the Mailbox Datastore and select 'properties'.
8. Select the database tab and next to the database you want to move click the browse button.
9. Select the new location for the database file.
10. Mount the database and watch the event viewer for any errors.

To Rollback;
Restore the backup copy of the database to the original location using the same filename as was used originally.
Mount the database if possible (i.e. it's no longer compressed).

Here's a MS reference about moving exchange databases and logs;
http://support.microsoft.com/kb/821915
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Dez99Author Commented:
I have tried stopping all services and and applying both the techniques I mentioned.

The DB is 54 - GB so moving the database is going take, but I will try it. Thank you Red-King I will post back after trying your advice.
0
Red-KingIT ManagerCommented:
Hi Dez99, have you had any luck mounting the database?
0
Dez99Author Commented:
What I ended up having success with was this

I connected an external USB HD to the Exchange server
Using the Exchange Management Console- Used the 'Move Database Path' of the First Storage Group - and selected a location on the external USB drive (F:).  When Exchange copied the database it removed the compressed that the disk cleanup process had put on it (just as windows does when you copy a compressed file to a new location)
After the Move DataBase path had completed, I restarted exchange and received an ESE error in the event log stating

MSExchangeIS (2028) First Storage Group: Error -1811 (0xfffff8ed) occurred while opening logfile D:\Mailboxes\Logs\E00.log.

This log file had been placed on the F: drive where the Database was now residing.
I copied this file to the D:\Mailboxes\Logs\ location and then restarted Microsoft Exchange Information and all was well-  including the mounted database at full functionality.
0
Dez99Author Commented:
What I ended up having success with was this

I connected an external USB HD to the Exchange server
Using the Exchange Management Console- Used the 'Move Database Path' of the First Storage Group - and selected a location on the external USB drive (F:).  When Exchange copied the database it removed the compression that the disk cleanup process had put on it (just as windows does when you copy a compressed file to a new location)
After the Move DataBase path had completed, I restarted exchange and received an ESE error in the event log stating

MSExchangeIS (2028) First Storage Group: Error -1811 (0xfffff8ed) occurred while opening logfile D:\Mailboxes\Logs\E00.log.

This log file had been placed on the F: drive where the Database was now residing.
I copied this file to the D:\Mailboxes\Logs\ location and then restarted Microsoft Exchange Information and all was well-  including the mounted database at full functionalty.
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.