Attachability checks fails with the error: SQL Server detected a logical consistency-based I/O error: incorrect pageid.
You can see the following info in the stack trace:
ERROR 2012-04-26T14:42:35 [39] – Replay.Core.Implementation.Sql.RecoveryPointAttachabilityJob ()
Job ‘Performing attachability check for recovery point Snapshot(s) of ‘H:\’,'E:\’,'C:\’,'G:\’,'D:\’ on ‘PRODSQL01′ as of ’04/19/2012 00:01:55′ (core’s local time)’ failed
System.AggregateException: One or more errors occurred. —> System.AggregateException: One or more errors occurred. —> Replay.Core.Implementation.Sql.DatabaseAttachabilityCheckFailedException: Attachability check failed for SQL database prodsnapshot_RocheXML_02_20111116 of instance MSSQLSERVER —> Microsoft.SqlServer.Management.Smo.FailedOperationException: Attach database failed for Server ‘TESTBAK01\’. —> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. —> System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:32; actual 0:0). It occurred during a read of page (1:32) in database ID 13 at offset 0×00000000040000 in file ‘C:\ProgramData\MountPoints\72c786a2-f08e-42e7-9ec0-ed1dd991f0a7\G__\sql_data\prodsnapshot_RocheXML_02_20111116.ss’. 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.
Could not open new database ‘AA-prodsnapshot_RocheXML_02_20111116-73eb4ad1-9973-4ff7-af7b-6f0da0e7cca3.ss’. CREATE DATABASE is aborted.
This issue occurs when Core tries to perform attachability check for the SQL database’s snapshot (you can recognize it among the databases by the name wich ends with 000.ss). This is currently not supported by AppAssure 5.
