As I understand it if you are using mirroring on SQL server and have failover setup you can adjust the connection strings of your applications that use it so they know the name of the other server ...

Database mirroring, a high-availability feature, will be included in the RTM version of the Standard and Enterprise editions of SQL Server 2005, but customers will be required to go through extra ...

When SQL Server 2005 is released to manufacturing in the next few months, Microsoft will take the exceptional step of designating one of its high-profile features as being intended for evaluation only ...

SP1 encompasses several new features, including database mirroring, in which the primary production server is mirrored at all times by a standby server.