He is the situation I have currently:
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
There are 2 databases on this instance and only 1 instance on the 2 node cluster. 1 database has been restored and encrypted and the other is giving problems. The restore runs and the encrytion runs but then some "select * from table" statements give an error of:
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:105736; actual 0:0). It occurred during a read of page (1:105736) in database ID 2 at offset 0x00000033a10000 in file 'T:\SQLData\tempdb.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.
I run the dbcc checkdb and 0 errors are found. So has anybody had problems with encrypted databases on a cluster? We have found that restarting the SQL service fixes the problem but I would prefer to know the root cause.