Do I require a seperate SQL server for configuring hot standby option?
The hot standby poller points to the same SQL Server as the primary poller/s. It can be configured to act as a hot-standby for more than one poller, but can only actually take-over for one poller at a time.
Dave.