HP ProLiant 4500 Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 79
Compaq Backup and Recovery for Microsoft SQL Server 6.x, Registration/Evaluation Form
View all HP ProLiant 4500 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 79 highlights
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 79 13. When estimating the amount of time needed to complete a full database dump, don't forget to account for the size of the transaction log. If archiving the transaction log separately, the performance of the log dump will usually be slower than that of a database dump. 14. The performance of a database load (or restore) can be less than that of a dump (backup), depending on the type of disk array you are restoring to; RAID-5 arrays can especially slow-down a striped load. The restore process is followed by a reinitialization of unused pages which further delays the operation. Your database load may need to be suceeded by one or more transaction log loads, which involve replaying much of the information contained in the log. You should plan for the total time needed to recover your data in case of a failure. We are planning on delivering more documents on related subjects in the future. We strive to provide you with the best technical information in a timely fashion. Please take a minute to fill out the User Registration/Evaluation Form on the next page and return it to us at your earliest convenience. This will help us tailor the future information products to your needs, and will enable us to make future revisions of this document and related new information products available to you. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797