Compaq ProLiant 1000 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

Get Compaq ProLiant 1000 PDF manuals and user guides View all Compaq ProLiant 1000 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

  • 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
79
1997 Compaq Computer Corporation, All Rights Reserved
Doc No 444A/0797
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.