Updated On - 23 Jul 2018

Table Corrupt: Object ID 0, index ID 0, page ID (1:623). PageId in the page header = (0:0)

MS SQL Server Recovery

The DBCC DBREINDEX is a transactional-SQL command that reconstructs one or more indexes for a table in the SQL database file. Additionally, DBCC SHRINKDATABASE is a T-SQL command used to shrink the size of the data and register files in the particular database. In case both these commands are executed at the same time on…

Continue Reading →

Updated On - 25 Jan 2019

Recover Data from a Damaged Database Table in Microsoft Access

MS Access Database Repair

Microsoft Access is a database utility provided by Microsoft Corporation as a part of the Microsoft Office Suite. Because of its easy-to-use and self-descriptive interface, both home users and professionals take its advantage as a backend to store data. However, sometimes while executing a query or a report or updating records, you may encounter the…

Continue Reading →

Updated On - 20 Mar 2019

Recover from a corrupted transaction log file

MS SQL Server Recovery

MS SQL Server is the most ordinarily used database client, can be subjected to corruption due to various logical and physical reasons. Let us suppose a situation when you are informed that one of the transaction log file has been corrupt due to some unknown reasons. Because of the transaction log file damage, SQL Server…

Continue Reading →

Updated On - 24 Jan 2019

Corruption due to table partition error in SQL Server 2005

Database Recovery, MS SQL Server Recovery

Microsoft SQL Server 2005 is designed with exceptional features of table partitioning with which you can utilize to enhance the performance of large databases as these partitioned tables are flexible and easy to maintain. DBCC CHECKTABLE command is used to keep a check at the consistency of these partitioned tables and therefore when a user…

Continue Reading →

Updated On - 23 Jul 2018

How to Resolve SQL Server Error 2515?

MS SQL Server Recovery

Backup is the key to perform recovery of database objects after the corruption of database file. SQL Server provides you with a number, Log Sequence Number (LSN), which during the process of database restoration is used as a recovery point. LSN also helps you perform differential backup. When you perform differential backup, a bitmap corresponding…

Continue Reading →