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.
正确答案:A
答案解析:有
微信扫一扫手机做题