MS SQL Server 2008 aims at providing self tuning, self organizing and self maintaining data management. It has been widely used as data storage backend for XML, e-mail, file, document, calendar, spatial etc. Apart from this it also perform search, analysis, query and synchronization across all data types. It is popular database as it supports digital media formats like pictures, audio, video and other multimedia data. But this popularity is affected when it gets trapped with various errors. In SQL server, page is used as unit of storage and the collection of eight pages is an extent which is used to manage the pages. Sometimes it happens that SQL Server is unable to read these pages due to corruption and various error messages appear. One such error is Error 1203 in MS SQL Server.

Usually, the error appears in SQL server due to various reasons like:

• Power failure
• Virus attack
• Hardware problems
• Abnormal shut down of system

But this error i.e. error 1203 appears due to some structural problems within the database that results in corruption of database. Whenever this error occurs you encounter with below error message, when you try to work on your SQL Server 2008.

“Process ID % d attempted to unlock a resource it does not own: %.*ls. Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.”

This error message confirms the occurrence of Error 1203 in MS SQL Server and you need to repair the error. Due to corruption, SQL Server unlocks an already unlock page. If you have got such kind of error message you can resolve the error by restoring it from backup if it is clean and updated. In the case if you don’t have updated backup run DBCC CHECKDB utility to know the area of corruption. Then again run it and issue repair clause to resolve the error.

But sometimes using this utility doesn’t prove safe repairing and it might overwrite the existing data. So, it’s better to use MS SQL Database Repair Software that can safely repair Error 1203 in MS SQL Server without getting any damage existing data. It repairs all types of objects like tables, NDF files, stored procedures, triggers, defaults, indexes etc. It supports all versions of MS SQL Server 7.0, 2000, 2005 and 2008.