Accessing Remote/Archive data in union query using Linked Server

1. Create a table in  source database instance

2. Create a table in  remote/archived database instance with the same datatype as that of the source table.

3. Now we can combines the results of production and archived data result set  into  single result set that includes all the rows that belong to all queries in the union.