There are 2 issues at the same time.
- I cannot connect to the database (SQL Server 2012) using SSMS - I'm getting error 1225
- I cannot start the SQLEXPRESS service - getting error 3414
Earlier last week, I had connected to the server and found that the database was in
Suspect mode. So, I fixed it by changing it to Emergency, then DBCC, then Single User and then multi user which worked fine and we could access the data in the app as well.
Now after 4 days this is a new issue. When I looked online the solution to error 1225 is to start the
SQLEXPRESS Service on which I am getting error 3414, the solution to which is to repair the database which I cannot connect to. As far as I know, the
SQLEXPRESS service error 3414 is the main issue here.
Note: I have admin rights. I have tried with both Windows auth and SQL Server auth. I am selecting the correct server name.
Please help or share an article(s) on how to fix the issues. Is there any way I can access the database and see if it's in SUSPECT/EMERGENCY mode or something and maybe repair it again.
Update 1 [9 June]:
Event Logs - Error: The log scan number (94:280: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.