I have one existing SQL 2005 server with 10 databases. Now I need to implement database mirroring & failover. Could someone show me what steps I need to do. Currently I have a new server with Windows 2008 R2 installed. I know I need to install SQL 2005 on the new server but I don't know how should I install it (which features need to select, how should I name the instance for new server, etc... ). Please help.
With Standard edition, you are limited to the synchronous/SAFETY=ON option, so make sure that the other failover partner commits are speedy. It should not be at a DR site for instance, or you'll have a performance hit.