Troubleshooting: Attach database error - One or more files do not match the primary file of the database: Difference between revisions
(Created page with "'''Question:''' Attach Database error message: One or more files do not match the primary file of the database. File:Db not match1.png <u><b>Possible Reasons:</b></u>...") |
No edit summary |
||
Line 37: | Line 37: | ||
By: CY 171130, KM 171204, P171206 |
By: CY 171130, KM 171204, P171206 |
||
+ | {{NavigateForUser}} |
||
− | |||
− | <span style='color:red'> |
Revision as of 09:37, 6 December 2017
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
AutoCount Accounting 2.0 & 2.1
|
AutoCount Accounting 1.8 / 1.9
|
![]() |
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
![]() |
AutoCount Accounting Plug-In Documentations
|