Comprehensive data protection for all workloads
Post Reply
karsten123
Service Provider
Posts: 472
Liked: 119 times
Joined: Apr 03, 2019 6:53 am
Full Name: Karsten Meja
Contact:

v12 with MSFT SQL

Post by karsten123 »

Hi,
i have to install a new VBR v12.1.2 server with MSFT SQL.
Is there any documentation for installing the SQL server express just like the v11 setup does.
Permissions, features, …

Thanks in advance
Karsten
mjr.epicfail
Veeam Legend
Posts: 377
Liked: 113 times
Joined: Apr 22, 2022 12:14 pm
Full Name: Danny de Heer
Contact:

Re: v12 with MSFT SQL

Post by mjr.epicfail »

Why not install V11 and upgrade to 12.1.2.
I don't know if there is any documentation on permissions features etc.
VMCE / Veeam Legend 2*
PetrM
Veeam Software
Posts: 3618
Liked: 607 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: v12 with MSFT SQL

Post by PetrM »

Hi Karsten,

Would you please clarify what v11 setup documentation are you referring to? If you're going to use a new database, the account specified in the install wizard must have CREATE ANY DATABASE, or ALTER ANY DATABASE permission. If the database already exists, the account must have db_owner role. Also, you may try to create a test database manually using SQL Server Management Studio to make sure that the account has all the necessary permissions.

Thanks!
karsten123
Service Provider
Posts: 472
Liked: 119 times
Joined: Apr 03, 2019 6:53 am
Full Name: Karsten Meja
Contact:

Re: v12 with MSFT SQL

Post by karsten123 »

Hi Petr,

thanks. Im after the lazy approach. I just want to install SQL the way the v11 setup did but with a 2022 SQL and go on with the v12 setup, select SQL, next, next, finish.

Best regards
Karsten
Gostev
Chief Product Officer
Posts: 31780
Liked: 7280 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: v12 with MSFT SQL

Post by Gostev »

We don't recommend using SQL for new installs, especially SQL Express due to all its limitations. Plus in general SQL is a dead end as eventually we will drop its support completely. And even before that happens, some new capabilities will *require* Postgre to function.
karsten123
Service Provider
Posts: 472
Liked: 119 times
Joined: Apr 03, 2019 6:53 am
Full Name: Karsten Meja
Contact:

Re: v12 with MSFT SQL

Post by karsten123 »

good point, Anton. Thank you

my only pain point is the update process. For MSSQL it is all in Windows update.
Gostev
Chief Product Officer
Posts: 31780
Liked: 7280 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: v12 with MSFT SQL

Post by Gostev »

Yes, we're taking over it's patching as well (when it's installed locally).
karsten123
Service Provider
Posts: 472
Liked: 119 times
Joined: Apr 03, 2019 6:53 am
Full Name: Karsten Meja
Contact:

Re: v12 with MSFT SQL

Post by karsten123 »

perfect. good to know
JPMS
Expert
Posts: 128
Liked: 40 times
Joined: Nov 02, 2019 6:19 pm
Contact:

Re: v12 with MSFT SQL

Post by JPMS »

Gostev wrote: Jun 19, 2024 7:29 am We don't recommend using SQL for new installs, especially SQL Express due to all its limitations. Plus in general SQL is a dead end as eventually we will drop its support completely. And even before that happens, some new capabilities will *require* Postgre to function.
Mildur wrote: Jul 11, 2023 11:44 am Hi Florian

It's just not recommended. But still supported.
If you use a Veeam Agent to backup the backup server, you won't face the issues (disconnection) mentioned in the user guide. That normally happens when you run a VM snapshot. The VM can be frozen for a few seconds. Veeam Agent does not create VM snapshots....

Best,
Fabian
I appreciate it is not best practice but we use Veeam Agent for Windows to backup our Veeam server. We aren't big enough to have a DR site and it may save us having to do a full rebuild in the event of an issue. We do it outside of hours that it will be running any backups and we also backup the Veeam server configuration as a fall back.

With the move to PostgreSQL, will PostgreSQL support be added to Veeam Agent for Windows or does it not matter if we only ever envisage doing a full restore of the server?
Post Reply

Who is online

Users browsing this forum: No registered users and 51 guests