If i have an active\passive cluster for SQL Server, under what circumstances would it prompt to automatic changeover to the passive cluster ? Failure of the SQL Server, or let's say 1 user database out of 25 becomes suspect?
It would require a failure of the entire SQL Server. Individual databases can be brought online and offline all throughout the day. A failover is only done when one of the cluster resources has failed.