Which backup strategy should you implement?
You are the database administrator for your company. You maintain a database named Hr1 on a SQL Server2008 instance named Sql1.
The database size is approximately 45 GB and uses the Full Recovery model. The Hr1 database consists of a primary filegroup and four secondary filegroups.
Each filegroup contains three datafiles that are located on different disks. The Hr1 database is an online transaction processing database.
You perform a full backup of the database everytwo days. The Transaction_details table in the database contains all the transaction details and is updatedfrequently.
You are required to frequently back up the data in the table to prevent loss of transaction details in theevent of a failure. Which backup strategy should you implement?