Demo Database

navisionerin
navisionerin 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

  • ShaiHulud
    ShaiHulud 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
  • navisionerin
    navisionerin Member Posts: 161
    @ShaiHulud this is when it is uninstalled, where can I find it once its installed on my machine
  • ShaiHulud
    ShaiHulud 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
  • navisionerin
    navisionerin 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?
  • sathishmadhav
    sathishmadhav Member Posts: 71
    @navisionerin you mean backup file taken backup from Nav application? or the FOB files itself
  • navisionerin
    navisionerin Member Posts: 161
    @sathishmadhav I mean the original database. is it stored somewhere after the installation.. I need this file
  • navisionerin
    navisionerin Member Posts: 161
    ooh right, thanks!

Categories