I am currently working with 2 sql 2000 servers one I can query but not add any databases to which lead to the second one having lots of queries that use the first as a linked server. I would like to improve performance while still querying live data.
Is it possible to mirror the live data to the second server, that way the queries would be local to that server? What are my options?
If an upgrade from sql 2000 is needed that is a possibility.
The data has low update, insert, delete use and high select use so I think this would be ideal if possible.