SQL Server VDB Cannot be Enabled After a Force Disable Operation (KBA1702)
KBA
KBA#1702Applicable 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.
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.
- In SQL Server Management Studio, perform a 'Take offline' operation on the VDB.
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.
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.