Best way to backup Native DB?

slmaluwa
slmaluwa Member Posts: 366
edited 2008-04-27 in NAV/Navision Classic Client
Hi all

Currently my DB size is around 25GB and it still Native. (Moving to SQL is on the cards, anyway).

What is the best possible way to take the backup overnight? Whether to use the Backup feature of the Navision it self or taking the copy of the DB after shutting down the service?

I currently have a script running during the night to
1. Shutdown the service
2. Compress the DB using WinRAR
3. Copy to an external Drive
4. Restart the server

Expect your experience and opinions

TIA
"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."

Comments

  • Oneway
    Oneway Member Posts: 53
    You should be able to use Hotcopy to do this.

    You can also create a windows schedule task and call a bat then call the hotcopy.

    There are lots examples if you search the forum
  • stryk
    stryk Member Posts: 645
    Well, actually "HotCopy" is not a "Backup" solution in the original sense - it's a "Replication" feature.

    Automatic native backups (FBK) could be created with ExpandIT utilities:
    http://www.expandit.com/templates/expandit.asp?catalog_id=616
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • slmaluwa
    slmaluwa Member Posts: 366
    ok, so which will be the better method for a faster recovery?

    I think the copying the full DB is better because, to disaster recovery process, I just need to copy it back to the location.

    What do you all think?
    "A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
  • garak
    garak Member Posts: 3,263
    for an faster recovery its better to use tools like HotCopy.

    Restoring an *.fbk file can be take a long time.
    Do you make it right, it works too!
  • Waldo
    Waldo Member Posts: 3,412
    I agree with Garak.
    You can do it online ("hot"), and recovering is just copy/past... .

    You can always add some kind of zip-function in the batch routine to make your files smaller.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • bbrown
    bbrown Member Posts: 3,268
    Hotcopy can be used to maintain a warm standby server. Just install the NAV server (not running) on a second computer and configure Hotcopy to backup the live db periodically to that computer.

    If the main server fails you just need to start the service and have users connect to the second computer.
    There are no bugs - only undocumented features.

Categories