January 27, 2015 at 12:12 pm
Hi Experts.
I have got the error “a network related or instance specific error occurred sql server 2012 “.
I have enabled tcp/ip, restarted the services. The sql server service is getting stopped even after the manual restart. I have checked in event viewer and I noticed a error. Here is the error
The log scan number (43:456:1) passed to log scan in database ‘model’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. Event Id 9003.
Please suggest me the solutions to solve this. TIA
January 28, 2015 at 4:10 am
You cannot log in because the service is stopped.
It won't start because of the corruption error you found in the event viewer.
Go to the Log directory of SQL Server and open the ERRORLOG files. The most recent one is ERRORLOG and then you should have some more ERRORLOG.1, ERRORLOG.2... files (up to 6 by default). One of these should contain the original error, if you didn't attempt to start SQL Server too many times.
If it is data corruption in master, you should try to restore from a backup.
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply