Author Box
Articles Categories
All Categories
Articles Resources

Metadata Corruption Issue in SQL Databases When Upgrading to SQL Server 2005

April 12, 2012 | Comments: 0 | Views: 318

Corruption seems to be obvious when you do not perform regular integrity checks on your SQL database. It is necessary to pick up corruption in early stages to avoid unnecessary downtime and a serious risk of data loss. When your SQL database is in a suspect state, you should not immediately restart the SQL Server and go for a quick repair. In such cases, you can run 'DBCC CHECKDB' with the 'All_ErrorMsgs' option. You should run this tool to completion and then design a repair strategy. In case the corruption still persists, you should perform SQL recovery using advanced third-party tools.

SQL users are generally faced with metadata corruption or system table corruption. SQL Server 2000 has the provision to make direct changes to the system tables, including the most critical 'sysindexes', 'sysobjects', and 'syscolumns'. It is easy for the SQL 2000 users to work around these tables and also insert, update, or delete whatever is required. However, this sometimes leads to database inconsistency. If you delete an object from 'sysobjects' without updating the same in 'sysindexes' and 'syscolums', you will certainly run the risk of database corruption.

In SQL Server 2005, the DBCC CHECKDB also includes DBCC CHECKCATALOG checks. As a result, when you upgrade to SQL Server 2005, you will receive 'Msg 8992' that indicates metadata corruption:

Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3853, State 1: Attribute (object_id=1977058079) of row (object_id=1977058079,column_id=1) in sys.columns does not have a matching row (object_id=1977058079) in sys.objects.

The above error appears because of direct updates to the system tables in SQL 2000. This issue cannot be resolved by simply running DBCC CHECKDB on the database. You will need to delete records from the system tables. A more risky way to deal with this is editing the system tables in SQL Server 2005. This is also very complex and not a recommended solution.

You can also try creating scripts of objects in the original database and exporting all the data. Later, you can create a new SQL database and reload all data after recreating the objects. If the above methods fail to repair corruption, you should take help of SQL database recovery software. These third-party tools use advanced, ingenious methods to safely repair damaged SQL databases. They can effectively restore tables, indexes, views, triggers, keys, user-defined functions, etc. Using these utilities, you can also preview your database prior to performing recovery.

Tanvi Sharma is a researcher working on SQL Database corruption issues. She has knowledge in SQL recovery inbuilt utilities & SQL database recovery tools. Check my blog:

Source: EzineArticles
Was this Helpful ?

Rate this Article

Article Tags:

Metadata Corruption


Sql Database Recovery

Windows 8 will change the way you work and play, says Microsoft and we agree. Nearly all of the previous iterations of the Windows OS have been evolutionary but Windows 8 is set to change all that.

By: Sakshi Sharma l Computers & Technology > Mobile Computing l April 03, 2013 lViews: 662

Many antivirus programs available today have various features but it entirely depends on the user to make the best choice from among these different computer virus protection programs online. Before

By: Alex l Computers & Technology > Software l December 28, 2012 lViews: 370

You can add a new color to your entertainment life with iskysoft video converter for mac & iskysoft dvd creator for mac and make your Christmas holidays all the more special. iskysoft video

By: Zaithyn Galter l Computers & Technology > Software l December 23, 2012 lViews: 1070

The choices you make regarding the type of recruiting software you choose to use are important. Being an informed consumer is essential to getting a system or components that complement systems of

By: Maria Warne l Computers & Technology > Software l December 14, 2012 lViews: 305

The Cisco certification has become the most popular IT training in recent days and it offers three different levels of these certifications include as: associate, professional and expert-level.

By: sandidas chakma l Computers & Technology > Certification Tests l December 11, 2012 lViews: 236

Millions of prospective 12th standard students are gearing up their preparations for the Joint Entrance Exam for engineering seats. From 2013, it has been decided by the IITs, CBSE, JEE organizing

By: Sarkariexam l Computers & Technology > Certification Tests l December 07, 2012 lViews: 633

Corruption manifests itself in an Oracle database in primarily two forms. An Oracle data block may contain an invalid header or the contents of the block could be logically inconsistent. In both the

By: Mark Williuml Computers & Technology > Data Recoveryl April 17, 2012 lViews: 225

Hard drive failure sucks, no matter how you look at it. But it isn't the end of the world, as long as you avoid these three deadly mistakes.

By: Maureen Daviesl Computers & Technology > Data Recoveryl April 17, 2012 lViews: 209

We all buy insurance, for our homes, our cars, and our businesses. Being prepared for disaster, whether natural or otherwise, is just the smart thing to do. It's also smart to be prepared for a data

By: Joe Sallandl Computers & Technology > Data Recoveryl April 16, 2012 lViews: 188

Your business does not have to suffer due to the vagaries of Mother Nature. Well designed and implemented data management strategies and techniques from your IT services provider are just the ticket

By: Joe Sallandl Computers & Technology > Data Recoveryl April 16, 2012 lViews: 179

How safe is your business in the aftermath of fire or any other catastrophe in terms of your IT systems? Most businesses have an emergency plan of evacuation in the event of a fire, however many do

By: Steve R Bryanl Computers & Technology > Data Recoveryl April 16, 2012 lViews: 191

Digital document archiving is a more secure, efficient, and sustainable way of maintaining your valuable files and official documents. Learn the benefits of using this modern system and digitize all

By: Lyle Osbornel Computers & Technology > Data Recoveryl April 15, 2012 lViews: 169

Discuss this Article

comments powered by Disqus