error occurred at the step “provision a SQL Server VDB”.

  • 0
  • 1
  • Problem
  • Updated 4 years ago
  • In Progress
We succeed to create dSource from source server.

But, error occurred at the step “provision a SQL Server VDB”.

It seemed the privilege issue, but I couldn’t find the cause.

Error code will be below.


Error:
Recovery failed for virtual database "virtual_database_name"

Error Code:
exception.db.mssqlvdb.vdb.restore.failed

Suggested Action:
Make sure that the SQL Server instance "INSTANCE_NAME" on the target host "HOST_NAME" is up and that the user "USER_NAME" has privileges to restore a database on the host.
Photo of Kazuyuki Goto

Kazuyuki Goto

  • 90 Points 75 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Darin Tully

Darin Tully, SQL DBA

  • 530 Points 500 badge 2x thumb
Hi Kazuyuki,

It's possible the user account that was used to register the Target environment the VDB is being created on does not have SysAdmin rights on the SQL instance.

You can click on the "Manage" menu, click "Environments" and then select the environment the VDB is being created on. Under the "Environments Detail" tab, you'll see the Environment Users account used to register that host. I would check the SQL instance to make sure that account has sa rights.

One other thing I can think of is if the Source SQL instance is running Enterprise and the Source database (dSource) is using Enterprise features like Partitioned Tables or possibly Online Indexes. But the Target host is running the Standard version of SQL. The VDB will fail when the Delphix Engine tries to recover the VDB because the SQL instance cannot support those features.

Try those two checks and let me know how it turns out.
Photo of Kazuyuki Goto

Kazuyuki Goto

  • 90 Points 75 badge 2x thumb
Hi Darin,

 

Thank you for your reply.

 

I tried two checks.

But they seems to no problem.

 

The account which was used to register the VDB has sysadmin privilege (SQL server role)

and it belong to Administrators group on windows OS.

 

Then, Source SQL and Target SQl is same version.

Source SQL does not use especially additional features.

But we can't provision VDB.

 

What should I confirm of privileges else?

Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
1) Try it again and watch the SQL Server logs to see what events fail.
2) Can you, as the user specified in Delphix, manually restore a backup on that server?

That is where my next tests would be.
Photo of Kazuyuki Goto

Kazuyuki Goto

  • 90 Points 75 badge 2x thumb
Hi Adam, 

Thank you for your reply.

I tried checks.
But they seems to no problem.


1)Run the "provision a SQL Server VDB", the same error occurs. 
It was confirmed a log of SQL Server, but did not know the cause. 

2)It was confirmed that you perform backup and restore in SQL Server using the Delphix user, you can run without problems.

What could be seen from this result?
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
What I would look for as a result of those tests would be a permissions related issue/error. I would open a ticket with support so that they can assist you with the issue.