Avatar of fuzztone65
fuzztone65
Flag for United States of America asked on

Unable to start instance of SQL 2008 - problems with model.mdf

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.

Any suggestions?
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
fuzztone65

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
fuzztone65

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61