If you use mirroring, you may need to modifiy the application connection strings to automatically failover to the active server.