Back up to a Local or Network Drive

Help
1

Hi team
I’m using memsql 7.0.16 version and I have done a full database back up to a local:

  • Syntax: BACKUP DATABASE db_ABC TO "backup_path"
    But I can’t perform to backup with differential type:
  • Syntax: BACKUP DATABASE db_ABC TO “backup_path” WITH DIFFERENTIAL
    Please advise me “How to backup with differential?”

Thank so much
Developer
Cuong Nguyen

2

You have to do the first backup with the INIT option. Then you can do subsequent DIFFERENTIAL backups.

3

Hello!

Incremental backups cannot target local disks by design. They need to be targeted at a colocated storage solution like NFS.

This is to allow future differential backups after a node failover, where partitions have been moved in the cluster, and the same configuration of partitions as before is not guaranteed. This makes future differentials impossible if using local disk.

As stated above, you first need to backup WITH INIT before you can do the WITH DIFFERENTIAL option.

I hope that helps!

  • Nate