Daylight savings time, Gpt disks and vss backups, Creating replicas (backups) – HP XP Racks User Manual

Page 376

Advertising
background image

The configuration file for an SQL Server database is added or deleted.

The configuration file for an SQL Server database is moved.

The name of a configuration file of an SQL Server database is changed.

TIP:

When rebooting a system that references a secondary volume (replica), be aware that the volume
might be mounted automatically.

Daylight savings time

Daylight saving time involves adjusting the system time of the database server for certain time periods.
Replica operations scheduled for these time periods are handled in the following manner:

When daylight saving time starts, a replica scheduled for a time period that was skipped (for ex-
ample, from 2:00 to 3:00) is not executed.

When daylight saving time ends, a backup job scheduled for overlapping time periods (for example,
from 1:00 to 2:00) is executed twice.

For best results, do not schedule a replica creation when the server system time will be adjusted for
daylight saving time.

GPT disks and VSS Backups

If you execute a VSS backup for a GPT disk, the number of registry keys related to the GPT disk is
increased. If you repeatedly execute VSS recoveries, the VSS backup might fail. For this reason, we
do not recommend using Application Agent with a GPT disk configuration. If you must execute a VSS
backup for a GPT disk, you should clean up the registry of the backup server according to the Microsoft
support article KB934234.

Creating replicas (backups)

The following precautions apply to creating replicas:

To back up an SQL Server instance, the instance must be online. If an attempt is made to back up
an instance when it is not running, the attempt will fail.

If an instance contains multiple databases, the way volumes can be replicated or restored differs
as follows, depending on the configuration of the primary volumes containing the databases:
• When the databases are stored in the same volume, they can be replicated or restored at the

same time.

• When the databases are stored on different volumes, only some of the databases within the

instance can be replicated or restored.

Do not mount another volume in a directory on the volume to be backed up. If another volume is
mounted, mounting and restoration of the secondary volume may fail.

When data is backed up, a folder named

DRMVSSMETADATA_backup-ID

is created in the root

directory of the secondary volume. Do not delete this folder because it contains metadata necessary
for restoration. This folder is automatically deleted after data has been restored.

If you are running the Windows Disk Management application on Windows 2003 server without
a service pack installed, close the Disk Management application before creating the replica. If
the backup operation is executed while the Disk Management application is running, it might fail.

On Exchange 2003/2007, you cannot back up individual information stores. In addition, the
information stores of the storage group to be backed up must be mounted in advance.

Managing application replicas

376

Advertising