[GUIDE] How To deploy & schedule Veeam Agent Protection Group MS Cluster step by step


Userlevel 7
Badge +7

How To deploy Veeam Agent Protection Group

Are two physical nodes of an MS cluster and MSSQL instance in the cluster

Reference:

Installing Veeam Agent for Microsoft Windows - Veeam Agent for Microsoft Windows Guide

Getting Started - Veeam Agent for Microsoft Windows Guide

Installation and Configuration - Veeam Agent for Microsoft Windows Guide

  • Create new Protection Group

The account used to perform a consistent backup of an MSSQL DB must be entered either in the Local group Administrators or enter the user side MSSQL studio with permissions of DBA Admin\Owner.
You require different sets of Microsoft SQL permissions in the following cases:
Installation (remote or local): current account needs CREATE ANY DATABASE permission on the SQL server level. After database creation this account automatically gets a db_owner role and can perform all operations with the database. If the current account does not have this permission, a Database Administrator may create an empty database in advance and grant the db_owner role to the account that will be used for installing Veeam Backup & Replication.
Upgrade: current account should have sufficient permissions for that database. To grant these permissions through role assignment, it is recommended that you use the account with db_owner role.
Operation: the account used to run Veeam Backup Service requires db_datareader and db_datawriter roles as well as permissions to execute stored procedures for the configuration database on the Microsoft SQL Server. Alternatively, you can assign db_owner role for this database to the service account.
  • I prefer check only Install backup Agent & Install driver CBT.
  • I don’t use “Auto-update agent” for unexpected event.
  • I don’t use “Perform reboot automatically” for unexpected reboot or pending reboot on production servers.
  • Create New Job Windows Agent

 

  • Check first your recovery model:

How to back up a SQL Server transaction log (veeam.com)

  • Only databases in Full or Bulk-logged recovery models have their changes recorded to a SQL transaction log file, making recovery to a specific point-in-time possible. Make sure your database is in a Full or Bulk-logged recovery mode.

Set database recovery model - SQL Server | Microsoft Docs

 

 

 

 

Lunch your new Agent job and check it

enjoy


7 comments

Userlevel 7
Badge +20

Cor, @Link State that’s a hefty blog post there! Made for a good morning read!

Userlevel 7
Badge +17

Very detailed topic 😎
Have to take some time to get it all...

Userlevel 7
Badge +9

Thank you @Link State for sharing 

Userlevel 7
Badge +8

Nice article, @Link State . You can use the ad cluster object too for cluster :)

https://www.veeam.com/kb2463

Userlevel 7
Badge +12

Great guide and very detailed, thanks @Link State 

Userlevel 7
Badge +7

Nice article, @Link State . You can use the ad cluster object too for cluster :)

https://www.veeam.com/kb2463

 

this is object cluster :)

 

Userlevel 7
Badge +8

Nice article, @Link State . You can use the ad cluster object too for cluster :)

https://www.veeam.com/kb2463

 

this is object cluster :)

 

Well, i need to repair my glasses 🤓

Comment