Date - Jun 2008
Affected Product & Version - NVBU v8.x
Affected Module & Version - MS SQL Server APM v5.0
OS Version - Windows 2000 - 2003
Application Information - MS SQL v2000 - 2005
Symptoms:
It is important to select an appropriate backup scenario for MS SQL. Failing to do regular backups using Database Complete, Differential and Transaction Logs could result in difficult or unmanageable restores.
Scenario 1:
Consider a non 24x7 Database (about 500 MB to 1GB)
1. Perform a complete database backup every night during the non-operational window.
2. Perform transactional backups every hour.
This approach provides both a point-in-time restore and a point-of-failure restore.
Scenario 2:
Consider a 24x7 Database (about 500 MB to 1GB)
1. Perform a complete database backup every night during non-peak hours 2
2. Perform a differential backup during off-peak time of the day.
3. Perform transactional backups every 15 minutes, round the clock.
This approach provides both a point-in-time restore and a point-of-failure restore. The restore time is also considerably less.
Scenario 3:
Consider a 24x7 Database (about 1 GB to 10GB)
1. Perform a complete database backup every night.
2. Perform backups during off-peak time of the day.
3. Perform transactional backups every 15 minutes round the clock. Depending on the activity in the system, change transactional frequency.
Scenario 4:
Consider a 24x7 Database (about 10 GB to 60GB)
1. Perform a complete database backup every night.
2. Perform differential backups during off-peak time of the day.
3. Perform transactional backups every 15 minutes round the clock. Depending on the activity in the system, change transactional frequency.
Please See Microsoft TechNet for Further information.
http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/core/fndb_con_apwh.mspx?mfr=true
BakBone SFDC Solution Number: 00003763
