SQL requirements revisite regarding model role settings

[Djura]

Hello,

I would like to place an Enhancement request for the following (reference support case : 01760618):

In the Veeam requirements regarding SQL Backup support and roles it states the following :
SQL system databases (master, msdb and model): db_backupoperator, db_datareader, public;
SQL non-system databases (User databases): db_backupoperator, db_denydatareader, public;

But we would need to the following configuration (because of security and compliancy policies):
SQL system databases (master, msdb): db_backupoperator, db_datareader, public;
SQL system databases (model): db_backupoperator, db_denydatareader, public;
SQL non-system databases (User databases): db_backupoperator, db_denydatareader, public;

Because otherwise (since the model database is the template system database which is used for creating new user database) we will have to change after creating a new user database each time the "db_datareader" option for that database to what it should be "db_denydatareader".
So in short, because of the restrictions regarding the Veeam support requirements of the supported roles, the model database cannot be used (as it is designed by Micorosft) as a template for future creation of new user databases, except
if we (like mentioned earlier) change the role setting each time after creating a new user database.

So please revise this support statement, so that we are able again to use the system database "model" as a template for new database creation.

Thanks in advance for the help!

[Gostev]

Hi, Djura. Thanks for your feedback, we will investigate if this is possible.

[Djura]

Hello Anton Gostev,

Do you have any update on the status of the investigation regarding my enhancement request?

Thanks in advance, Djura