From what software to build a backup server?

Question

Backup

There is a server, you need to make a backup server out of it. You need to backup sql databases from several servers, Hyper-v virtual machines, and also some physical servers. Of course, everything is local, for convenience, a remote console (admin tool). If it is important - on a RAID server.
I wanted to try acronis, but something is stopping me!

Answer 1

You have a bunch of horses and people. A backup server is, rather, just a piece of hardware on which you can add backups over the network. What you're asking about is just software, backup software.
In fact, don't care what to back up :-) All these systems have their own bells and whistles. For virtualization, Veeam is now the most popular. If your SQL servers are virtual, and on MS SQL or Oracle, then Veeam will do. There is also Veeam for physics, they just recently released an agent for backing up physical windows servers. They have been able to back up physical Linux servers for a long time.
Acronis, on the contrary, started as a backup for physical servers, and only then added the ability to backup virtual machines. In general, radish horseradish is not sweeter, try a few on test stands and decide for yourself what you like best.
And RAID is there on your server, or not - this is the tenth thing, it has little to do with the backup process.

Answer 2

Do it on Linux. Raise a samba, rummage a directory and pour backups. If there is a hardware raid, it's great, if not, and the hardware is budget, then assemble a software RAID1 (mdadm). Make a backup with the standard Windwos Server Backup out of the box, as well as SQL. Database. I would not backup entire virtual machines, only the system state and data. (This is my opinion)
If you want to play it safe, then pay attention to regular VM replication in Hyper-V.

Answer 3

Options:
1. Soft backup server (program). She connects to those things that need to be backed up and does everything herself. As a rule, it costs a lot of money, but it is convenient to administer and maintain.
2. A certain file resource where all these servers, DBMS, etc. pour their backups. You can lift it on anything, Samba is the cheapest.
notes:
1. HyperV backups itself perfectly
2. MS SQL too