MSG 824 Errors - Virtual PC 2007 - Windows Server 2003 - SQL Server 2005
I am running a Windows XP-PRO (SP3) workstation hosting a MS Virtual PC 2007 session with the following....
WINDOWS SERVER 2003 (SP2)
MS-SQL 2005 STANDARD
I tried a number of times to RESTORE a 6.59 GB database from a back-up, but with no luck.
So instead, I manually moved the files to my MS Virtual PC 2007 session - and did a ATTACH. The Database had five (5) files to attach -
<DBNAME>_data.mdf
<DBNAME>_data1.ndf
<DBNAME>_data2.ndf
<DBNAME>_log.ldf
<DBNAME>_Log2.LDF
It all seemed to go OK (no errors on the attach), but I am now getting all kinds of MSG 824 ERRORS when I run some of my queries..
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:120704; actual 17049:553648150). It occurred during a read of page (1:120704) in database ID 10 at offset 0x0000003af00000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<DBNAME>_data.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. (Microsoft SQL Server, Error: 824)
=========
I ran the DBCC CHECKDB - it ran for about 30 seconds and then gave two errors...
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x501; actual: 0x168ca9cf). It occurred during a read of page (1:120704) in database ID 11 at offset 0x0000003af00000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<DBNAME>_data.mdf:MSSQL_DBCC11'. 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 am wondering if the I/O errors are related to using a Virtual PC 2007 session to run this.
It all seems to be OK when restored to a physical server - but not when using this Virtual PC 2007 session .
Anyone seen this before - or have any ideas on what I could try next...?
Thanks in advance!
Senior Business Intelligence Consultant
Toronto, Canada
SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services
I am running a Windows XP-PRO (SP3) workstation hosting a MS Virtual PC 2007 session with the following....
WINDOWS SERVER 2003 (SP2)
MS-SQL 2005 STANDARD
I tried a number of times to RESTORE a 6.59 GB database from a back-up, but with no luck.
So instead, I manually moved the files to my MS Virtual PC 2007 session - and did a ATTACH. The Database had five (5) files to attach -
<DBNAME>_data.mdf
<DBNAME>_data1.ndf
<DBNAME>_data2.ndf
<DBNAME>_log.ldf
<DBNAME>_Log2.LDF
It all seemed to go OK (no errors on the attach), but I am now getting all kinds of MSG 824 ERRORS when I run some of my queries..
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:120704; actual 17049:553648150). It occurred during a read of page (1:120704) in database ID 10 at offset 0x0000003af00000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<DBNAME>_data.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. (Microsoft SQL Server, Error: 824)
=========
I ran the DBCC CHECKDB - it ran for about 30 seconds and then gave two errors...
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x501; actual: 0x168ca9cf). It occurred during a read of page (1:120704) in database ID 11 at offset 0x0000003af00000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<DBNAME>_data.mdf:MSSQL_DBCC11'. 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 am wondering if the I/O errors are related to using a Virtual PC 2007 session to run this.
It all seems to be OK when restored to a physical server - but not when using this Virtual PC 2007 session .
Anyone seen this before - or have any ideas on what I could try next...?
Thanks in advance!
Senior Business Intelligence Consultant
Toronto, Canada
SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services