-
- Service Provider
- Posts: 472
- Liked: 119 times
- Joined: Apr 03, 2019 6:53 am
- Full Name: Karsten Meja
- Contact:
v12 with MSFT SQL
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
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
-
- 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
Why not install V11 and upgrade to 12.1.2.
I don't know if there is any documentation on permissions features etc.
I don't know if there is any documentation on permissions features etc.
VMCE / Veeam Legend 2*
-
- 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
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!
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!
-
- Service Provider
- Posts: 472
- Liked: 119 times
- Joined: Apr 03, 2019 6:53 am
- Full Name: Karsten Meja
- Contact:
Re: v12 with MSFT SQL
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
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
-
- Chief Product Officer
- Posts: 31780
- Liked: 7280 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: v12 with MSFT SQL
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.
-
- Service Provider
- Posts: 472
- Liked: 119 times
- Joined: Apr 03, 2019 6:53 am
- Full Name: Karsten Meja
- Contact:
Re: v12 with MSFT SQL
good point, Anton. Thank you
my only pain point is the update process. For MSSQL it is all in Windows update.
my only pain point is the update process. For MSSQL it is all in Windows update.
-
- Chief Product Officer
- Posts: 31780
- Liked: 7280 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: v12 with MSFT SQL
Yes, we're taking over it's patching as well (when it's installed locally).
-
- Service Provider
- Posts: 472
- Liked: 119 times
- Joined: Apr 03, 2019 6:53 am
- Full Name: Karsten Meja
- Contact:
Re: v12 with MSFT SQL
perfect. good to know
-
- Expert
- Posts: 128
- Liked: 40 times
- Joined: Nov 02, 2019 6:19 pm
- Contact:
Re: v12 with MSFT SQL
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.
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.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
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?
Who is online
Users browsing this forum: No registered users and 51 guests