VDP SQL client restore fails with "avsql Error : Instance xxx wasn't found"
search cancel

VDP SQL client restore fails with "avsql Error : Instance xxx wasn't found"

book

Article ID: 339451

calendar_today

Updated On:

Products

VMware vSphere ESXi

Issue/Introduction

Symptoms:
When attempting to perform a restore of SQL Database using VDP, you see error similar to:

In this example: The instance name is MSSQLSERVER
 
MOD-1470343343920-3006-SQL.log:2017-08-04 16:42:56 avsql Error <14279>: Instance MSSQLSERVER wasn't found.
 


Environment

VMware vSphere Data Protection 6.1.x

Cause

This issue occurs because the restore wizard was unable to recognize the instance name.

Resolution

To resolve this issue, use the instance name obtained when running the following command on the SQL target client:
 
C:\Program Files\avp\bin\avsql --operation=browse --debug --verbose=5
 
The command will list the instance name as (local).
Note: Use (local) in the restore wizard in order to perform the restore successfully.