Its not the matter of restoring.

If I do a normal select query i get the error.

In server A if i execute the query as

select * from B.databsename.dbo.Tablename

I get the error