Updated On - 24 Jan 2019

Getting unmapped SQL error code 10038 when connecting to MS SQL

MS SQL Server Recovery

While trying to connect to MS SQL, you may get an error: “Unmapped SQL error code 10038 – Attempt to initiate new SQL server operation with results pending.” This SQL error code 10038 usually doesn’t affect the existing processes. But users find it difficult to connect to the server and create new processes. Whenever you…

Continue Reading →

Updated On - 30 Oct 2019

Recover Corrupt and Damaged MDF Files

MS SQL Server Recovery

Microsoft SQL Server, the most preferred database application by business organizations because of its high scalability, consistency, and familiarity with users. SQL database server stores millions of records whose size keeps increasing every day you work. Also, Microsoft’s SQL Server Management Studio (SSMS) is mostly used for managing database server where Non-UNICODE data types like…

Continue Reading →

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 - 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 →