Unable to start instance of SQL 2008 - problems with model.mdf
Posted on 2016-08-13
After a hard shutdown of a server due to a power outage, one of the instances of SQL will no longer stay started. It starts, and then stops, with the following error in the SQL logs.
"SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x0accf0b9; actual: 0xdac1d5cf). It occurred during a read of page (1:2) in database ID 3 at offset 0x00000000004000 in file 'd:\Program Files\Microsoft SQL Server\MSSQL10_50.PROLAW\MSSQL\DATA\model.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
I don't have a backup of model, but i have tried replacing the mdf and ldf files with backups many times to no avail."
I've tried the "-T 3608" switch in starting the service, but it still stops right away.
I have no way of getting into the management studio to run dbcc checkdb.