Link to home
Start Free TrialLog in
Avatar of Rick Mills
Rick MillsFlag for United States of America

asked on

Business Contact Manager corrupt database

I have a client who uses Business Contact Manager.  The database resides on his PC and is shared with 2 other users.  He can't add a record because it reports that he's exceeded the maximum size of 4GB (SQL Express limitation).  However, the file size is 3.4GB.  
If I select Manage Databases / Check for Errors, it returns with a message there is a problem with the data file and we need to restore.  
The most recent backup is a couple days old and it would be painful to lose those couple of days worth of data.
Does anyone have any suggestions?
Avatar of 5g6tdcv4
5g6tdcv4
Flag of United States of America image

What version of SQL express?
Avatar of Rick Mills

ASKER

Sorry, I should have mentioned that.  2008.
I've restored copies of the MDF and LDF files back 2 weeks and I still get the error message telling me I need to restore.
Are there any other databases attached to SQL instance?
No.  BCM is the only SQL app on this computer.
ASKER CERTIFIED SOLUTION
Avatar of Sachin Parab
Sachin Parab
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial