DB in 2000 use 2005DB which is mirrored RRS feed

  • Question

  • Hi,
    My DB is in SQL2k3 Sever, has linked SQL2005 server.
    DB in 2k3 has views, that fetches data from views in DB
    in 2005 linked server.

    Now this 2005 DB is mirrored. When SQL2005 server has downtime
    my app does not work,as it can find linked server.
    How do i handle that in my SQL 2k3 DB's views..?

    Please let me know what my approach should be in this case...
    Monday, June 7, 2010 4:57 AM


  • Hi,

    When you prepared the database mirroring, did you copy the linked server definitions from the principal server to the mirror server. If you only copy the user databases from the principal server to the mirror server, the linked server definitions cannot be created in the mirror server. To work around the issue, generate the scripts for the linked server in the principal server and execute the scripts in the mirror server.

    If you have any more questions, please let me know.

    ***Xiao Min Tan***Microsoft Online Community***
    Friday, June 11, 2010 1:58 AM