Home » Microsoft » MB6-886 » What should you do?
Your company has four offices. Each office contains a server that runs SQL Server 2008.
All corporate data is stored in a central location.
You need to create a reporting solution. The solution must meet the following requirements:
• Minimize hardware costs
• Minimize administrative effort
• Minimize the time it takes to generate the reports
• Enable users to run reports locally, even if a WAN link fails
What should you do?
A. Implement a geographical dispersed SQL Server 2008 cluster.
B. Implement database mirroring.
C. Implement log shipping.
D. Create horizontally partitioned tables and a federated database.
Correct Answer: C
Explanation/Reference:
A given database can be mirrored or log shipped; it can also be simultaneously mirrored and log shipped. To choose what approach to use, consider the following:
How many destination servers do you require?
• If you require only a single destination database, database mirroring is the recommended solution.
• If you require more than one destination database (in our case 4!!!), you need to use log shipping, either alone or with database mirroring.
You should not implement database mirroring because mirroring works only with databases that use the full recovery model. However, in the question nothing said about this.