Symptoms
The Service Account that the SQL instance is running, lacks sufficient permissions to access the mounted copy.The AppSync Service plan event will show:
2017-10-13 08:27:00.869,Recover copy,fa3fb129-5f39-4681-99c5-f8a4f08xxxx,SQL_000098,HOSTNAME,The RESTORE command failed for database HOSTNAME\sqlinstance.DB. Check the SQL Server error log and the application event log for information. Try running the operation again.
The AppSync Plugin log on the recovery host will show:
2017-10-13 08:26:59.525 INFO [21304] [] [HOSTNAME] [a75edce0-447d-49bf-9c71-f768140xxxx] SQL: Waiting for the SQL RESTORE command to complete2017-10-13 08:27:00.540 INFO [21304] [] [HOSTNAME] [a75edce0-447d-49bf-9c71-f768140xxxx] SQL: Last native error: error number 3283, SQLState 42000, sql native info message [Microsoft][ODBC SQL Server Driver][SQL Server]The file "PRODDBname" failed to initialize correctly. Examine the error logs for more details.
The AppSync Server log will show:
10-13-2017 08:27:00.869 INFO [Thread-23275 (HornetQ-client-global-threads-1761475520)] [com.emc.archway.service.eventservice.EventServiceBean] [xxxxAPPSYNCxx] [] EVENT [SQL_000098]: The RESTORE command failed for database HOSTNAME]\sqlinstance.DB. Check the SQL Server error log and the application event log for information. Try running the operation again.(METADATA: TYPE-ERROR, TIME-2017-10-13 08:27:00.869-0500NATIVETIME-2017-10-13 08:27:00.540-0500, HOST-HOSTNAME], PHASE-Recover copy, THREAD=21304, USER-BackupAdmin, CATEGORY-GENERIC, SESSIONID-jSLDHZquPYlwQyfBku2aJMc8E8STJlWISg3vxxxx)
Most importantly, the SQL Server log will show:
10/13/2017 8:26:59 AM spid 93FCB:Open failed: Could not open file C:\AppSyncMounts\xxx\Edrive\Data\DBname.mdf for file number 1. OS error: 5/(Access is denied).
Cause
AppSync does not support the use of Service Accounts, some of which end in a dollar sign, as the account used to run the SQL instance.
Resolution
Use a non-service account Domain user as the user which the SQL Service instance runs as.
