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

Sarge

Active Member
Dec 17, 2015
28
2
43
49
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..
 
Last edited:
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?
 
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.
 
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?
 
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.
 
  • Like
Reactions: 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..
 
Last edited:
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.
 
  • Like
Reactions: Sarge
Ok, I will do according to your first option, from an internal virtual machine with a smb backup resource.
Thank you!
 
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.
 
  • Like
Reactions: 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
 
Last edited:

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!