VERIFIED SOLUTION i

Resolving EngageOne Designer version 5.x restore error repository cannot be restored to path

Issue

Resolving EngageOne Designer version 5.x restore error repository cannot be restored to path.

Cause

[Microsoft][ODBC SQL Server Driver][SQL Server]File 'DOC1_Repository' cannot be restored to 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\XXXX_Repository_7372d21f68694464b5eba1b4c71c2307.mdf'. Use WITH MOVE to identify a valid location for the file.
[Microsoft][ODBC SQL Server Driver][SQL Server]The operating system returned the error '5(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\XXXX_Repository_356c86f4f7ee44008972230cf8b6b068.ldf'.
[Microsoft][ODBC SQL Server Driver][SQL Server]File 'DOC1_Repository_log' cannot be restored to 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\XXXX_Repository_356c86f4f7ee44008972230cf8b6b068.ldf'. Use WITH MOVE to identify a valid location for the file.
[Microsoft][ODBC SQL Server Driver][SQL Server]Problems were identified while planning for the RESTORE statement. Previous messages provide details.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally.

Resolution

UPDATED: October 20, 2017
You must ensure that the repository is being restored to a valid path.

If restoring directly in SQL using the Management Studio, you need to ensure that you view the options to determine that the path exists (see highlighted area below):

User-added image
Environment Details
Software Affected: EngageOne Designer