mibuso.com
Home› NAV Three Tier

Demo Database

navisionerinnavisionerin Member Posts: 161
edited 2019-09-03 in NAV Three Tier
hello, I want to find the original .bak file for the database, not from sql, not from the installation files. Once it is installed, where does NAV store the bak file and where can i access it from?

Best Answer

Answers

  • ShaiHuludShaiHulud Member Posts: 228
    In your installation folder/archive: 
    [..]\SQLDemoDatabase\CommonAppData\Microsoft\Microsoft Dynamics NAV\X\Database\Demo Database NAV (X).bak
    Where X is your NAV version number
  • navisionerinnavisionerin Member Posts: 161
    @ShaiHulud this is when it is uninstalled, where can I find it once its installed on my machine
  • ShaiHuludShaiHulud Member Posts: 228
    Open up (or first install) SQL Server Management Studio (SSMS), connect to your SQL server (if you don't know server name and login details, look for Database Information in the development environment). Then, select the database, make a backup of it (see screenshot below) and then restore that backup to a database with a different name.
    zccr87klk1j8.png
  • navisionerinnavisionerin Member Posts: 161
    @ShaiHulud I am probaly not explaining it correctly. I want to find the original .bak file for the database, not from sql, not from the installation files. Once it is installed, where does NAV store the bak file and where can i access it from?
  • sathishmadhavsathishmadhav Member Posts: 71
    @navisionerin you mean backup file taken backup from Nav application? or the FOB files itself
  • navisionerinnavisionerin Member Posts: 161
    @sathishmadhav I mean the original database. is it stored somewhere after the installation.. I need this file
  • navisionerinnavisionerin Member Posts: 161
    ooh right, thanks!
Sign In or Register to comment.