Hello to all,
I am happy to have contact with high qualify people in this community we using Microsoft Dynamic NAV 2013 in our office with SQL Server 2012 I setup the auto backup system in SQL 2012 for daily base does the NAV backup include just database or also need to backup the logs as well as Dynamic Setup and customization?
looking for further support.
Best wishes
*This post is locked for comments
Hi,
Full SQL Backup on daily basis is always advisable. This again depends on the DB size.
Full backup would include the entire database (Data & Customizations)
Also in case of Full Recovery model, one should schedule the daily log backup to avoid increase in Log File Size.
Regards
Vishal Salot
If anyone answers helped you, please mark it as verified (always)....
You just need to backup your SQL database.
SQL full database backup will have everything including data, objects, business logic.
We usually recommend to do full backup on a daily basis. In case of large databases, an incremental backup can be made, but it is more time-consuming to restore if needed. Also, pay attention to the hard drive array for your database. Absolute must to have it RAID 1 or RAID 10 (mirroring of drives).
Hello,
Database backup includes everything data and the objects, you don't need a separate log backup for Dyanmics Setup and customization. It is recommended to have a daily database backup and schedule transaction log backup for every few hours to minimize work loss in case of a failure and the log backup will help to reduce the size of the transaction log of the database.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (