[SOLVED] Where can I save VM-data backup?

[Sarge]

I installed a new PBS 2.4 server, everything works well virtual machines from PVE are backed up normally.
But I have a question, Where to save backup-agent data from virtual machines?

That is, I have a backup of MSSQL, Postgres, macroscope..etc, which are done on virtual machines directly.
And I don't know where to save them? PBS is only for virtual machine snapshots!

Is it possible, to somehow organize the SMB resource(storage) on the PBS server?
Or maybe there are some other solutions, please tell me..

 

[MarkusF]

Hello,

you could use the proxmox-backup-client to backup data inside of a vm.

https://pbs.proxmox.com/docs/backup-client.html

Or you could just send your backups via rsync/ssh to the pbs server.

 

[Sarge]

Hello,
you could use the proxmox-backup-client to backup data inside of a vm.
https://pbs.proxmox.com/docs/backup-client.html

Yes, thanks, I know about proxmox-backup-client, this is an analogue of the acronis-agent.
But it does not suit me, because internal backups of windows virtual machines require an external SMB resource(network disk).
I have a lot of such Windows machines that require data(SQL, macroscop, etc) to be saved on just such an SMB resource.
Of course, I can first make a backup locally, and then copy it to the PBS, but this is inconvenient
What else can be done?

 

[Xeata_James]

Are you saying that you have a backup system (not Proxmox) running inside of your Windows server - i.e. HyperV - and you want THAT to have somewhere to backup to? Seems a very bad idea, but in case this is your scenario, you could spin up a Samba server on a PVE Container outside of your HyperV environment, backup the HyperV machines to it and it, in turn, would automatically be dedupe/backed up to PBS.

 

[Sarge]

Are you saying that you have a backup system (not Proxmox) running inside of your Windows server - i.e. HyperV - and you want THAT to have somewhere to backup to? Seems a very bad idea, but in case this is your scenario, you could spin up a Samba server on a PVE Container outside of your HyperV environment, backup the HyperV machines to it and it, in turn, would automatically be dedupe/backed up to PBS.

No, I have a cluster with three PVE nodes, and PBS server.
And Windows VM(with SQL) inside cluster.
SQL makes a backup using its maintenance plan(SQL agent), how do I save it to PBS directly?

 

[Xeata_James]

No, I have a cluster with three PVE nodes, and PBS server.
And Windows VM(with SQL) inside cluster.
SQL makes a backup using its maintenance plan(SQL agent), how do I save it to PBS directly?

Right. Two options:

• Create a share on any one of your VMs or CTs and do the SQL dump to there. It will be backed up by PBS as usual.
• Just do a Snapshot backup of your SQL server - it captures all of the ram/temp files.

I was once a MSSQL Certified Database Admin and Developer - so I understand the perception that you need a proper dump to ensure you have everything, but in my experience, doing a Snapshot backup takes care of that problem.

But if you're the DBA, you'll need to make that call. In fact, you can do BOTH - Snapshot the SQL Server as well as do the proper SQL Dump. This would be your "belt and suspenders" solution. Just ensure that the SQL dump is done well before backup time.

 

[Sarge]

Right. Two options:

• Create a share on any one of your VMs or CTs and do the SQL dump to there. It will be backed up by PBS as usual.
• Just do a Snapshot backup of your SQL server - it captures all of the ram/temp files.

SQL makes a backup every hour, I want it to be directly copied to pbs!
Ok, If this is not possible, I will make an intermediate copy on the virtual machine itself(which is not very convenient), and then copy the data through proxmox-backup-client to PBS. I will run the client every night, so as not to confuse ..
This will be an additional point of failure, but apparently there is nowhere to go :-(

P.S. ...for now, there is no windows client for pbs available. what might work though is to share a drive under windows with smb and mount it on a linux machine and backup it from there with proxmox-backup-client.
So this scheme is impossible too..

 

[Xeata_James]

SQL makes a backup every hour, I want it to be directly copied to pbs!
Ok, If this is not possible, I will make an intermediate copy on the virtual machine itself(which is not very convenient), and then copy the data through proxmox-backup-client to PBS. I will run the client every night, so as not to confuse ..
This will be an additional point of failure, but apparently there is nowhere to go :-(

P.S. ...for now, there is no windows client for pbs available. what might work though is to share a drive under windows with smb and mount it on a linux machine and backup it from there with proxmox-backup-client.
So this scheme is impossible too..

I think it would be unwise to treat your PBS as a "cobbled-together" samba file server. PBS is for backing up Proxmox PVE containers and vms.
It could be done, but you have no idea of the unintended consequences that could arise on the next upgrade.

 

[Sarge]

Ok, I will do according to your first option, from an internal virtual machine with a smb backup resource.
Thank you!

 

[Xeata_James]

To be clear though, you can backup your MS SQL server hourly to PBS. Just schedule an hourly backup job and it's done. No windows client required. I backup my Windows server daily and it is no different than my dozens of Linux servers.

 

[Sarge]

Earlier I thought about the same as you. But I was convinced that the sql-agent makes more consistent backups, than proxmox snapshot.
I will only be glad if this is not the case and I can make reliable backups directly in PBS