Creating a Linked Server and Database Alias

Viewed 14323

I have two servers Server1 and Server2

On both servers i have a Database called QAI

is there a way that i can create a linked server with an alias from Server2 to Server1 but instead of Server1.QAI.dbo.tbBlah

Have it aliased as QAI.dbo.tbBlah

This is needed due to the QAI DB on server2 failing and needing to fall back to the Server1 instance while it is fixed

Thanks

3 Answers
Related