Post reply

Linked Servers and a Mirrored database

  • May 19, 2010 at 10:26 am

    #222713

    Has anyone successfully configured a linked server to access a mirrored database using the SQLNCLI provider? I can get it to access the database on the principal server using info from BOL, but when I fail the database to the mirror server, no luck accessing the database.

    Any hints or suggestions (besides don't do it) would be helpful.

    Going to try the ODBC provider and see if I have better luck there.

  • May 19, 2010 at 4:39 pm

    #1169802

    I may have figured this one out, but i still have a few issues to try and iron out. One of them is a small problem, the first query run after failover fails. If I refresh the linked server after doing a manual failover, not problem.

    Anyone know how to refresh a linked server besides running a query against it?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply