
Hi All,
what is the best pratice...for Retore Database Production/Live To UAT.
i have to do this for demo on client.
The first step I did was back up the database with the .bak extension
the second step is to restore the LIVE database backup file to the UAT database.....after finished restore, i try restarting one AOS nodes.....but sync database always started
if i try backup with extension .bacpac on procces found error "exception of type"System.OutOfMemoryException" was thrown.(mscorib)
if i try with command for backup extension .bacpac....the command below
SqlPackage.exe /a:export /scs:"Server=xxx-D365-SQL1.xxx.local;Database=AXDB;Trusted_Connection=True;" /tf:"H:\BACKUPAXDB08112022.bacpac"
found some error attahed
Hello Windu Dwima,
Restoring LIVE database to UAT for D365FO on-premises, is basically same process as that of AX 2012.
Before restoring the .bak file, please, turn of the AOS's, MR, SSRS machines.
Once restoration is complete. Turn on the machines and you are good to go.
I still did same things few days ago.