Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 8654 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

    Hi,

    We are currently developing a DR solution on v5.2.1 R2. The hope is that we can bring up a VM clone of the SEC server in a DR site and repoint the SQL connection string to the mirrored SQL server in that site.

    Do you know if the Sophos installer writes anything to the SQL system databases? I ask because I know of other products that support SQL mirroring where you need to restore the MSDB from the primary server to the mirror server before the mirror server will work.

    Cheers

    :51202
Reply
  • 0

    Hi,

    We are currently developing a DR solution on v5.2.1 R2. The hope is that we can bring up a VM clone of the SEC server in a DR site and repoint the SQL connection string to the mirrored SQL server in that site.

    Do you know if the Sophos installer writes anything to the SQL system databases? I ask because I know of other products that support SQL mirroring where you need to restore the MSDB from the primary server to the mirror server before the mirror server will work.

    Cheers

    :51202
Children
No Data