Rick Mills
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?
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?
What version of SQL express?
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.
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?
ASKER
No. BCM is the only SQL app on this computer.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.