We are running stored procedures from a 'central' SQL server database A that reads data from a different database B on the same SQL server (SQL Server 2019 Standard edition). Yet, meanwhile another database C on that same server is restoring (not the one we are reading from) and sometimes (not always) we receive the error: "Database 'C' cannot be opened. It is in the middle of a restore."
Thus, while executing a stored procedure on A selecting data from B, we receive the error that C is restoring...
Note that all of the mentioned databases reside on different files.
Any solutions to avoid this issue?