Compaq ProLiant 1000 Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 77

Writing additional data onto tape, such as registry and/or catalog information

Page 77 highlights

Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 77 RAID 5 data array: 1 hour, 32 minutes. This will not necessarily be the case with transaction profiles containing a much higher ratio of read (non-logged) vs. write (DML) statements, or with a system under light usage. Although transaction logs dumps take considerably less time and space to perform than full database dumps, using multiple such dumps to rebuild a lost database can greatly prolong the overall database recovery time. This point should be considered carefully when planning a database backup & recovery strategy. There exists a number of additional factors that can all influence performance of backup and restore operations. These factors include the following: Rewinding tapes Changing tapes Searching for the end of the backup set, when applicable (appending new data) Writing additional data onto tape, such as registry and/or catalog information Cataloging of tapes Backing up across the network when the network utilization is high (available network bandwidth) User activity on the database. Diagnostics and replacement of the failed hardware Creating and/or formatting of lost partitions, if necessary Re-creation of the database devices and the database itself, if necessary. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81

Compaq Backup and Recovery for Microsoft SQL Server 6.x
Page
77
1997 Compaq Computer Corporation, All Rights Reserved
Doc No 444A/0797
RAID 5 data array: 1 hour, 32 minutes.
This will not necessarily be the case with transaction profiles containing a much higher ratio of read
(non-logged) vs. write (DML) statements, or with a system under light usage.
Although transaction logs dumps take considerably less time and space to perform than full database
dumps, using multiple such dumps to rebuild a lost database can greatly prolong the overall database
recovery time.
This point should be considered carefully when planning a database backup & recovery
strategy.
There exists a number of additional factors that can all influence performance of backup and restore
operations.
These factors include the following:
Rewinding tapes
Changing tapes
Searching for the end of the backup set, when applicable (appending new data)
Writing additional data onto tape, such as registry and/or catalog information
Cataloging of tapes
Backing up across the network when the network utilization is high (available network bandwidth)
User activity on the database.
Diagnostics and replacement of the failed hardware
Creating and/or formatting of lost partitions, if necessary
Re-creation of the database devices and the database itself, if necessary.