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."
0
Comments
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
Automatic native backups (FBK) could be created with ExpandIT utilities:
http://www.expandit.com/templates/expandit.asp?catalog_id=616
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool
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?
Restoring an *.fbk file can be take a long time.
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
If the main server fails you just need to start the service and have users connect to the second computer.