MS SQL VDB
# MS SQL VDB
| Category | Exception | Description | Action |
|---|---|---|---|
| MS SQL | exception.db.mssqlvdb.enable.cdc.on.vdb.failed | Failed to enable CDC on virtual database “{0}” | Make sure that the SQL Server instance “{1}” on the target host “{2}” is up and supports ‘Change Data Capture’ and user “{3}” has enough privileges to enable CDC on the virtual database. |
| MS SQL | exception.db.mssqlvdb.vdb.addextendedproperties.failed | Failed to add extended properties to the virtual database “{0}”: {1}. | Make sure that the user “{2}” has privileges to add extended properties to the database. |
| MS SQL | exception.db.mssqlvdb.vdb.attach.failed | Failed to attach VDB “{0}”. | Make sure that the user “{1}” has privileges to attach the database. |
| MS SQL | exception.db.mssqlvdb.vdb.checkpoint.query.failed | Error trying to query the virtual database “{0}” for the latest checkpoint LSN: |
Make sure that the SQL Server instance “{2}” on the target host “{3}” is up and that the virtual database is running. |
| MS SQL | exception.db.mssqlvdb.vdb.delete.failed | Failed to delete the virtual database “{0}”: {1}. | Make sure that the user “{2}” has privileges to delete the database. |
| MS SQL | exception.db.mssqlvdb.vdb.disable.no_primary_database_file | Cannot disable virtual database “{0}” because primary database file information is not available. |
Refresh the virtual database or take a snapshot and try the operation again. |
| MS SQL | exception.db.mssqlvdb.vdb.disable.service_broker.failed | Failed to disable the service broker for virtual database “{0}”. | Make sure that the user “{1}” has privileges to disable the service broker and try the operation again. |
| MS SQL | exception.db.mssqlvdb.vdb.environment.not_target | Selected environment “{0}” for provisioning is not a target environment. | Provide a target environment which has the Delphix Connector installed and try the operation again. |
| MS SQL | exception.db.mssqlvdb.vdb.get.file_list.primary_file.failed | Failed to get the list of database files from the primary data file “{0}”: “{1}” for VDB “{2}” |
Make sure that the user “{3}” has privileges to access the instance. |
| MS SQL | exception.db.mssqlvdb.vdb.restore.failed | Recovery failed for virtual database “{0}” | Make sure that the SQL Server instance “{1}” on the target host “{2}” is up and that the user “{3}” has privileges to restore a database on the host. |
| MS SQL | exception.db.mssqlvdb.vdb.set.database.read_write.failed | Failed to set virtual database “{0}” in read-write mode. | Make sure that the user “{1}” has privileges to set the database in read- write mode. |
| MS SQL | exception.db.mssqlvdb.vdb.snapshot.not_allowed | Snapshot for virtual database “{0}” is not allowed as the database is not ONLINE. | Make sure that the database exists, is ONLINE and try again. |
| MS SQL | exception.db.mssqlvdb.vdb.startup.failed | Failed to start up the virtual database “{0}”: {1}. | Make sure that the user “{2}” has privileges to start up the database. |
| MS SQL | exception.db.mssqlvdb.vdb.target_db_validation.failed | Failed to validate if database “{0}” on target environment “{1}” belongs to VDB “{2}”. No operations will be performed on the database. Error: {3}. |
|
| MS SQL | exception.db.mssqlvdb.vdb.target_db.different | Failed to perform operation on VDB “{0}” because a database with name “{1}”, primary data file “{2}” already exists on instance “{3}”, host environment “{4}” and is not managed by Delphix. |
Detach the existing database from within SQL Server and try this operation again, or use the Delphix Engine Migrate function to move this VDB to a different SQL Server instance. |
| MS SQL | exception.db.mssqlvdb.vdb.target.database.exists | The database for VDB “{0}” has the same name “{1}” in SQL Server instance “{2}” on target host “{3}”. |
Select a different database name and try again. |