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.
  • 0

    HI,

    I don't think is is supported, Sophos supports a clustered SQL instance but it is a 1-1 mapping between management service and database instance.  

    Having said that, you could try setting the "Failover Partner " option in the connection string, i.e. in: 

    HKEY_LOCAL_MACHINE\SOFTWARE\[Wow6432Node]\Sophos\EE\Management Tools \DatabaseConnectionMS

    but I've not tried

    If there is a replica of a SOPHOS45 database and you update the connection string and the account the management service is connecting to the database has the necessary rights (should get these by being a member of the "Sophos DB Admins" windows group) you should be able to point the management service at any database.

    Regards,

    Jak

    :21579
  • 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
  • 0

    It's still not supported last time I checked however it probably will work I've just never tried.

    I assume you're not using SEC 4.5.  In later versions there are multiple components, each with their own connection string.  What version are you running?

    Regards,

    Jak

    :51126
  • 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