Compaq ProSignia 300 Compaq Backup and Recovery for Microsoft SQL Server 6.X
Compaq ProSignia 300 Manual
View all Compaq ProSignia 300 manuals
Add to My Manuals
Save this manual to your list of manuals |
Compaq ProSignia 300 manual content summary:
- Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 1
1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 2
for internal use distribution, no part of this publication may be photocopied or reproduced in any form without prior written consent from Compaq Computer Corporation. This publication does not constitute an endorsement of the product or products that were tested. The configuration or configurations - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 3
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 3 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 4
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 4 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 5
: Page Reinitialization Performance based on Disk Array Type 73 Table 1 - Tape Cartridge Support Matrix ...15 Table 2 - Number of DLT Drives Needed for Desired Throughput 59 3 - SQL Server Backup with Database Activity 62 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 6
of powerful and rather versatile new backup products. We have attempted to make this document as comprehensive as possible to meet the needs of all Compaq customers who manage SQL Server environments on our hardware products. The customer who is beginning to plan such an environment may benefit from - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 7
and Recovery for Microsoft SQL Server 6.x Page 7 The information contained in this documents updates and adds to the information contained in the paper Compaq Backup and Recovery with Microsoft SQL Server, which was released in Oct. 1994. The additions in this paper serve mainly to inform the - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 8
that were committed but not applied to the data files. All data definition changes (such as creating can be found in the Microsoft SQL Server manuals and other publications. Fault tolerance and data will not cause any data loss. With the Compaq SMART and SMART-2 Array controllers and the hot- - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 9
Compaq Backup and various failure scenarios, refer to the SQL Server Administrator's Guide. Your ability to recover your data depends entirely on your down SQL Server, thus closing all database and transaction log files, and then perform a file-based backup of all SQL Server devices. This type of - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 10
the tape. With Cheyenne ARCserve for Windows NT and Compaq TurboDAT AutoLoader or Compaq DLT Library, you can group tapes together to increase the device files on 'raw' (unformatted) partitions is supported by both Windows NT and SQL Server to enhance I/O performance by bypassing the file system. - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 11
support the autoloading and/or cataloging capabilities of the Compaq TurboDAT AutoLoader or DLT Library. However, third party software that supports techniques outlined in the System Administrator's Guide, will help you determine a file. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 12
unless special database backup agents are used10. File-based tape backup utilities support archiving of remote data, but the Executive service or third party software. Refer to the System Administrator's Guide, documents Agents are available from Compaq or Cheyenne for use with Cheyenne ARCserve, and - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 13
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 13 The recovery operation consists of restoring your data from the backup media. You will use the same utility to restore your data as you used to back it up - if you used a file System Administrator's Guide or the manuals available with - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 14
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 14 restore will fail, and you will have to use a raw data import/export tool such as SQL Transfer Manager or BCP.12 12 Even these utilities have certain limitations. See the Administrators Guide for details. - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 15
, and 35/70-GB DLT tape drives. Other, older tape technologies such as the QIC (Quarter Inch Cartridge) and DAT (Digital Audio Tape) drives are also supported by Compaq but are not discussed here.13 The Compaq Digital Linear Tape (DLT) drives were designed to meet the growing backup needs of large - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 16
if peak performance is desired. Multiple drives can exist on the same SCSI bus by Daisy Chaining them with the appropriate cables. Compaq also provides DLT Tape Array cabinets which support up to four internal DLT tape drives. The cabinets have two SCSI channels so that the drives can be attached to - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 17
available on the Compaq Software Support Diskette for Windows NT (NT SSD). The Compaq 35/70-GB manually de-selecting the compression option on the drive, or using tape software that supports log entries and are only marked as empty. Any file-based backup utility treats such marked pages as containing - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 18
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 18 initialized and never used pages only, and yields very high compression ratios and very high backup - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 19
and continue writing. This overhead is known as the head positioning overhead. 4. File-based backup software, with software data compression turned on, will typically utilize the entitled Calculating Database Dump Throughput. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 20
under Windows NT, while also changing the patterns within the data file. For each block size, the bars on the left and had serious performance repercussions in the case of DLT tape drives. As a result, Compaq recommends that DLT drives not be used with these earlier (i.e: version 4.21x) SQL Servers - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 21
with these earlier (i.e: version 4.21x) SQL Servers. 512 byte blocks work fine for DAT and QIC drives. 26 Exceptions are when writing headers, trailers, or file-marks to the tape, where the size of the data sent may be less. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 22
Compaq Backup and Recovery for used when doing parallel dumps or dumping to striped disk devices. Append Dumps to Disk Files - SQL Server has always provided the functionality to append new dump images to the SQL Server 6.x continues to support dumps to network disk devices, as did previous versions. - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 23
dumps can also benefit from read-ahead at the hardware level, such as the Compaq SMART-2 Array Controller which pre-fetches data into its on-board cache module. later in the document. A full database dump includes a dump of the log file, which follows the actual dump of the data. Like the data, the - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 24
Compaq database backup. Refer to the System Administrator's Guide for more details and important considerations regarding use even automate this procedure and have a batch file dump the contents of the log. Truncating with SQL Executive The SQL Executive Service in SQL Server 6.x includes several - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 25
log space usage and generate an alert. This performance monitor alert can either run a batch file to dump the log itself, or use the xp_logevent extended stored procedure to log a SQL the SQL Server Administrator's Companion. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 26
consisting of an array of drives34. The best way to implement such an array is through use of a hardware RAID controller such as the Compaq Smart-2 SCSI Array controller. For the purposes of optimizing backup throughput, when using the Smart-2 array controller it is best to create a single large - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 27
perform off-line backups of the database device files. The agent functions as a Windows NT service, and allows backup at the database or table supports up to 8 tape drives per server. 35 Cheyenne Software, Inc. is now a wholly owned subsidiary of Computer Associates International, Inc. 1997 Compaq - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 28
or tape library such as the DLT 15Cartridge Library from Compaq. The current version of the auto-changer is not related tasks on the network, including other file-based backup jobs. Automation - The ARCserve Manager, part of the SQL Executive service, provides a more limited scheduling scheme for - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 29
ARCserve 6.0 or its Option software, please refer to the User Guide for the corresponding product. The ability to stripe data across multiple tape are met. Normally, one would use a tape library such as the Compaq DLT 15-Cartridge library for unattended backups. However, if increased performance or - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 30
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 30 GigaBytes of storage in an ARCserve RAID-0 tape array. This applies to SQL Server tape stripe - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 31
DLT Tape Array and DLT Tape Array II cabinets.44 40 Results including Microsoft SQL Server 4.21x were covered in the previous paper, Compaq Backup and Recovery with Microsoft SQL Server (4.21x), document #250A/0894. 41 See section entitled SQL Server Database Backup with User Activity. 42 For - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 32
Compaq 4.3 GB Fast-Wide SCSI-2 disk drives (7200 RPM). Compaq External Storage cabinets for Fast-Wide disk drives. The system was set up as follows: All system boot and binary files Disks - insufficient spindles in database volume to service required number of read requests from application. Software - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 33
disk dump devices interface.48 Dump Device - limited capability of tape or disk device to service write requests (1.25/2.50 MB/sec49 for DLT Tape drives). Intermediate (Link): Network the purposes of these tape backup tests. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 34
Compaq Backup and Recovery for Microsoft SQL Server 6.x Chart 3 - Dump to 30, such as twice the number of simultaneous read/write channels (4 vs. 2), increased tape speed, increased tracks-per-inch on the media, enhanced interface (Fast-Wide SCSI-2), and a larger on-board buffer cache (8 MB vs. 2 MB - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 35
of SQL Server is increased because there are now multiple threads reading from the database files, with each thread allocated its own in-memory buffer. We can attempt to compensate ' device in SQL Server is a 'null' device. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 36
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 36 The tests were generally be used in conjunction with an off-line backup utility which can later transfer the dump image files onto tape, thus allowing normal database transactions to continue on the SQL Server with minimal time spent - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 37
Compaq Backup multiple dump devices are used. You can create more than one dump device file per array, but then the writes to this array will become randomized and by the PCI bus bandwidth. 60 The on-board controller cache was manually configured for 100% write caching (vs. read-ahead) using the Array - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 38
Compaq Backup and Recovery for Microsoft SQL Server 6.x Chart 5 - Striped Dumps to Disk Arrays Page 38 As expected, each write to any one drive). For a discussion on the performance implications of RAID technology, see the Configuring Compaq RAID Technology for Database Servers white paper. - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 39
Smart-2/P controller (both SCSI-ports) which resided on the primary PCI bus of the Proliant 5000. All of the DLT drives resided in Compaq DLT Tape Array cabinets (4 drives per cabinet). Each cabinet was interfaced to 2 controllers (the embedded Fast-Wide SCSI-2/P controller or additional Wide-Ultra - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 40
Compaq Backup and Recovery for Microsoft SQL Server 6.x Chart 6 - Striped Dumps to 15/30 DLT Tape Drives Page 40 Starting with 1 drive yields the 5.00 GB/ - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 41
your database can affect the performance numbers seen when dumping to tape drives supporting hardware compression. We have found however, that performance differences due to compression with only 2 drives the dump throughput 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 42
section entitled Establishing Maximum Throughput at the Server. 67 When SQL Server 6.5 database dump tests were run on previous generation (EISA-based) Compaq servers (i.e: the Proliant 4500), the maximum throughput achieved was about 25 GB/hr, due mainly to limitations imposed by EISA bus bandwidth - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 43
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 43 The final point above deserves further discussion. When a single database is being dumped, the dump process begins reading the data at the start of the database file and continues reading successive pages that are stored more or less - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 44
Smart-2/P controller (both SCSI ports) which resided on the primary PCI bus of the Proliant 5000. All of the DLT drives resided in Compaq DLT Tape Array cabinets (4 drives per cabinet). Each cabinet was cabled to 2 controllers (the embedded Fast-Wide SCSI-2/P controller or additional Wide-Ultra - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 45
Compaq Backup and Recovery for Microsoft SQL Server 6.x Chart 9 - Database Backup to 15/30 DLT Tape RAID Using ARCserve than the native SQL Server process can. However, this mechanism also demands much more CPU power; with 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 46
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 46 eight DLT drives our four Pentium Pro/166 processors were almost saturated (CPU usage split between - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 47
CPU use. We do however, recommend ARCserve (and its autochanger option) for implementing concurrent, unattended backup jobs to both drives inside the Compaq DLT 15-Cartridge Library69. Also, results of using the ARCserve products to perform concurrent backups of databases to a remote server, will be - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 48
storage server, only Windows NT file shares accessible from each of Compaq 15/30-GB DLT tape drives. 1 Compaq 35/70-GB DLT tape drive. 70 Alternatively, the name of the remote share can be added to the "NullSessionShares" registry key under the path \\HKEY_LOCAL_MACHINE->CurrentControlSet->Services - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 49
External Storage cabinet with 5 Fast-Wide disk drives. 1 Compaq NetFlex-3 PCI 10/100 TX UTP card. This was the same system used for previous tests, with some modifications. It was set up as follows: The system boot and binary files were installed on a Smart-2 volume on the internal drives, along - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 50
100Base-T repeater for the 100 Mbit tests. The 100 Mbit technology chosen was 100Base-TX. Compaq supports other 100 Mbit Ethernet technology such as 100VG-Any LAN, but this was not tested. 100Base-TX supports full-duplex mode for bi-directional throughput up to 200 Mb/s. However, since most of the - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 51
on the other end; SQL Server is sending a single data stream directly to the Windows NT file system. Although not displayed, the CPU usage at both servers for all transfers was very low, for 10 Mbit, yet while monitoring the 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 52
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 52 network utilization, it was never seen to exceed an average of 25%. The CPU usage at - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 53
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 53 Figure 1 - Network Layout: Backup of 4 Servers Across 4 Dedicated an average of the usage seen on each of the segments involved in the respective backup runs. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 54
such concurrent backup jobs could feasibly be performed with the addition of still more tape drives and NICs or dual-port NICs such as the Compaq Netelligent Dual 10/100TX74. The concurrent backup scheme is continued here, with 100 Mbit technology. There is however, a key difference in the way the - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 55
configured for up to 2 jobs. More than 2 RAID-5 arrays could not be configured as ARCserve supports only 8 drives and each RAID-5 array requires at least 3 drives. With this setup, backup jobs observed between the 2 peer-buses. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 56
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 56 Chart 14 - Concurrent Backup of Multiple Servers Across Single 100BaseTX Segment The benefits of this concurrent - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 57
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 57 especially in the case where a network bridge or in between the tape backup server and the other servers can significantly degrade network backup performance. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 58
look at the ARCserve options, which are available directly from Compaq. Using disk drives for local dump operations instead of tape Primary server should fail.79 The need for 78 A dedicated volume for dump files (or even a dedicated controller) is recommended not only for performance reasons, but - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 59
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 59 temporary disk storage can be removed by using 6000 would yield very similar results, since both systems are based on a similar (peer-PCI bus) architecture. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 60
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 60 Note that to perform the database backup, then the DLT 15-Cartridge Library along with ARCserve (and its autochanger support) may have provided a better solution, allowing for unattended backups with even more capacity so that the - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 61
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 61 This section will address considerations of performing products were discussed earlier in the section: Online Backup Considerations with ARCserve for Windows NT. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 62
load at the server). Finally, we measured throughput (both user transactions per second throughput and GB/hour backup throughput) during a database dump to two Compaq 15/30GB DLT drives, with the SQL Server native striped dump as well as the ARCserve assisted dump. During each of the phases we also - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 63
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 63 inaccessible, although it is actively accessed only in the do not recommend attempting a backup of a database that is under a much heavier user read/write load. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 64
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 64 When 84 This is true for an OLTP-type environment with numerous read/write transactions. A Decision Support-type environment involving large read-only queries may behave differently since reads are not affected by the backup process - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 65
Compaq Backup and Recovery for Microsoft SQL Server 6.x 75% of Maximum .15 sec ~70% 75% throughput nor the transaction throughput will be affected as long as there is adequate CPU time to service all threads and I/O is separated. If CPU usage becomes high however, the backup throughput will - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 66
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 66 process), or the transaction rate will suffer along with a reduction in backup throughput (with the ARCserve backup agent). - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 67
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 67 Like the database itself, the transaction log can in which it does database dumps. See section entitled Online Backup Considerations with ARCserve for details. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 68
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 68 common transaction log volumes (fault tolerance and number of drives) that may be implemented on an - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 69
Compaq Backup and Recovery for Microsoft SQL Server 6.x DUMP TRANSACTION SQL Server NULL SQL Server 1 15/30 DLT SQL Server 1 capable of only about 12.5 GB/hr (see Table-7). Chart-6 shows that it is possible to achieve around 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 70
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 70 16.5 GB/hr with 4 DLT drives, which exceeds the rate of the log volume. Therefore the - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 71
re-created. Other important considerations can be found in the Microsoft SQL Server manuals and the Microsoft SQL Server, Backup and Recovery Guidelines document, available from based on the corresponding tape block size. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 72
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 72 These results do not include any activity needed to search, replace or rewind89 the tapes, which - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 73
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 73 Chart 16 - Load Database: Page Reinitialization Performance based continuously, so that they do not have to stop, re-position the tape, then continue reading. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 74
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 74 The page reinitialization phase of the load (chart 16) is generally faster with all types of - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 75
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 75 loaded into an empty database with 50 GB of total data This number is a 'worse case' since the chart was based upon 8 restore threads and the example uses only 4. 1997 Compaq Computer Corporation, All Rights Reserved Doc No 444A/0797 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 76
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 76 that were recorded (but reading from the backup media and writing to the buffer space (from where it is written out to the log file by the log writer), then pausing to read the existing log again, etc. This causes a 'stop-go' behavior - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 77
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 77 RAID 5 data array: 1 hour, 32 minutes. This will not 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 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 78
consisting of multiple disk drives. The best way to implement such an array is through use of a hardware RAID controller such as the Compaq Smart-2 SCSI Array controller. 6. You can increase your backup throughput by using multiple storage devices along with SQL Server striped database dumps or - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 79
Compaq Backup and Recovery for Microsoft SQL Server 6.x Page 79 13. When estimating the amount of time needed to complete 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 - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 80
Corporation 20555 SH 249 Houston, Texas 77070 Main (281) 370-0670 http://www.compaq.com/ Configuring Compaq RAID Technology for Database Servers, published in February 1994 (Document Number 267A/0294) Compaq Backup and Recovery Of Microsoft SQL Server for Windows NT, First Edition, published in - Compaq ProSignia 300 | Compaq Backup and Recovery for Microsoft SQL Server 6.X - Page 81
Oracle7 Other: Processing Type On-Line Transaction Processing Decision Support Batch Processing Other: Please indicate the type of information you Return to: Database Engineering Compaq Computer Corporation MailCode 090803 20555 S.H. 249 Houston, Texas 77070 Compaq Backup and Recovery for
1997 Compaq Computer Corporation, All Rights Reserved
Doc No 444A/0797