Unfortunately I do not have recent backup.... Sql service is not starting. I am unable to connect to database from management studio.
After power failure sql server 2008 production system not starting up. Windows service gives error 3414.
Sql 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.
Connecting from Management Studio says:
(CANNOT CONNECT TO SERVER. MS SQL SERVER ERROR : 2 )