HP ProLiant 4500 Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 77
Writing additional data onto tape, such as registry and/or catalog information
View all HP ProLiant 4500 manuals
Add to My Manuals
Save this manual to your list of manuals |
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