Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Restore empty database...
Finance | Project Operations, Human Resources, ...
Answered

Restore empty database on D365 FO VM

(1) ShareShare
ReportReport
Posted on by Ammad majid 30
Hi community,
 
I am trying to restore empty database on one of our client development D365 FO VM.  I am following this blog step 2: http://sinedax.blogspot.com/2017/10/empty-database-in-your-vhd-all-in-one.html.
 
On step 2, it is mentioned that there is backup file named // present in C drive under MS SQL server folder. But when I checked it in the SQL server folder in C drive, I did not find any backup file having name //. I checked all the folders in C drive but could not found. 
 
Questions 1:
Where can I found this // backup database file?
 
Question 2:
If I restore the empty database, what could be the optimal way of transferring data from these tables into new database. Is the empty database contain these tables? If exist, should I use the SQL import / export wizard? Or any other best way. If not exist, should I create new tables and transfer data into them?
 
Has anyone done this activity before? please share the steps  
 
 
  • Suggested answer
    Ammad majid Profile Picture
    Ammad majid 30 on at
    Restore empty database on D365 FO VM
    Hi community,
     
    After searching, I found that in LCS shared asset library, MS provided empty and demo database .bak files for various versions. Once you get to know what your D365 F&O version is by searching in the About section, you download your respective empty database version from LCS.
     
     
    After downloading, take backup of existing AxDB database for safe side, delete it and restore the new empty database from LCS -> Model section.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,684 Super User 2024 Season 2 on at
    Restore empty database on D365 FO VM
    Hi Ammad,
     
    This is a quite old blog. I haven't seen or searched for this file for a while. Denis also listed a link to one of my blogs, which is not available anymore on that location. I moved all my blogs to a personal blog site. Here is the link to my blog about an empty database: How to start with an empty AX database in your local VM (dynamicspedia.com)
     
    Can you also elaborate on what you mean with "these tables into new database"?

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans