Restore (backup) Scheme for VM with rapidly changing data?

R

ronejamesdo

Member
Apr 22, 2024
57
6
8
I have a SQL server with its database stored on a dedicated (virtual) hard drive (the operating system is on another). I would like to be able to do two different types of restoration from backups.

In one instance, the whole server has crashed and I just want to restore the whole thing as it was (that's what's there now).

In another instance I have (perhaps) mangled the OS somehow and want to restore only the OS drive but leave the database current to the moment that I begin the restoration.

Is there a way to do this? (So far the best I can do is to exclude the SQL storage drive from the backup itself, which would work for a manual "pre-updates" type of backup, but of course I couldn't leave it that way for ongoing nightly backups.) I would like to know if there's just a command line to exclude one of the drives from restoration or if there is some way that I could schedule both types of backup (ie, at night take a full backup, and also take an OS drive only backup, so that I could choose either when needed).

Thanks.
 
I have not played with this in a while, so I recommend that you try this first on a test VM:
proxmox-backup-client catalog vm/100/2025-06-01T10:00:00Z
proxmox-backup-client restore vm/100/2025-06-01T10:00:00Z drive-scsi1.img.fidx /tmp/drive-scsi1.img

The CLI does not understand storage pools. You could write to STD and pipe to a pre-allocated disk, whether the corrupted one or new disk. If new, you'd need to swap it within the VM when ready.

Try it and let us know if solves your challenge.

Cheers

Blockbridge : Ultra low latency all-NVME shared storage for Proxmox - https://www.blockbridge.com/proxmox
 
Sorry, I should have added "noob question" to my subject. Do these commands imply the Proxmox Backup Server? (I am just using web-interface configured backups to mounted storage.)
 
There may be an option/way in GUI to do the same, I am not sure.
Plugging the "proxmox-backup-client" into Google brings up https://pbs.proxmox.com/docs/backup-client.html - i.e. this is the Proxmox client tool for PBS based backups.

You can also find corresponding usage information in "man proxmox-backup-client"

Blockbridge : Ultra low latency all-NVME shared storage for Proxmox - https://www.blockbridge.com/proxmox
 
You must log in or register to reply here.
Top Bottom
Back