You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible. In the options below, which strategy should you use?（） A: You should use database snapshots B: You should use database backup and restore C: You should use database backup and restore along with compression D: You should use schema-bound views in a read-only database. The database resides on the same instance.

0 阅读

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.
In the options below, which strategy should you use?（）

A: You should use database snapshots
B: You should use database backup and restore
C: You should use database backup and restore along with compression
D: You should use schema-bound views in a read-only database. The database resides on the same instance.

请帮忙给出正确答案和分析，谢谢！