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 |
|
rdobrich
Starting Member
2 Posts |
 Posted - 2007-10-09 : 05:19:59
|
| Hi,In my database, when I try to start sql service, I got following message in event view.SQL server is sql express version Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) 10/09/2007 10:48:47,spid5s,Unknown,Recovery is complete. This is an informational message only. No user action is required.10/09/2007 10:48:47,spid15s,Unknown,SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:9; actual 0:0). It occurred during a read of page (1:9) in database ID 8 at offset 0x00000000012000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\magirisilica_s24.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<c/> see SQL Server Books Online.10/09/2007 10:48:47,spid15s,Unknown,Error: 824<c/> Severity: 24<c/> State: 2.When I try to make dbcc dbcheckdb ...I got this.Msg 945, Level 14, State 2, Line 1Database 'magirisilica_s24' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.Any suggest.Thanks in advanceRadovan |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-09 : 05:49:50
|
| Could you just doublecheck , is the db set at "Read Only " or suspect?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL |
 |
|
|
rdobrich
Starting Member
2 Posts |
Posted - 2007-10-10 : 04:01:33
|
| No,This I done first.An disk has a lot of free space.Database id demaged due disk error (disk check reported error).I can copy database, but I can't install it on another computer. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
|
|
|
|
|
|
|
Loical consistency-based I/O error