Troubleshooting: Attach database error - One or more files do not match the primary file of the database

Question: Attach Database error message: One or more files do not match the primary file of the database.

Possible Reasons:

1. Your database log file (.ldf) does not match with your primary database file (.mdf).

• Database log file and primary database file usually come in a pair, if you try to attach them with the wrong pair, then you will encounter an error.

• E.g.: ‘A.mdf’ pair with ‘A.ldf’, ‘B.mdf’ pair with ‘B.ldf’. If you trying to attach ‘A.mdf’ with ‘B.ldf’, then you will have the error message as above.

2. Your database is corrupted.

• Either your primary database file is corrupted, or your database log file is corrupted.

Solution:

1. Attach the database with correct primary database file and database log file.

2. Restore from the latest backup file.

By: CY 171130, KM 171204, P171206

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations