Can you help me with my software licensing question?
How many servers can I install SQL Server 2008 R2 Standard Edition on? I'd like to set up a backup server in case my main one dies. I'm not too familiar with what SQL Server Failover actually does. I'd prefer that if the main server dies I'd like to restore the database onto the backup server manually from a backup and switch over to the backup server. Is that possible with the Standard Edition or would I actually have to buy two Standard Editions?
Maybe this is what really Failover is, but I'm not too clear on what it actually does. I've done some reading on it, but I'm still confused.