You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003. The Domain.com network contains two SQL Server 2005 database servers named Certkiller -DB01 and Certkiller -DB02, and a member server named Certkiller -SR33. A database mirroring session operating in synchronous mode is in operation between Certkiller -DB01 and Certkiller -DB02, with Certkiller -DB01 being the principal database server. Certkiller -DB01 hosts a database named CK_Sales that stores sales data from Domain.com’s e-Commerce Web site. One Monday morning you discover that the CK_Sales database is unavailable. You discover that Certkiller -DB01 is offline while Certkiller -DB02 is online; however, failover to Certkiller -BD02 did not occur. This failure has adversely affected the profitability of Domain.com’s e-Commerce division. You need to improve the availability of the CK_Sales database. You are unable to acquire any additional hardware.
What should you do?