Troubleshooting: Unable to attach suspected or corrupted database

Revision as of 07:03, 21 February 2020 by LaySwan (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Question: When I tried to attach database file, the following message prompted:

Version: 1.8 / 1.9 / 2.0

Asdb1.png


Asdb2.png


Possible Reason:

Most likely the database has been marked as ‘Suspect’ by SQL Server, thus the database file was not added to SQL Server and failed to be attached.

Why would a database status be marked as ‘Suspect’? There are many reasons could lead to this, basically it was due to inconsistency of database probably caused by power failure during writing process or hardware failure …


Solution:

There is 2 ways you may attach your account books and perform DBCC checking.


Solution 1

1.1 Move the suspected database files (AED_ck2_Data.mdf and AED_ck2_Log.ldf) from C:\AutoCount Data to another location (e.g. C:\temp) …. this action is applicable only when the database has not been attached to SQL Server and currently located at C:\AutoCount Data)


Asdb3.png


1.2 Login into Microsoft SQL Server Management Studio


Asdb4.png


1.3 Right click at Databases and select on New Database


Asdb5.png


1.4 Fill the database name and click on OK.


Asdb6.png


1.5 Go to Control Panel > Administrative Tools > Services and stop the service of SQL Server (A2006), copy & replace the existing suspected database into C:\AutoCount Data


Asdb7.png


1.6 Start the service of SQL Server A2006.


Solution 2:


2.1 Refer to step 1.1


2.2 Create new account book using the same database file name as the suspected database (e.g. AED_ck2)

Go to File > Manage Account Book > Create Account Book, Next, Next, Next, Finish.


Asdb8.png


2.3 Refer to step 1.5

2.4 Refer to step 1.6


How to repair/rescue a Suspected database? Refer to topic Suspected Database at http://www.autocountsoft.com/products/ac_accounting/helpfile/AutoCountHelp.html?suspected_database.htm .


By: Peter@2013, CK 170711, KM 170920, P170920

Go to menu

  AutoCount Accounting 2.0


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations