Data Recovery Blog

Archive for the ‘MS SQL Server Recovery’ Category

Whenever there is inconsistency with the password, the following error message is logged in the SDE error log after trying to start the ArcSDE service:

IDBInitialize::Initialize Failed

init_DB DB_instance_open_as_dba: -93

DBMS error code: 18456

Microsoft OLE DB Provider for SQL Server: Login failed for user ’sde’

Read the rest of this entry »

SQL Server is the most preferred relational database systems that enable organizations to reliably manage mission-critical information in easy manner. SQL Server offers many advantageous features to its users. One such feature is the use of file groups; this feature is used to group database files in order to provide better allocation and database administration.

With this useful feature of filegrouping, a database administrator can assign indexes, tables or image, text or ntext data from a particular table to the specified file group. But sometimes, SQL Server shows the invalid state of a specific filegroup .As a result, it fails to process the table for check.  Such situation is an indication of sever table corruption.

Read the rest of this entry »

MS SQL Server is a fast, powerful and reliable relational database management system used for storing any kind of data. But sometimes installation of this useful application gets corrupt and results in to following error message:

“Windows could not start the SQL Server ([myinstancename]) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 10022.”

Read the rest of this entry »

SQL Server is the most reliable, fast and effective relational database management system specially designed for the enterprise environment. This application efficiently manages the enterprise data in the 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 unexpected shutdown, application errors, hardware bugs and other similar faults, SQL server results into DBCC CHECKDB errors and thereby leading to inaccessibility of table data.

If there is some issue with the table, then the following error message can display:

Server: Msg 8942, Level 16, State 1
Table error: Object ID O_ID, index ID I_ID, page P_ID. Test (TEST) failed. Slot S_ID, offset 0xADDRESS overlaps with the prior row.

Read the rest of this entry »

While using SQL Server for your storage needs, you may encounter one of the most common error:

“Unmapped SQL error code 10038 – Attempt to initiate new SQL server operation with results pending”.

Read the rest of this entry »

“The system cannot self repair this error” is the common SQL error message that pops-up quite often. Reason for this error message is primarily due to corrupt metadata in SQL database file, corruptions in system base tables, Page Free Space (PFS) page damage and/or hardware failure.

Read the rest of this entry »