The issue I am seeing is that when a restore of a 2TB standalone database "A" is going on and a log backup of the a AAG database "B"is launched, the backup fails when it tries to collect the filegroups for database "B". The backup software fires the following query
SELECT groupname, status FROM ..sysfilegroups
The query fails with erro 927 and the description is
Database 'A' cannot be opened. It is in the middle of a restore
The SQL Admin claims there is no dependency of "A" on "B".
Does anybody have any idea on why this would be happening?
Any way for me to find out if there is actually any dependency between A and B using sql queries?