Backup strategy for various scenarios

The manager wants you to create a backup strategy for the following conditions:

It’s a test database

It’s a small database (1 gig)

Must have full backups

Can recreate data in a short time

Not too much activity during week

Solution:

Take a full database backup weekly

Select Simple Recovery Mode

The manager wants you to create a backup strategy for the following conditions:

It’s a production database

It’s a midsize database (20 gig)

Must have full backups

Cannot recreate data in a short time

Daily activity during week

Restore must be within 1 day

Solution:

Take a full database backup weekly

Select Full Recovery Mode

Create hourly transaction log backups

Create differential backups each six hours

The manager wants you to create a backup strategy for the following conditions:

It’s a production database

It’s a large database (200 gig)

Must have full backups

Cannot recreate data in a short time

Daily intense activity during the week

Restore must be within 3 hour

Solution:

Take a full database backup Monday, Wednesday, Friday,

Select Full Recovery Mode

Create 15 min transaction log backups

Create differential backups each 3 hours