SQL Server 2005 offers three main high availability solutions: failover clustering for server-level protection, database mirroring for database-level redundancy, and log shipping for disaster recovery. Data Guard and RAC are Oracle technologies, not SQL Server features.