September 10, 2009

Windows could not start the SQL Server – SQL Error- 10022

MS SQL Server Recovery

MS SQL Server is the most powerful, reliable and quick RDBMS (Relational Database Management System) which is used for storing data in the form of tables. But sometimes installation of this useful application is unsuccessful and results into following error message: “Windows could not start the SQL Server ([myinstancename]) on Local Computer. For more information,…

Continue Reading →

September 8, 2009

Resolving SQL Server Error 8942

MS SQL Server Recovery

SQL Server, the best RDBMS that is highly result-oriented and trusted by IT organization. It is capable of handling crucial business data in form of tables. Whenever you need to access the data stored in the SQL tables, you need to run queries for getting the desired information. But sometimes due to improper handling and…

Continue Reading →

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 →

August 28, 2009

Can not Find File: .myi – Mysql Error and Recovery

MySQL Recovery

MySQL uses MyISAM as the default storage engine, which is based on older ISAM code but comprises many useful extensions. The MyISAM comprises three files having extensions- .frm, .MYI, and .MYD that are used to properly store the data. The MYI extension in MyISAM storage engine stands for MyIndex and refers to the index file…

Continue Reading →

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 →

August 27, 2009

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 →

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 →

August 18, 2009

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 →

August 17, 2009

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 →

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 →