SQL Backup Agent Not Starting Automatically at Server Restart
I have 2 SQL Server Instances running on the same Windows 2016 Server. Last night when the server was restarted for a unrelated update we notices 1 of the 2 SQL Backup Agents started but the other didnt, even though they are both set to Automatic.
Digging through the event log, we have discovered that it looks like both instances are writing to the same log at start up in "C:\Program Files (x86)\Red Gate\SQL Backup 10\Server_1\SQBCoreService_log.txt".
Example of Error from logs below
Service failed on start: Cannot open file "C:\Program Files (x86)\Red Gate\SQL Backup 10\Server_1\SQBCoreService_log.txt".Is there a way to easily resolve this please.
There doesn't seem to be any obvious option in settings to change this. Looking at the log type options I can see, both server instances are writing to their own unique log apart from this startup option by the looks of it
Any guidance would be appreciated