NAV FDb Backup

navnet
navnet Member Posts: 57
edited 2009-10-28 in NAV/Navision Classic Client
We are planning of taking incremental backup of Navision FDB on the server as a part of disaster recovery plan.

Id there any better way out?

Answers

  • RawHeat
    RawHeat Member Posts: 63
    if you are using SQL server why dont u apply settings such that automatically BAK file is generated daily at a particular time.

    this procedure is followed by most of client and partner companies.
    this will prevent manual work
  • navnet
    navnet Member Posts: 57
    We are using Native database.
  • matteo_montanari
    matteo_montanari Member Posts: 189
    navnet wrote:
    We are using Native database.

    Hi

    On a Native Database, you can only do a complete Backup.

    Bye

    Matteo
    Reno Sistemi Navision Developer
  • RawHeat
    RawHeat Member Posts: 63
    yes so in that case instead of creating a copy of FDB create a backup file i.e. fbk file.

    this will save a lot of ur space too
  • navnet
    navnet Member Posts: 57
    Yeah. FBK we are doing on a manual basis. But JUST in CASE FBK taking is forgotten on missed, I was seeking for some automated backup process.
  • navnet
    navnet Member Posts: 57
    On a Native Database, you can only do a complete Backup.
    What is does complete bakcup signify here?

    We are taking the backup of entire database, but this had to be automated so we chose to use Windows incremental backup.

    My concern is if there is any other way for this with native database?
  • RawHeat
    RawHeat Member Posts: 63
    no u have to manually create backup if it is in NATIVE database
  • DenSter
    DenSter Member Posts: 8,307
    navnet wrote:
    we chose to use Windows incremental backup.
    What's that?

    For native databases you can't do incremental backup, at least nothing that is supported by Microsoft. There's an external product that allows you to schedule it, I believe that was a tool from a company called expandit, but I've never used it myself.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Savatage
    Savatage Member Posts: 7,142
    Using DWNavBackup-Lite from the dowload section
    http://www.mibuso.com/dlinfo.asp?FileID=879

    this is how we do ours
    http://savatage99.googlepages.com/MyBackup.pdf
    By using this method it automatically backup up daily.
    In the morning it takes a 38gb database and give me a 2gb zipped backup
    which can be thrown on a flash drive or uploaded to a ftp site, etc.

    The full version of DWNavBackup-Lite can be found here:
    http://www.navierra.com/en/products.php

    ps: You can find the Expandit Backup Utility here:
    http://www.expandit.com/templates/expan ... log_id=616
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Why don't you just use HotCopy?
    look in Server\program files\Microsoft Dynamics NAV\Database Server on your install CD.
    David Singleton

Categories