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
Follow the Tasks given bellow
1. Backup the Database
2. Run the following query
ALTER DATABASE test_DB SET SINGLE_USER
DBCC CHECKDB (' test_DB ', REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS, NO_INFOMSGS
ALTER DATABASE test_DB SET MULTI_USER
Hope it will solve the problem.
Posted by: MR. JOYDEEP DAS