Friday, October 1, 2010

Repair & Restore Master Database in MS SQL Server

In MS SQL Server Database, all the information’s are stored in a master database file. These information/data includes the instance-wide metadata like, linked servers, system configuration settings, endpoints and some more. Furthermore, master database file of SQL server records the creation of other SQL database, initialization information and location of the files for SQL Server. Thus, MS SQL Server database can not start if master database file is corrupted, damaged, or missed. This is the very critical situation for the database administrator may be business loss to recover MDF file need SQL recovery software.

Microsoft SQL Server database provides facility to checking the integrity for both logical as well as physical of all objects. DBCC CHECKDB is the facility to check the integrity of SQL server database in a specified database. This DBCC CHECKDB contains three modules- DBCC CHECKALLOC, DBCC CHECKCATALOG and DBCC CHECKTABLE, these all are used to perform specific operations in SQL server database.

Sometimes DBCC CHECKDB command does not handle the SQL server database corruption in all cases and thus your master database file (MDF) may still inaccessible. This type of problem normally occurs in case of severe corruption to the SQL server database. Take a practical scenario where you try to run DBCC CHECKDB module on master database of SQL Server and get error message like given below:

"Server: Msg 8952, Level 16, State 1, Line 1 Table error: Database 'master', index 'syscolumns.ncsyscolumns' (ID 3) (index ID 2). Extra or invalid key for the keys: Server: Msg 8956, Level 16, State 1, Line 1 Index row (1:425:11) with values (id = 1794105432 and name = 'COLUMN_NAME' and number = 0 and id = 1794105432 and colid = 4 and number = 0) points to the data row identified by (). CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'syscolumns' (object ID 3). repair_fast is the minimum repair level for the errors found by DBCC CHECKTABLE (master.dbo.syscolumns )."

At that situation, you will need to use advanced SQL database recovery software to get your master database file backup. Stellar Phoenix SQL Database Recovery application is able to repair and restore corrupted master database file of SQL server. It can recover stored procedure, triggers, views, collation and many more of the Microsoft SQL database.

No comments:

Post a Comment