Host-based backup of VMware vSphere VMs.
Post Reply
Backup.Operator
Enthusiast
Posts: 65
Liked: 1 time
Joined: Oct 31, 2022 11:39 pm
Full Name: Backup Administrator
Contact:

PostGre SQL vs SQL Express benefits

Post by Backup.Operator »

What are the advantages of switching from SQL Express to PostGRE SQL?
Because, as far as I know, neither database has a encircling fee and can be set and forget.

Any assistance would be much appreciated.
:arrow: :mrgreen:
Origin 2000
Service Provider
Posts: 84
Liked: 20 times
Joined: Sep 24, 2020 2:14 pm
Contact:

Re: PostGre SQL vs SQL Express benefits

Post by Origin 2000 » 1 person likes this post

The SQL Express have a 10G size limit which can be reached pretty fast when performing backup of files for example or a huge number of backup job.

Regards,
Joerg
coolsport00
Veeam Legend
Posts: 81
Liked: 15 times
Joined: Sep 11, 2012 12:00 pm
Full Name: Shane Williford
Location: Missouri, USA
Contact:

Re: PostGre SQL vs SQL Express benefits

Post by coolsport00 »

In addition to the 10GB size limit Joerg shared, according to Veeam, PostgreSQL can also provide enhanced performance over SQLExpress, though if you have a nomimal sized backup environment, you probably wouldn't notice. Also, though you can still use SQLExpress if you want, it is no longer packaged with the Veeam installer. You have to install it separately.
Shane Williford
Systems Architect

Veeam Legend | Veeam Architect (VMCA) | VUG KC Leader
VMware VCAP/VCP | VMware vExpert 2011-22
Twitter: @coolsport00
Post Reply

Who is online

Users browsing this forum: ibarizz and 38 guests