Breadcrumbs

To Test Failover Scenario

  1. Select the database. Right-Click and select Tasks and then select Mirror

tmpp5ohxtr_.jpg

Figure 15: Database Properties Wizard

  1. Select Failover and select Yes on the next Dialogue box that appears

  2. This will make the current Principal Server as Mirror Server and vice-versa

  3. Click Refresh, to reflect the changes

  4. On the new Principal Server, run the below query to verify Database Mirroring with Utimaco HSM is working as expected

SQL Statement
SQL
USE TestDB1 GO

SELECT FirstName, SecondName, CONVERT (varchar, DECRYPTBYASYMKEY (ASYMKEY_ID('RSA2048Key'), CardNumber))

AS 'CardNumber' FROM Customers; GO