Error message from Eventviewer for SQL Server

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Recently i was using SQL Server 2008 which worked fine. But suddenly an error has appeared and my service gets automatically stopped even after i start it manually.

Service Name :- MSSQL$SQLEXPRESS
Display Name :- SQL Server (SQLEXPRESS)

Below is the error message i extracted from Eventviewer for SQL Server
-------------------------------------------------------

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x0002c6dc; actual: 0x6450282c). It occurred during a read of page (2 : 0) in database ID 3 at offset 0000000000000000 in file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\modellog.ldf". 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.

Solutions Tried
1) I thought the OS might have some problem so i formated the PC and installed the SQL again still the problem was not gone.

2) Saw a solution on internet it says run DBCC command in SQL but the problem is i cannot log in SQL as the service is close

Please help me here

Posted 6-Sep-15 21:40pm

Master@Infinity

Updated 7-Sep-15 22:54pm

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

barneyman · Answer 1 · 2015-09-06T23:07:00

Solution 1

Google the problem[^] ?

The first two look extremely useful ...

Posted 6-Sep-15 23:07pm

barneyman

Comments

Master@Infinity 7-Sep-15 5:22am

my dear friend i searched a lot (for 2 days now) and that is why i posted this question

barneyman 7-Sep-15 18:27pm

it would appear your DB is broken then ... advice under that condition is to restore from a recent backup, and apply the log files forward

and check your disks, they caused the problem

Master@Infinity 8-Sep-15 4:50am

problem is that for this i got my computer formatted and got SQL installed again but this error continuous to follow me and i don't have a backup of the log "modellog.ldf"

phil.o 8-Sep-15 5:51am

Do you have a backup of the database?

Master@Infinity 8-Sep-15 7:41am

no according to me "modellog.log" is created automatically when the SQL Server is installed and why should i keep backup of anything that is their by default.

phil.o 8-Sep-15 7:53am

You should take a backup of everything that is important. I'm not talking about the backup of the .ldf file itself, I'm talking about the backup of the database.