Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
savior faire
Posting Yak Master
194 Posts |
 Posted - 2008-07-01 : 09:12:23
|
| Hi, I posted this over in the SQL Admin folder and really wanted to place it in this one(New to SS). Thanks for reading this. Good morning,I am new to SQL Server 2005, and diligently studying it. This morning I run SSMS to look to verify something I was reading. I try to connect to the server(with Windows Auth) I have installed on my home PC that runs Vista and I get the message below, that I cut/pasted from Event Viewer Log.It says to run DBCC Checkdb on the server, but I cannot get the server started(in SSCM) it to run? Any suggestions? I also have a second named instance installed and that one runs fine.Thanks...The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\modellog.ldf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level 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. Talk sense to a fool and he calls you foolish. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-02 : 01:37:00
|
| Do you have a backup? It looks like the file is corrupted . Can you reintsall ?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
|
|
|
Cannot Start SQL Server