X hits on this document

498 views

0 shares

0 downloads

0 comments

144 / 200

144

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

In this example, suppose that an error occurs at 11:30 PM on day 1 but is not detected until 12:30 AM on day 2, after the 12:AM full backup. Since the 6 PM full backup no longer exists it would be necessary to begin the recovery with the backup taken at 12 AM on day 1. However, since all of the full backups since then were cloaked, the differential backup from 10 PM would be cumulative with respect to that backup. This means that the recovery sequence would be to restore the 12 AM day 1 backup followed by the 10 PM differential backup, followed by 1½ hours of transaction log backups.

If you use copy-only or cloaked backups, then the copy-only or cloaking attribute is displayed in the properties for the snapshot backup image. Differential backups are automatically associated with the correct full backup and are recognized by the SQL agent when it selects the recovery set for the full database restore.

Caution: Microsoft SQL Server does not recognize the cloaked backup. Therefore, if it is incorporated in your database protection strategy, it is essential that you maintain a comprehensive set of transaction logs that span the time duration back to the last non-cloaked full backup.

Creating a cloaked backup (SQL Server 2000)

To create a batch file for a cloaked backup

1

Open an existing batch file in a text editor.

2

Insert the following:

CLOAKEDBACKUP TRUE

3

Save the batch file.

Creating a copy-only backup (SQL Server 2005)

Any backup can be created as copy-only in SQL Server 2005. A persistent frozen image snapshot is automatically created as copy-only. “Creating a cloaked backup (SQL Server 2000)” on page 144 describes how to create a snapshot that is not copy-only.

To create a copy-only backup

1

Open an existing batch file in a text editor.

2

Insert the following:

COPYONLY TRUE

3

Save the batch file.

Document info
Document views498
Page views498
Page last viewedThu Dec 08 03:11:14 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments