MS SQL SERVER 2008R2 NOT STARTING. ERROR 3414

Question

Dear experts.

I have ms sql 2008 r2 running. after power failure the system is not starting up.

windows service start gives error 3414.

sql server error log says

SPID10s ERROR: 9003, SEVERITY: 20, STATE 1.
SPID10S THE LOG SCAN NUMBER (78:96:1) PASSED TO LOG SCAN IN DATABASE 'MODEL' IS NOT VALID.

please can you help in this regard.
urgent help will be appreciated.

regards

Answer 1

Looks like model is damaged. Assuming that you have not added something to model, you could take the files from another instance running SQL 2008 R2 (and not some other version). Rename the current files for model, and copy the files from the other instance.

Hopefully your instances starts now, but run DBCC CHECKDB on all databases, as there may be more damages after the power failure.

Answer 2

Hi @Krishna Kamal Mandava ,

> windows service start gives error 3414.

This error can be caused by a transient condition that existed on the system during a given attempt to start up the server instance or to recover a database.

For information about the cause of this occurrence of error 3414, examine the Windows Event Log or ERROR LOG for a previous error that indicates the specific failure. This helps the user to resolve the issues by applying the appropriate method.

If the errors cannot be corrected, please using the replace the model files from another instance that has same version as Erland mention.

Please refer to the blog SQL Server Error 3414: Windows could not start the SQL Server on Local Computer or MS document MSSQLSERVER_3414 to get more information.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.

Answer 3

This was happening because we had symmetric Key Column level Encryption on the same table. We had multiple Symmetric keys, certs from previous testing. Once we removed all of those, the above issue disappeared. I am not sure what the old Symmetric keys had to do with the above issue as it was on another column on the same table but cleaning them up it resolved it.

Answer 4

You can check these references: https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-3414-database-engine-error
https://community.spiceworks.com/how_to/166901-all-about-ms-sql-database-corruption-cases-and-its-solutions