The bottleneck here is going to be the 6MB/sec tape drives or the disk in the NT server, probably. I believe there is a way to do multi-streaming capability on SQL server, multiple streams to the same or more than one drive, but I have not read the documentation in a month or so. I will let you know later.
-----Original Message----- From: Joshua S. Bassi [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 11:53 AM To: [EMAIL PROTECTED] Subject: Re: 2.8TB SQL Server Database Backup I knew I forgot something - Gigabit Ethernet. -- Joshua S. Bassi Sr. Solutions Architect @ rs-unix.com IBM Certified - AIX/HACMP, SAN, Shark Tivoli Certified Consultant- ADSM/TSM Cell (415) 215-0326 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Seay, Paul Sent: Thursday, March 14, 2002 8:07 PM To: [EMAIL PROTECTED] Subject: Re: 2.8TB SQL Server Database Backup How is the SQL server going to get to the tape drives? SAN Gigabit FastEthernet? -----Original Message----- From: Joshua S. Bassi [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 3:56 PM To: [EMAIL PROTECTED] Subject: 2.8TB SQL Server Database Backup All, I have a potential customer running a 2.8 TB SQL Server database on an 8-way NT server. What can I realistically expect to achieve in maximum backup throughput using TDP for SQL Server? Assume the 4-way Solaris TSM server has 8 AIT-2 tape drives dedicated to getting this backup performed without any competing resource constraints. FYI AIT-2 run at 6 MBps native and the cartridges are 50 GB each. -- Joshua S. Bassi Sr. Solutions Architect @ rs-unix.com IBM Certified - AIX/HACMP, SAN, Shark Tivoli Certified Consultant- ADSM/TSM Cell (415) 215-0326
