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:
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?
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?
I discovered where was problem. VMware SYNC driver don't support Windows x64. so when vMotion is occurred database become corrupted.