web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Issue when BackUp/Export Data Tier Application .bacpac on-prem

(0) ShareShare
ReportReport
Posted on by 35

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

I have the same question (0)
  • Suggested answer
    Komi Siabi Profile Picture
    13,109 Most Valuable Professional on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 490 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans