Is there a PowerShell command for working with MSSQL Database Exclusions?

[i3uln]

Hello !

First, I opened ticket Case# 07791345for this request. [Moderator: Added Case #]

My new customer has dozens of MSSQL servers and hundreds of database instances.

Due to the customer's DB environment, MSSQL backups cannot be performed through Veeam.

Interestingly, even when Veeam's application is deactivated, the customer stated that it is not acceptable to view the list of DBs on the MSSQL server.

Therefore, the solution I found was to activate Database Exclusion in Veeam B&R and add the MSSQL server and database instances, which resolved the issue.

However, another issue is that new customers have hundreds of MSSQL database instances.
This results in significant waste of manpower.

Therefore, the customer requested a cmdlet or PowerShell command to perform bulk MSSQL database exclusion as the final requirement before purchasing Veeam B&R.

Is there a way to perform bulk MSSQL database exclusion?

[david.domask]

Hi i3uln,

There is no cmdlet to allow this at this time, and no unsupported methods I can locate either.

Can you elaborate a bit more on what is required here? As per https://www.veeam.com/kb2110, adding the Database Exclusions simply excludes the databases from the VSS snapshot, however if Guest Processing is enabled, to my recollection DB enumeration will still occur.

What actually needs to be protected on these machines if the MSSQL data is protected by another application? Also doesn't Copy-Only option work? I think this perhaps is not an automation request so if you can elaborate on the challenges more it would be appreciated.

[i3uln]

Hello David
As you said, the key point is to exclude the database from the VSS snapshot through https://www.veeam.com/kb2110를.

Since MSSQL is protected by other backups, the customer only wants to perform an Entire Backup of the MSSQL server.

With hundreds of MSSQL Database Instances, the customer does not want to manually add kb2110.

Therefore, I would like to add it in .csv file format if there is an MSSQL Database Exclude cmdlet or powershell.