Skip to main content
Delphix

SQL Server VDB Cannot be Enabled After a Force Disable Operation (KBA1702)

 

 

 

Note

Note:

This topic has been Archived as these behaviors are addressed in 5.1.4.0 and later.   It is not expected that this KBA will be applicable to any releases beyond 5.1.4.0.  5.1.x is in Extended Support until December 2022.  Please review our Product Lifecycle Policies (KBA1003) for further lifecycle information.

KBA

KBA#1702

Applicable Delphix Versions

 

Major Release

Sub Releases

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

4.3

4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0

4.2

4.2.0.0, 4.2.0.3, 4.2.1.0, 4.2.1.1, 4.2.2.0, 4.2.2.1, 4.2.3.0, 4.2.4.0 , 4.2.5.0, 4.2.5.1

4.1

4.1.0.0, 4.1.2.0, 4.1.3.0, 4.1.3.1, 4.1.3.2, 4.1.4.0, 4.1.5.0, 4.1.6.0

4.0

4.0.0.0, 4.0.0.1, 4.0.1.0, 4.0.2.0, 4.0.3.0, 4.0.4.0, 4.0.5.0, 4.0.6.0, 4.0.6.1

3.2

3.2.0.0, 3.2.1.0, 3.2.2.0, 3.2.2.1, 3.2.3.0, 3.2.4.0, 3.2.4.1, 3.2.4.2, 3.2.5.0, 3.2.5.1, 3.2.6.0, 3.2.7.0, 3.2.7.1

3.1

3.1.0.1, 3.1.1.0, 3.1.2.0,  3.1.2.1, 3.1.3.0 , 3.1.3.1, 3.1.3.2, 3.1.4.0, 3.1.5.0, 3.1.6.0

Troubleshooting 

After disabling a SQL Server virtual database (VDB) on the Delphix Engine with the Force Disable option selected, subsequent attempts to enable the VDB fail with the following message:

The operation could not be completed because the virtual database "<VDB_name>" is disabled.

clipboard_e10e5d6557fe39bafe98177ca578170a6.png

Cause 

When using the Force Disable option to disable a VDB, the Delphix Engine marks the VDB as 'disabled' on the Engine and disables the shared iSCSI volumes, but it makes no changes on the target host nor to the SQL Server instance. SQL Server therefore still believes that the database is attached.  Attempts to access the database will leave it in the 'Recovery Pending' state, seen via the SQL Server Management Studio.

A VDB disabled without the Force Disable option selected should no longer appear in the list of databases within SQL Server Management Studio.

The Force Disable option should therefore only be used in situations where a normal disable operation would fail. Such situations may include the SQL Server instance being down or the target host not being reachable over the network.

Resolution

Changes to the Delphix Engine, improving the behavior of Enable operations, were introduced in Delphix Engine versions 5.1.4.0/ 5.2.

In earlier releases, the following steps could be used to bring the VDB back online.

  1. In SQL Server Management Studio, perform a 'Take offline' operation on the VDB.

clipboard_ed97d17268c186c9977fcc20235d296e2.png

 

2. In SQL Server Management Studio, perform a 'Detach' operation on the VDB. DO NOT select the options to either Update Statistics or Drop Connections. The detach operation may complete with an error, depending upon whether the VDB's iSCSI volumes are still mounted from the Delphix Engine. Once the detach operation completes, the VDB should no longer appear in the list of databases.

clipboard_eaffbcea8100a930b703f0cf8e0ce711b.png

clipboard_e7662de9cc904ba23ec2279468ccbb778.png

3. Enable the VDB as normal on the Delphix Engine.

If the VDB enable job continues to fail, further investigation may be required via a Delphix Support case.