which backup strategy should you use?

You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution.
Now you manage a SQL Server 2008 instance which hosts a database. At present the database is scheduled for a full backup every month and uses the bulk-logged recovery model. The 4-terabyte database contains 3.5 terabyte of data in a read-only filegroup. You have to back up the database changes to a tape drive every night, you must use as little storage space and time as possible. So which backup strategy should you use?

You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution.
Now you manage a SQL Server 2008 instance which hosts a database. At present the database is scheduled for a full backup every month and uses the bulk-logged recovery model. The 4-terabyte database contains 3.5 terabyte of data in a read-only filegroup. You have to back up the database changes to a tape drive every night, you must use as little storage space and time as possible. So which backup strategy should you use?

A.
You should use file backup

B.
You should use Partial backup

C.
You should use differential backup

D.
You should use differential Partial backup



Leave a Reply 0

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