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

From AutoCount Resource Center
Jump to navigation Jump to search
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
 
'''Question:''' Attach Database error message: 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.  
  
 +
<b>Version:</b> 1.8 / 1.9 / 2.0
  
 
[[File:Db not match1.png]]
 
[[File:Db not match1.png]]

Latest revision as of 09:15, 21 February 2020

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

Version: 1.8 / 1.9 / 2.0

Db not match1.png


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.


Db not match2.png


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.


Db not match3.png


2. Restore from the latest backup file.



By: CY 171130, KM 171204, P171206


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations