Navision Data Backup

shillu

Hi All,

Is it possible to take daily data backup instead of taking full database backup everyday?
suppose my full db size is 2GB and i have added 100 KB of data today, at the end of the day
i want to take backup of only 100KB of data but not 2GB+100KB.

My client is using Nav 4.0SP3 native version. I am sure it is not possible with native version.
Will it be possible if my client migrates to SQL version? If yes, could you please explain me in detail.

Thanks,

Belias

You're correct: native db does not allow this.
I am not a sql expert but i know that transaction log backup is possible (you can see the transaction log as the +100KB of difference between one day and one other).
Search the sql general section, to investigate what can be your best backup strategy

kapamarou

I think you are referring to a differential backup. Read the SQL documentation about backing up data.

shillu

Thanks All..

I will check and get back to you incase of any issues.