Call Us: +923135419942

Whataspp Live Chat

SQL Server detected a logical consistency-based I/O error: invalid protection option. It occurred during a read of page (1:2634) in database ID 8 at offset 0x00000001494000 in file ‘D:\\desktop_application\\SchoolFeeManagement\\DB\\SchoolFeeManagement.mdf’. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online

SQL Server detected a logical consistency-based I/O error: invalid protection option. It occurred during a read of page (1:2634) in database ID 8 at offset 0x00000001494000 in file ‘D:\\desktop_application\\SchoolFeeManagement\\DB\\SchoolFeeManagement.mdf’. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online

In case of this error, Run following SQL Command in Master Database

ALTER DATABASE [DB_Name] SET single_USER
EXEC sp_resetstatus [DB_Name];
ALTER DATABASE [DB_Name] SET EMERGENCY
DBCC CHECKDB ([DB_Name], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [DB_Name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC DATABASE ([DB_Name], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [DB_Name] SET MULTI_USER