Hi, I am seeking some assistance with a tape backup schedule stagey for a small environment that backups following:
All directory files,
and SQL Databases.
Current schedule is:
Daily: Monday-Friday Daily FULL BACKUPS
Hourly: Monday-Friday 6am-6pm, hourly transaction log backups on 5 databases
Weekly: Friday backups just a FULL BACKUP of that day, Friday
Monthly: First Saturday of the month it backups just that day, Satutrday
The backup technologies in place are:
Backup Exec 2010 R3 w/ deduplication agent and SQL Agent.
Tape library consists of a PowerVault TL200
7TB SAN storage for the online disk Deduplication storage.
The systems in the backup schedule includes:
one standalone SQL server,
two SQL clusters with a combined total of 20 databases and 4 servers
two file servers
two domain controller servers
What could be an idea for the tape backup schedule and how long could retention be and how many tape backups are required?
I know it’s different in all environments but just considering the schedules you know to use as best practice what would you recommend?