X hits on this document

407 views

0 shares

0 downloads

0 comments

143 / 200

Using NetBackup for SQL Server with Snapshot Client How SQL Server operations use Snapshot Client

The following is an excerpt from this schedule:

Table 8-13

Sample backup schedule using cloaked backups

Time

Full backup saved to secondary

Differe backup

ntial

PFI Copy-Only or Cloaked Backup

Transaction log backup

storage

Day 1

12 AM

2 AM

4 AM

6 AM

8 AM

10 AM

12 PM

2 PM

4 PM

6 PM

8 PM

10 PM

Day 2

12 AM

2 AM

Under this schedule, full backups are performed every six hours. If a failure occurs, and is detected immediately, then the recovery can be achieved by restoring the last full backup and replaying, on average, three hours of transaction logs. However, if a failure is not detected until after the next full backup, then there would not be any full backups available since 12 AM on day 1. Since the persistent frozen image backups are cloaked, however, the differential backups would each be cumulative with respect to the last non-cloaked full backup.

143

Document info
Document views407
Page views407
Page last viewedSat Dec 03 16:05:10 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments