We're just implementing VEEAM and have come across some issues in our SQL Server Environment on instances that are no longer running. VEEAM presents OLEDB connection error warnings on these instances. There are other SQL instances running on the same sever so I'd like to exclude the instances and not the servers.
The long term plan is to get rid of those SQL instances, but for now instance exclusion is the desired option.
We've enabled the "EnableDBExclusions" Registry entry to give us the option to exclude databases from the nightly backup jobs, but this requires the addition of a single database to exclude rather than an entire instance.
Also for Transaction Log Backups via the Application aware backups, I know from the Deep Dive Webinar that we need to edit the SqlBackupDatabaseToSkip. However, in the webinar it is demonstrated how to exclude an instance name, a database name on an instance name and a database name with the following entries:-
If for example we had a SQL Server with three instances on it:-
So my questions are:-
1. How would I exclude the SQLServer01\Ins1 in the full backup overnight job using the Database Exclusions options in the GUI?
2. How would I exclude the SQLServer01\Ins1 instance in that registry key?
Thanks in advance for any help received.