Corruption in MS SQL database can occur due to numerous reasons. Problems like software malfunctioning, untimely execution of SQL commands, improper shutdown and more result in SQL database loss or corruption. To perform SQL database recovery in case of SQL database loss, user needs to use SQL database Recovery tools.

Consider a practical situation where a user has executed an Alter Table command to change a column from not null values to null values. After executing the command, user views that the results are undesirable and totally incorrect. The user also experiences various other database corruption issues, such as, unavailability of the SQL database, receiving records that have null columns and more. The above issues can occur due to two main reasons:

  • The column on which the SQL query (Alter Table command) is executed is a part of a clustered index key that may be null.
  • SQL Server does not synchronize column status between the syscolumns system table and the sysindexes system table.

To resolve the above issue and perform sql repair, the user needs to follow these steps:

  • The user can execute the Alter table command to change a column that is a key of a clustered index from not null to null.
  • The user needs to make sure that the database is online and then execute dbcc checktable command by using the repair_build option.

If the above solutions fail to perform SQL database Recovery, then the user needs to use efficient SQL recovery software.

Stellar Information Systems Limited provides the best SQL recovery software named Stellar Phoenix SQL Recovery. This SQL Recovery application incorporates advanced scanning algorithms to repair sql database objects including tables, queries, views, triggers, stored procedures and more. This SQL Repair utility supports MSSQL 2005 and MSSQL 2000.