Native database backup, can you backup keys

themave
themave Member Posts: 1,058
edited 2006-03-26 in NAV/Navision Classic Client
The restore process is so slow because the system has to create all the keys to complete the process. I would rather have a larger backup file and faster restore (recovery) then the current, which is a smaller backup file, but slow restore.

I know all about hotcopy, but I am interested if anybody knows how to modify the native database backup to include the keys two. I guess the restore routine would also have to be modified to know the keys are there.

any ideas ?

Comments

  • Savatage
    Savatage Member Posts: 7,142
    For us, I just added a 80gb hard drive - mapped it and at the end of the day when everyone is out just copy the entire file from the server to that drive using a batch file.

    quick copy & quick restore. hopefully never necessary but the restore takes as long as a 17gb file can be transfered from 1 drive to the other.

    works for us.

    copy n:\database.fdb z:\backup\database.fdb

    obviously this method does not work if people are still logged into the database but this is not a problem for us.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Waldo
    Waldo Member Posts: 3,412
    I recommend to add the "net stop" and "net start" to the bat-file, just to be sure to back up a consistent copy of your fdb.

    HOTCOPY works well too (when you don't want to stop the database server). basically, it's just copy-ing a database server when it's still online. You have the option to do a daily test as well wity HOTCOPY.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog

Categories