Suspected Database |
Top Previous Next |
Question: When login to an account book, the following message prompted:
Answer:
This message is prompted for a few possible reasons, two of the most likely reasons are: 1. The database has not been attached to SQL Server, OR more accurately, has been detached from SQL Server.) (Refer to Cannot open database.) 2. The database attached to SQL Sever has been marked as 'Suspect' by SQL Server. Note: To determine if a database status is marked as Suspect, take a look at the name of database at Microsoft SQL Server Management Studio Express...(also refer to Unable to attach suspected database)
The following steps are recommended to repair a Suspect database (that are recoverable).
Note: there are 2 more modes of repair that can be used in certain occasions that involved only minor errors or and re-indexing: (1) DBCC CHECKDB (‘databasename’, REPAIR_FAST) -- used to perform minor, non time-consuming repair actions such as repairing extra keys in non-clustered indexes. These repairs can be done quickly and without risk of data loss. (2) DBCC CHECKDB (‘databasename’, REPAIR_REBUILD) -- to perform all repairs done by REPAIR_FAST and includes time-consuming repairs such as rebuilding indexes. These repairs can be done without risk of data loss.
Note: Please take note that if the database is badly damaged, some errors may persist even after few round of checking and fixing. In such cases, the recovery process will become more complicated and unassured.
____________________________________________________________ Send feedback about this topic to AutoCount. peter@autocountSoft.com © 2013 Auto Count Sdn Bhd - Peter Tan. All rights reserved.
|