Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Encrypting database on cluster Expand / Collapse
Author
Message
Posted Friday, August 14, 2009 8:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 6:51 AM
Points: 1,207, Visits: 1,267
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:

Message
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.
Post #770964
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse