Sql-server – SQL Server error 3417

sql serversql-server-2008

The message is

The log scan number (1166:312:1) passed to log scan in database
'master' 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.

Can you help in resolving the issue.

Best Answer

Restore your master database from a backup. This is a good guide:

http://thomaslarock.com/2014/01/restore-the-master-database-in-sql-server-2012/