The following are guidelines for database backup.
Based on the data criticality and availability required the backup's can be designed.
Option -1 --- High availability
1. Have a complete hardware backup where the sql data and operating system are backed up with the appropriate raid configuration.
2. Database mirrored with witness for automatic fail over.
3. Full Database backed up every night to external media (drive or tapes)..
4. Differential transaction Database backed up every 15 min.
Option -2 --- High availability
1. System state back up including the operating system.
2. Database mirrored with witness for automatic fail over.
3. Full Database backed up every night to external media (drive or tapes).
4. Differential transaction Database backed up every 15 min.
5. Please make sure master and msdb database backed up.
despite the presence of other data recovery methods, I recommend another service of repair clipper dbf
ReplyDelete