Troubleshooting: Unable to attach suspected or corrupted database

From AutoCount Resource Center
Jump to navigation Jump to search

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


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

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