Tuesday, June 7, 2011

PST Recovery Tips for CRC Error

A PST (Personal Storage Folder) can be termed as Microsoft Outlook‘s prime repository of data. The file consists of information like, received and sent emails, notes, calendar, contacts, and many more. Thus, one can easily understand the impact of losing data because of PST corruption. An Outlook user might encounter numerous of such instances while using Outlook. This article briefly explains one of such instances.

Below is an error message that an Outlook user might receive while downloading emails:

“File path\filename.pst could not be accessed. Data error. Cyclic redundancy check.”

As mentioned once, this error occurs because of PST file corruption, but let me explain the exact case.

The Cyclic Redundancy Check usually appears when application finds a mismatch between the exact and calculated value of checksum value stored in the file. Now, what is checksum? A checksum (also called, hash sum) is the fixed-size datum calculated using a random block of data in the file. The purpose of defining the checksum is to detect errors that may have been introduced during file transfer or storage, just as in the case above.

How to repair a corrupted PST?

In order to repair your corrupted PST, you can use any of the given solutions:

Inbox Repair Tool: This tool is automatically installed with Outlook’s installation. To launch this tool, you need to search for ‘scanpst.exe’ file and double-click it. Next, you will need to enter the location of corrupted PST, its name and proceed as it instructs.

Third-party PST Recovery Applications: These tools are available with high-end scanning capabilities for a corrupted PST. You can search for these PST Repair and Recovery applications on Internet and download the demo version for a trial. To be careful about your data, I’ll advice you to backup it before trying any of such tools.

Sunday, June 5, 2011

QuickBooks recovery post “This is not a QuickBooks data file or is damaged” Error


QuickBooks accounting software is undoubtedly one of the most commonly used accounting application to provide double-entry accounting functions, full audit trail capabilities, and more facilities. The repository of records maintained by this software is saved in a file with .QBW extension. This file, like any other file in the computer can be corrupted due to various logical reasons, such as, improper system shutdown, application malfunction, and virus attack. In most of these situations, the QBW file becomes unreadable, resulting into inaccessibility of the critical accounting records. In such situations, if an accounting professional has a backup of the QBW file, then there is no need to worry. However, if in case, the professional does not have the backup or the backup file is itself corrupted, then s/he needs to opt for effective third-party Intuit QuickBooks recovery software.

Most users encounter below two error messages when there QBW file gets corrupted due to logical reasons:
“This is not a QuickBooks data file or is damaged”

Or

“An error occurred when QuickBooks tried to access the company file.”

Appearance of any of the above error messages on the computer’s screen results into inaccessibility of file records. 

Resolution:

To recover the above error messages, easily and completely, follow the below mentioned steps:
· Perform restoration from an updated backup. (Note: Always save the backup file on some other storage media to ensure safety)
· In case of backup file unavailability or inaccessibility, use powerful Intuit QuickBooks recovery software.

Data Recovery Information

A third-party party Intuit QuickBooks recovery application performs complete scan on the QBW file, repairs it, recovers all the records, and restores them at user-specified location. Such party Intuit QuickBooks recovery tools are extremely safe as they do not harm the original file, since the repairing is performed on the copy of the original file. Furthermore, these recovery tools do not require any technical knowledge and can be used by any non-technical user. 

Applied For:

QuickBooks 2007, 2008, 2009, and 2010 (US version)

Friday, April 29, 2011

System Table corruption renders to “All system tables must be in....” Error

Whenever a DBA creates any MS SQL object (be it a table, view, report, form, etc.), its properties (metadata) are saved in System Tables. These system tables are primarily used to discover differences and similarities between tables and columns at the time of database upgrade, view performance statistics, and collect lock information. These tables are hidden and even with full DBA access rights, remain restricted. (This is because if a DBA changes the location of any of these tables then the database becomes unmountable). While nothing can change the location of system tables, logical damage in MS SQL Server database can. In such cases, the DBA needs to perform restoration from an updated online or offline backup. But, if in case the database backup is unavailable, then the DBA can execute DBCC CHECKDB command to repair the database. The command, while successful in most cases, can fail under many situations, like severe database damage. For such scenarios, the DBA needs to opt for an effective MDF recovery application.

To elaborate the above case, consider the below error message that appears when a MS SQL Server DBA attempts to mount his/her database:

“System table 'OBJNAME' (object ID O_ID, index ID I_ID) is in filegroup FG_ID1. All system tables must be in filegroup FG_ID2. ”

Read More: http://sqldatabaserepair.blogspot.com/2011/04/system-table-corruption-renders-to-all.html

Wednesday, April 13, 2011

MS Access Database Behaving Abruptly

There are many situations where you might see your MS Access database behaving in an abnormal manner. Few of the unexpected behaviour situations could be missing of database table records, strange and repetitive error messages, inaccessible database components (forms, reports, etc), or slow execution of commands. Some common reasons behind abrupt behaviour of MS Access database could be application related issues, system problems, database corruption, and virus infection.


To bring the database back into normal state and access all the records, an easy way is to restore the database from an updated backup. But, if in case restoration of database fails and the database file remains in corrupted state, then the user needs to opt for a third-party Access database recovery application.

For detailed illustration of the above scenario, below are some database corruption error messages after which the database either stops working completely or behaves abruptly:

“Unexpected Error 35012”
“Visual Basic for Applications Project in This Database Is Corrupt”
“Unexpected data corruption failure”
Cause:
Access database file damage.

Access Repair Techniques:

To repair any logically damaged Access database file, there is an inbuilt utility named “Compact and Repair”. Using this utility does not any technical expertise, but the user needs to follow the underneath steps:
  1. Click on 'Tools' button and opt for 'Compact and Repair Database'.
  2. Choose 'Database to Compact From' option and select 'Compact'.
  3. Once you select Compact, repair process starts.
  4. When the repair process gets finished, you will need to click on 'Save'.
While the inbuilt repair utility provides desired results in most cases, it fails in many scenarios. For such situations, you will need to search for effective Access Repair tool.

Access Repair Tool Information:

An Access repair application is a reliable source of repairing any logically damaged ACCDB or MDB file. Such Access database repair tools are totally non-destructive and do not provide any harm to original database file. Compatible with almost all latest versions of Windows operating systems, these tools are competent enough to recover almost all database objects like, tables, forms, reports, and more.

Applied For:

Access 2002, 2003, 2007, and 2010

Thursday, April 7, 2011

Identifying and Resolving MySQL Database Corruption


For a MySQL database administrator, a database corruption error might sound as if “the disaster has occurred”. The administrator rattles off typical suspects and applies all his knowledge and experience to overcome the disaster. However, in most cases, the corruption remains inescapable and the result is – database unmountability or strange behaviour of database. In such situations, a complete online backup acts as a boon and allows the administrator to mount and access the database objects. But, the disastrous situation might continue if the administrator has not maintained any backup or the backup file gets corrupted. For such situations, it is advisable to opt for a third-party MySQL database recovery application that provides complete repair of corrupted MySQL database.

Some common error messages that help a MySQL database administrator to identify that his MySQL database is corrupted are listed below:
  • 126: Index file is crashed / Wrong file format
  • 127: Record file is crashed
  • 132: Old database file
  • 134: Record was already deleted (or record file crashed)
  • 135: No more room in record file
  • 136: No more room in index file
  • 141: Duplicate unique key or constraint on write or update
  • 144: Table is crashed and last repair failed
  • 145: Tables was marked as crashed and should be repaired
Cause:

Few common ways by which MySQL database corruption occurs are killing MySQLD process in between, improper system shutdown, MySQL bug, and hardware failure.

Resolution:

To overcome the above error messages, the administrator needs to follow the below steps:
  • Run CHECK TABLE command to identify the level of corruption.
  • Run REPAIR TABLE command to repair the corrupt table.
In case the above steps fail to repair the database, then the user needs to find a good third-party MySQL repair application.

MySQL database repair tool information:

A MySQL recovery software is a permanent solution to repair corrupted MySQL database. The utility not only repairs and recovers all MySQL database components, but also restores them at user-specified location. The MySQL repair tool is easy understandable and does not require any prior technical knowledge.

Applied for:
MySQL 5.x

Monday, April 4, 2011

How to Solve ‘Client Error: 0x80040600’ in Microsoft Outlook?


You must have encountered several situations while working with MS Outlook, when it quits abruptly or behaves peculiarly. It can happen while launching or accessing the application, when it becomes quite a hassle to view e-mail messages and other information. In the worst scenario, this can occur because of corruption in Outlook data file – PST. 

To Repair PST data, it is necessary that you use an effective solution. But before we discuss it, take a look at one of the common error messages:

"Client Error: 0x80040600"

Most of the users complain that they receive this error message while trying to apply few policies that put the PST file in update or replace mode in Outlook. 

Fixing the Issue

To repair your corrupted PST, you need to run Inbox Repair Tool (Scanpst.exe). In order to locate the file, follow the steps outlined in any of the below methods:

Method 1:

Navigate to this path using Windows Explorer:
%PROGRAMFILES%\Common Files\System\MSMAPI\LocaleID (which is 1033 for the USA or similar)

Method 2:
  1. Click Start > Search > Files or Folders
  2. Type scanpst.exe and click Search Now
After you locate the file, open it and click Browse to select your current PST file. Click Start to initiate the recovery process. The tool starts scanning the file for errors and generates a scan report. Click Repair to repair the file. Outlook doesn’t affect the original PST, but instead creates a Recovered version of the file. To start using this version, you need to set up this version as your default PST.

More Information

If Outlook has not been able to Recover PST file, you need a third-party product. A PST Recovery software is programmed to scan a corrupted PST using the most effective algorithms. Using PST Repair products is easy as they are equipped with interactive user interface. Also, they do not harm the original integrity of the file. 

Applies to
  • Microsoft Office Outlook 2003
  • Microsoft Office Outlook 2002
  • Microsoft Office Outlook 2000

Thursday, March 3, 2011

How to Solve ‘This is a corrupted or damaged QuickBooks database’ Error?


Intuit QuickBooks is often used in multi-user and networked environment and so, results in frequent errors. To add, the lack of resilience in its conventional database format, .QBW file, makes it difficult to determine the file corruption. Quite often, the files are corrupted much before they are detected by QuickBooks. Following the occurrence of error message, such situations generally require an easy-to-apply QuickBooks File Recovery solution.

As an example, you might encounter the below error message while trying to open/access a QuickBooks database:

“This is a corrupted or damaged QuickBooks database”

In order to solve such issues, refer to next section.

Fixing the Issue

These errors can sometimes appear because of a network or drive issue and not because of corruption with file itself. To confirm, you should run the Verify Data utility, which is available in ‘File’ menu. Make sure you click on ‘Close Company/Logoff’ first. In case of corruption issues, QuickBooks reports ‘Data has lost integrity’ message. If you get this message, continue to repair the file.

To repair the file, you need to run Rebuild. But before running this utility, you are suggested to consider these points:
  1. If the file is stored on a networked drive, copy it to a local drive
  2. Make sure that no items (Customer Names, Account, etc.) are hidden
You can now run the Rebuild utility. It is available in ‘File’ menu. The utility prompts you to backup the affected file.

After running the Rebuild, you need to rerun the Verify Data utility. However, it should be performed post renaming the QuickBooks log (QBWIN.LOG) file. This file is located in installation folder of QuickBooks. 


Since .QBW is a poorly designed database format, you might end up with no success repairing the file using Rebuild. In such situations, it is advised to switch to third-party QuickBooks Recovery tools. Designed to run powerful, safe, and high-end scanning algorithms, these QuickBooks File Recovery solutions work as a one-hit solution to all .QBW file corruption problems.

Applies to
  • Intuit QuickBooks 2010
  • Intuit QuickBooks 2009
  • Intuit QuickBooks 2008
  • Intuit QuickBooks 2007