Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MSG 824 Errors - Virtual PC 2007 - Windows Server 2003 - SQL Server 20

Status
Not open for further replies.

MJRBIM

MIS
May 30, 2003
1,579
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top