Fun Friday #52: Which Database will you be using in v12?

we will stay with MS SQL 2019 Std. but plan to “migrate” to an AlwaysOn cluster and separate the Veeam databases. especially the VeeamOne DB can grow a lot.. from the performance perspektive it´s not needed but well..

best regrads
daniel
 

We have several customers who need the MS SQL Standard Edition at this time.
To reduce costs, we will migrate them after a test period to PostgreSQL.

All other customers… we will see, but I think we will migrate them to PostgreSQL in the future, too. Then all environments are on one standard again.

For the most environments I would suggest to stay at MS SQL Express. It’s proven to work stable and there’s more experience around MS SQL maintenance then PostegreSQL.

If one does hit the SQL Express limitations or experiences performance impacts, then PostgreSQL will be the way to go; or at least should be evaluated.

Not sure yet. I was on SQL, but went to SQL express during a reload of my Veeam server in a pinch.

I keep my config backup pretty safe, so I’m never too concerned, other than the fact it’ll take days to scan all my tapes like last time if the server has to import all the configs. 

Looking forward to moving over to Postgres so we can save on SQL licensing as that is the biggest thing for us.  We will move one or two to start and see performance first prior to a wholesale change for all sites.

Some good conversation here, I’m still honestly expecting most of my customers to remain on SQL Server, as I can’t see a lot of willingness for DBAs to let us use production SQL instances as staging servers, I can certainly see some scenarios where it makes a lot of sense though.

I voted Postgres, but I have to evaluate.  My Postgres experience is pretty minimal, but for our SMB client base, Standard is overkill.  On the same note, on our Service Provider Console, I ran over the 10GB limit after about a year with only about 20 clients in it, so if they can get that moved over to Postgres, that would be great though I have already migrated it to SQL Standard at this point.

VSPC doesn‘t get PostgreSQL support in the next version.

Only VBR does.

We are happy to hear about that request in the RnD forum:

https://forums.veeam.com/veeam-service-provider-console-f42/feature-request-postgres-for-vspc-t78807.html

I will selfishly wait for feedback on postgresql especially on windows :), maybe in v12a or v13!

Hello,
I'll probably wait a bit before migrate my existing clients to Postgres, except for the ones who arrive to SQL Express limits.

For new installation I will probably install Veeam with Postgre except if my client have some needs for specific dev.

On the VSPC side, I ll stay in SQL Standard cause Postgre is not supported as Veeam One.

In the security view I don’t know if Postgre is more secure than MS SQL or if we need to apply some hardening too.

i will probibly use postgres with new deployments,, wont be migrating customers over on current setups unless there is a technical need to do so.