Skip to main content
Database Administrators

Return to Question

formatting
Source Link
Kin Shah
Kin Shah
  • 62.4k
  • 6
  • 122
  • 240

I want to know what would be the best frequency in taking SQL DB, full - full and differential backupsdifferential backups looking at below particular scenario.

I have seven databases and each needs to be backup. 

Currently, I have setup a couple of maintenance plan in SQL as below.

  1. Clean Full Backup every night at 1AM, older than 7 days
  2. Full Backup every night at 2AM
  3. Differential Backup every 1 hour between 5AM to 10PM
  4. Clean Differential Backup Daily 10:30PM, older than 1 day

Considering the full backup size of each Database is 50GB. What would be the optimal way to take backups with 1TB of drive space.

Note that I have different drives for Full and Differential backups of size 1TB and 500GB respectively.

Any suggestions?

I want to know what would be the best frequency in taking SQL DB, full and differential backups looking at below particular scenario.

I have seven databases and each needs to be backup. Currently, I have setup a couple of maintenance plan in SQL as below.

  1. Clean Full Backup every night at 1AM, older than 7 days
  2. Full Backup every night at 2AM
  3. Differential Backup every 1 hour between 5AM to 10PM
  4. Clean Differential Backup Daily 10:30PM, older than 1 day

Considering the full backup size of each Database is 50GB. What would be the optimal way to take backups with 1TB of drive space.

Note that I have different drives for Full and Differential backups of size 1TB and 500GB respectively.

Any suggestions?

I want to know what would be the best frequency in taking SQL DB - full and differential backups looking at below particular scenario.

I have seven databases and each needs to be backup. 

Currently, I have setup a couple of maintenance plan in SQL as below.

  1. Clean Full Backup every night at 1AM, older than 7 days
  2. Full Backup every night at 2AM
  3. Differential Backup every 1 hour between 5AM to 10PM
  4. Clean Differential Backup Daily 10:30PM, older than 1 day

Considering the full backup size of each Database is 50GB. What would be the optimal way to take backups with 1TB of drive space.

Note that I have different drives for Full and Differential backups of size 1TB and 500GB respectively.

Any suggestions?

formatting
Source Link
edit approved Aug 14, 2018 at 17:16
James Z
edit approved Aug 14, 2018 at 17:16
James Z
  • 2.2k
  • 14
  • 22

I want to know what would be the best frequency in taking SQL DB, full and differential backups looking at below particular scenario.

I have seven databases and each needs to be backup. Currently, I have setup a couple of maintenance plan in SQL as below.

Plan 1: Clean Full Backup every night at 1AM, older than 7 days Plan 2: Full Backup every night at 2AM Plan 3: Differential Backup every 1 hour between 5AM to 10PM Plan 4: Clean Differential Backup Daily 10:30PM, older than 1 day

  1. Clean Full Backup every night at 1AM, older than 7 days
  2. Full Backup every night at 2AM
  3. Differential Backup every 1 hour between 5AM to 10PM
  4. Clean Differential Backup Daily 10:30PM, older than 1 day

Considering the full backup size of each Database is 50GB. What would be the optimal way to take backups with 1TB of drive space.

Note that I have different drives for Full and Differential backups of size 1TB and 500GB respectively.

Any suggestions?

I want to know what would be the best frequency in taking SQL DB, full and differential backups looking at below particular scenario.

I have seven databases and each needs to be backup. Currently, I have setup a couple of maintenance plan in SQL as below.

Plan 1: Clean Full Backup every night at 1AM, older than 7 days Plan 2: Full Backup every night at 2AM Plan 3: Differential Backup every 1 hour between 5AM to 10PM Plan 4: Clean Differential Backup Daily 10:30PM, older than 1 day

Considering the full backup size of each Database is 50GB. What would be the optimal way to take backups with 1TB of drive space.

Note that I have different drives for Full and Differential backups of size 1TB and 500GB respectively.

Any suggestions?

I want to know what would be the best frequency in taking SQL DB, full and differential backups looking at below particular scenario.

I have seven databases and each needs to be backup. Currently, I have setup a couple of maintenance plan in SQL as below.

  1. Clean Full Backup every night at 1AM, older than 7 days
  2. Full Backup every night at 2AM
  3. Differential Backup every 1 hour between 5AM to 10PM
  4. Clean Differential Backup Daily 10:30PM, older than 1 day

Considering the full backup size of each Database is 50GB. What would be the optimal way to take backups with 1TB of drive space.

Note that I have different drives for Full and Differential backups of size 1TB and 500GB respectively.

Any suggestions?

Post Migrated Here from stackoverflow.com (revisions)
Source Link
Krunal
Krunal
  • 121
  • 1
  • 3

Frequency of SQL DB Full and Differential backups

I want to know what would be the best frequency in taking SQL DB, full and differential backups looking at below particular scenario.

I have seven databases and each needs to be backup. Currently, I have setup a couple of maintenance plan in SQL as below.

Plan 1: Clean Full Backup every night at 1AM, older than 7 days Plan 2: Full Backup every night at 2AM Plan 3: Differential Backup every 1 hour between 5AM to 10PM Plan 4: Clean Differential Backup Daily 10:30PM, older than 1 day

Considering the full backup size of each Database is 50GB. What would be the optimal way to take backups with 1TB of drive space.

Note that I have different drives for Full and Differential backups of size 1TB and 500GB respectively.

Any suggestions?