X hits on this document

592 views

0 shares

0 downloads

0 comments

54 / 200

54

Backup and recovery concepts Reducing backup size and time by using read-only filegroups (SQL Server 2005)

Reducing backup size and time by using read-only filegroups (SQL Server 2005)

Many applications contain a substantial amount of data that does not change. For example, under time-based partitioning, historical data may be preserved indefinitely while only a fraction of the database is subject to change at any given time. With SQL Server 2005, static filegroups can be classified as read-only. NetBackup uses the filegroup read-only designation to optimize the total backup volume speed of recovery.

For backups, the advantage in using read-only filegroups is that you can reduce total media usage by backing up the read-only filegroups once and retaining the backup image indefinitely. This reduces the total time spent on performing backups because only read-write data is backed up periodically.

For recovery, the advantage is that you can bring your database on-line more quickly because read-only filegroups do not need to be restored from backup media unless they are corrupted due to disk error or other hardware failure.

Table 4-8

Backup strategy for read-only and read-write filegroups

Task

1

Create a policy for read-only filegroups.

Notes

Refer to

Create an Application Backup schedule with Retention set to infinite.

Adding schedules” on page 30

2

Create a policy for read-write filegroups.

Create an Automatic Backup schedule with the desired Retention period and add the read-write filegroups batch file to the Backup Selections list.

Adding schedules” on page 30

3

Back up read-only filegroups.

In the NetBackup for SQL Server interface, select the policy you created in step 1. Perform this backup once.

Backing up read-only filegroups (SQL Server 2005)” on page 71

All read-only filegroups must be included in some combination of full, partial, or individual filegroup and file backups.

Note: Immediately back up any filegroup when changing it from read-write to read-only.

4

Back up read-write filegroups.

This will be done automatically through he schedule you created in step 2. Or you can manually back up the read-write filegroups.

Backing up read-write filegroups (SQL Server 2005)” on page 72

Document info
Document views592
Page views592
Page last viewedTue Jan 17 07:37:49 UTC 2017
Pages200
Paragraphs4189
Words49499

Comments