Discussion Locked

Citrix ps 4.5 and mssql database

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Question,

I have a new citrix enviornment with Presentation server 4.5 installed, the database/sessions is mssql 2000. I have a single farm with 16 servers seperated by a WAN link. I have two sql servers, 1 in one site and the other in the other site. How can I make sure it is not a single point of failure for my database. Right now everything is connected to the database in one site.

1 reply

by rkelly

The only way to ensure that SQL is not the singe point of failure is to use a SQL failover cluster - this may be a little over the top for a 16 server citrix environment though. You need to remember that Presentation Server will continue to run even if the SQL Database is unavailable (although you may get issues after a reboot). I would simply ensure that you have a complete disaster recover plan in place for your data store and have a hot piece of kit available to take your existing servers place in case of emergency.

Richard Kelly CCIA, CCEA

This discussion is closed to new replies.