Tag: SQL Server Recovery

Error: SQL Server – Error starting esri_sde service -93 DBMS error code: 18456

MS SQL Server Recovery, by

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

Continue reading

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

MS SQL Server Recovery, by

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

Continue reading

Getting unmapped SQL error code 10038 when connecting to MS SQL

MS SQL Server Recovery, by

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". (more…)

Continue reading

The system cannot self repair this error

MS SQL Server Recovery, by

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

Continue reading

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

MS SQL Server Recovery, by

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

Continue reading

Corruption due to table partition error in SQL Server 2005

Database Recovery, MS SQL Server Recovery, by

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

Continue reading