Hi All,
We have implemented SQL 2005 database mirroring in our environment for high availability.
Does K2 Server SP4 support this feature?
Is it possible to specify Failover Partner in the connection string located at k2server.config?
Does it support automatic failover?
Pls advice.
Siva
Does K2Server SP4 support SQL database mirroring ???
+4
+6Hi Siva,
Unfortunately this is not supported in SP4 or any version of K2.net.
You should however be able to implement this yourself though:
The only references to the K2 databases are located in the following 2 files:
K2Server.config (C:Program FilesK2.net 2003Bin)
web.config (C:Program FilesK2.net 2003K2WSWorkspaceService)
You can use a windows service to monitor the availability of SQL. In the event of unavailability, stop the K2 Server (using the K2MNG API), replace the config files with ones pointing to the mirrored instance, start the K2 Server.
HTH,
Conrad
Unfortunately this is not supported in SP4 or any version of K2.net.
You should however be able to implement this yourself though:
The only references to the K2 databases are located in the following 2 files:
K2Server.config (C:Program FilesK2.net 2003Bin)
web.config (C:Program FilesK2.net 2003K2WSWorkspaceService)
You can use a windows service to monitor the availability of SQL. In the event of unavailability, stop the K2 Server (using the K2MNG API), replace the config files with ones pointing to the mirrored instance, start the K2 Server.
HTH,
Conrad
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.