Wednesday, 6 February 2013

Error 27506

Introduction 

One of my friend want a solution from me related to scripts compilation error. He is going to compile a batch job of some SQL scripts, Procedure etc and found the error mentioned bellow.

Error 27506. Error executing SQL script test.sql. Line 76. During undo of a logged operation in database 'Test_DB', an error occurred at log record ID(38256:32:22). The row was not found. Restore the database from a full backup, or repair the…

The Reason of this Error

The reason from this error is Data Corruption in Database

Possible Solutions

Follow the Tasks given bellow

1.    Backup the Database
2.    Run the following query

ALTER DATABASE  test_DB  SET SINGLE_USER
GO
DBCC CHECKDB (' test_DB ', REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS, NO_INFOMSGS
GO
ALTER DATABASE test_DB  SET MULTI_USER
GO



Hope it will solve the problem.



Posted by: MR. JOYDEEP DAS

No comments:

Post a Comment

Post a Comment