Which strategy should you use?

You maintain a SQL Server 2008 instance that contains a database named Finance. A small
percentage of data in the database is modified daily.
You need to create a read-only copy of the database for reporting purposes at the beginning
of each day by ensuring that minimal disk space is used.
Which strategy should you use?

You maintain a SQL Server 2008 instance that contains a database named Finance. A small
percentage of data in the database is modified daily.
You need to create a read-only copy of the database for reporting purposes at the beginning
of each day by ensuring that minimal disk space is used.
Which strategy should you use?

A.
Use database snapshots.

B.
Use database backup and restore.

C.
Use database backup and restore along with compression.

D.
Use schema-bound views in a read-only database that resides on the same instance.



Leave a Reply 0

Your email address will not be published. Required fields are marked *