November 6, 2015 at 4:24 am
Hi All,
To day we have faced one issue that master database got corrupted. so that we rebuild the database and restore the master database. after that services are not coming up and when i checked sql error log found the below error:
SQL Server detected a logical consistency-based I/O error: invalid protection option. It occurred during a read of page (1:312) in database ID 2 at offset 0x00000000270000 in file 'H:\SQLTEMP\MSSQL\TEMPDB\tempdb.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.
Please advise
November 6, 2015 at 7:35 am
stop the sql server service and delete the tempdb files and then restart the instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2015 at 9:36 am
I tried with all posibilities and unable to bring the services online. Finally i replaced Model Mdf and Ldf files from Template databases and started services now the services are running fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply