You are the administrator of your company network. You are in charge of a SQL Server 2008 infrastructure. There’s an instance that hosts a database named MAJOR1 which includes Filestream data. Users must be able to access this database uninterruptedly with no data loss. You have to carry out a high-availability solution for the site. So which solution should you use?
A.
Database snapshot
B.
Failover clustering
C.
Asynchronous database mirroring
D.
Synchronous database mirroring with a witness server