25112
asked on
Data corruption - more possible in VM environment?
the staff in this client place here say they had seen data corruption in physical machines only once in the last 12 years. but in the last 6 months, since VMs (wmware 3) were introduced, 3 times 3 different VM machine and a database in the instance got corrupted.. in all 3 times, some data was lost..
is this just coincidence or any real relation between the environment and the corruptions?
is this just coincidence or any real relation between the environment and the corruptions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hanccocka, below is the error from sql: does this help..
the link i gave you has an issue where vmware corrupts the data, but perhaps that is fixed with the latest version of vmware?
the link i gave you has an issue where vmware corrupts the data, but perhaps that is fixed with the latest version of vmware?
• Table error: Page (1:879) allocated to object ID 314236343, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
• Table error: Page (1:879) with object ID 314236343, index ID 2 in its header is allocated by another object.
• Table error: Object ID 314236343, index ID 2. Page (1:879) is missing references from parent (unknown) and previous (page (1:878)) nodes. Possible bad root entry in sysindexes.
• Table error: Object ID 314236343, index ID 2, page (1:879), row 486. Record check ((Record (i) == INDEX_RECORD || (Record (i) == GHOST_INDEX_RECORD && level == 0)) && Page->GetType == INDEX_PAGE) fail
• Table error: Object ID 314236343, index ID 2, page (1:879), row 487. Record check ((Record (i) == INDEX_RECORD || (Record (i) == GHOST_INDEX_RECORD && level == 0)) && Page->GetType == INDEX_PAGE) fail
• Table error: Object ID 314236343, index ID 2, page (1:879), row 488. Record check ((Record (i) == INDEX_RECORD || (Record (i) == GHOST_INDEX_RECORD && level == 0)) && Page->GetType == INDEX_PAGE) fail
• Table error: Object ID 314236343, index ID 2. The next pointer of (1:879) refers to page (1:880). Neither (1:880) nor its parent were encountered. Possible bad chain linkage.
• Row 32625 An error occurred while executing batch. Error message is: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
andy, thanks for the corrective post..
ASKER
again, this can happen in physical machines also, but it just so happens it is vmware3 in this case..
i am looking at all angles, but hence i am asking this question also..
an article came across that says some tech info:
http://www.sqlsolutions.com/articles/articles/SQL_Server_and_VMware-A_Potentially_Fatal_Combination.htm