VMware Cloud Community
Albin_Penic
Contributor
Contributor

MS SQL 2005 consistency

I have problems with my SQL 2005 server. Here is record in event log. After this occurred database crash.

Can this be related to VMotion or VCB back up?

Event Type: Error

Event Source: MSSQLSERVER

Event Category: (2)

Event ID: 824

Date: 21.6.2007

Time: 21:27:51

User: SALONIT\user

Computer: Server

Description:

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 3:784864; actual 3:377056). It occurred during a read of page (3:784864) in database ID 18 at offset 0x0000017f3c0000 in file 'database_name.ndf'. 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.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:

0 Kudos
3 Replies
Dave_Mishchenko
Immortal
Immortal

The error usually indicates a hardware/disk failure of some sort. Are there any disk errors in the system event log? Also have you checked the contents of the vmware.log file for this VM?

0 Kudos
Albin_Penic
Contributor
Contributor

In Windows system event log is clear, no disk errors. What shoud i search in vmware.log file to find if there is some error on SAN disk?

0 Kudos
Albin_Penic
Contributor
Contributor

I discovered where was problem. VMware SYNC driver don't support Windows x64. so when vMotion is occurred database become corrupted.

0 Kudos