Dynamics 365 finance and operations restore database to local VM

  1. Downlaod and unzip latest version for Windows .NET Platform sqlPackage.

  2. Open command with below script

Cd "path_to_sqlPackage"
SqlPackage.exe /a:import /sf:"J:\MSSQL_BACKUP\UAT210415.bacpac" /tsn:localhost /tdn:AxDB210415 /tec:false /p:CommandTimeout=1200
  1. Detach database AxDB with drop connection
  2. Rename UAT###### database to AxDB
  3. Restart IIS and batch service
Was this article helpful? Votes: 0
Article details:
Published date: 28/04/2021 6:39PM
Last updated: 30/11/2022 5:53PM (LS Mark)
Share article: 
Author: LS Mark
Permalink: https://doc.daxonet.com/kb/439298