I am trying to query a msdb view on a linked server instance and the query returns results from the local msdb view. The same query works on databases when the linked server is not a named instance. Here's the query...
WHERE database_id = 8
In your linked server properties, under server options, make sure that Data Access is set to true.
You could also try using an open query.
FROM OPENQUERY([server\instancename]), 'SELECT db_name([database_id])
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed