Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 8656 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Dabase mirror issues Enterprise 4.5

Wally

I am currently setting up DRP hot site for my servers.

I have mirrored the Sophos SQL2005 database  to a server at the DRPsite.

SQL Server1 = Original site

SQL Server 2 = DRP site

When I failover Server 1 to server 2 , the management console will not work.

How do I tell the management console that if SQL server 1 is down, then just go to SQL server 2.

Is it configured in the registry?

Enterprise 4.5

SQL 2005

:21569


This thread was automatically locked due to age.
Parents
  • 0

    I know this is an old thread, but has support for SQL mirroring been added yet? I have an installation with the DB hosted on an SQL cluster which then mirrors to an offsite location. I'd like to be able to keep a copy of the SEC VM at the DR site and simply connect this to the mirrored database in the event of a site failure.

    Modifying the database connection string in the registry doesn't work.

    Cheers

    :51118
Reply
  • 0

    I know this is an old thread, but has support for SQL mirroring been added yet? I have an installation with the DB hosted on an SQL cluster which then mirrors to an offsite location. I'd like to be able to keep a copy of the SEC VM at the DR site and simply connect this to the mirrored database in the event of a site failure.

    Modifying the database connection string in the registry doesn't work.

    Cheers

    :51118
Children
No Data