Database restoration in finance & operations D365 AX
******************************************************************************* 1.Run command prompt as an administrator. 2.Run the below command to Import the database. cd C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin SqlPackage.exe /a:import /sf:J:\BackupFile.bacpac /tsn:localhost /tdn:AxDB_New /p:CommandTimeout=1200 where, •tsn (target server name) – The name of the SQL Server to import into. •tdn (target database name) – The name of the database to import into. The database should not already exist. •sf (source file) – The path and name of the file to import from. ********************************************************** Go to > windows > Microsoft SQL server Tools > Microsoft SQL server Management > run as Administrator use > sql server Authentication > user "axdbadmin" and respective password (from LCS) Execute below queries one by one :- USE [AxDB_New] GO CREATE USER axdeployuser FROM LOGIN axdeployuser EXEC sp_addrole...