Archive for category Data Recovery
SQL Database Recovery Post Table Corruption
Posted by admin in Data Recovery on May 3, 2011
By Gaurav Kr
A table in MS SQL database is a group of specified number of rows and columns which contain major chunk of records. A DBA can fetch the required records as per his/her requirements from any table, by running a query. A database query while in most cases displays desirable results, might fail due to various reasons. One of the most common factors for failure is corruption of table. Few known factors for table corruption are improper system shutdown, metadata structure corruption, application failure, and virus attack. In most cases of query execution failure, an error message gets displayed on the monitor. This error message comprises of all necessary information that helps a DBA to identify the level of corruption and the way to overcome it. However, if in case a DBA is unable to understand the error message and has no backup of database, then SQL database recovery becomes a little difficult.
To explain the above error message, here is a real-time scenario. A user wants to count the number of rows of table for which he executes count(*) query. But, the query instead of displaying the total number displays the below error message:
“Attempt to fetch logical page (1:42724) in database ‘test’ belongs to object ‘report-table’, not to object ‘RRR’. Connection Broken..”
Understanding that the table is corrupted, the user tries DBCC Checktable command with repair_rebuild parameter to know the level of corruption. The command displays the below result:
“Server: Msg 2535, Level 16, State 1, Line 1
Table Corrupt: Page (1:42724) is allocated to object ID 1517248460, index ID 0, not to object ID 982294559, index ID 0 found in page header.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1517248460, index ID 0: Page (1:42723) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table Corrupt: Object ID 1517248460, index ID 0, page (1:42723). Test (m_freeCnt == freeCnt) failed. Values are 1468 and 8066.
Server: Msg 8939, Level 16, State 1, Line 1
Table Corrupt: Object ID 1517248460, index ID 0, page (1:42723). Test (emptySlotCnt == 0) failed. Values are 15 and 0………” Read the rest of this entry »
Today’s Digital File Cabinets: The Downfall of Convenience
Posted by admin in Data Recovery on May 3, 2011
By Zach Martinez
Take a moment and look around your desk or office, how many documents, files and papers are lying around? Is the surface of that desk nice and tidy? or has it been eons since it saw the light of day? Trees everywhere are silently rejoicing while the world quickly makes a paradigm shift into the portable digital storage device era.
Words like “archive” and “file cabinet” have been replaced by “download” and “thumb drive”. The utter convenience of being able to write those cover-sheets for everyone’s favorite TPS reports and immediately drop them onto a tiny USB drive saves time and space. Unfortunately your favorite red stapler might be feeling neglected while gathering dust somewhere.
While USB thumb drives undoubtedly are the digital file cabinets of today, these little devices can pose a problem of their own. Without a physical copy of everything contained in a thumb drive, or a back-up copy saved elsewhere, there is a very real risk of losing everything. Storage devices aren’t 100% reliable, not by a long shot; no matter how careful someone is, these things can break, crack, fall apart, or even seemingly stop working for no apparent reason. A couple of the most common errors for USB thumb drives are error messages that say “this device could not be recognized” -or- “this device needs to be formatted.” When it comes to the latter of the two messages, NEVER under any circumstance format a device if it has valuable data on it; this causes everything on the drive to be permanently irretrievable.
Thankfully, during society’s transition to digital storage devices, the data recovery industry as emerged. To put it simply, data recovery companies have special tools/hardware, software programs, and techniques they use to pull the information off of various storage devices in order to retrieve files that would otherwise be considered lost. Data recovery companies are not the average computer repair shop, in a sense they almost do the opposite; most of the time the device must be destroyed in order to retrieve the data held within.
It can be hard to find a good data recovery company where one would feel safe sending their precious little USB drive. This is especially made true considering data loss is frequently followed by a state of mind-blurring panic.
Here’s a few tips for finding the right company.
The best place to go for data recovery service is the place with the most experience. Thankfully the internet allows us to see details about a particular website and/or company, making it easier to sort out the newbies from the veterans. Its generally safe to say a company that has been in business for over 5 years has a good understanding of their industry. Read the rest of this entry »