Quick run down:
First problem started when sysadmin received error that
model is recovering.
Sometime later vendor tried to do some upgrades to the database. When they restarted SQL Server it failed to start.
Looking at error log. I found the following error
Error The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run. Error: 927, Severity: 14, State: 2. Database 'model' cannot be opened. It is in the middle of a restore. Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
after searching around on the web found this article on MSDN
using steps from article started sql server using
Sqlservr.exe -sInstanceName -T3608 -c -f -T3609 when i tried to run
Use tempdb got error message. Following advice from article I copied tempdb.mdf and templog.ldf from another server.
Now I get the following error:
Starting up database 'tempdb'. Error: 3456, Severity: 21, State: 1. Could not redo log record (19:45:366), for transaction ID (0:0), on page (1:16), database 'tempdb' (database ID 2). Page: LSN = (18:72:8), type = 1. Log: OpCode = 18, context 2, PrevPageLSN: (19:45:287). Restore from a backup of the database, or repair the database.