ADSMCONNECT AGENT FOR MICROSOFT SQL SERVER, VERSION 1.1 PROVIDES CONSISTENT AND RELIABLE BACKUP AND

ADSMConnect Agent for Microsoft SQL Server, Version 1.1 Provides Consistent and Reliable Backup and Recovery of Microsoft SQL Server Databases

Software Announcement
November 11, 1997
Announcement Letter Number: 297-459

The ADSMConnect Agent for Microsoft (R) Structured Query Language (SQL) Server, Version 1.1, referred to from now on as ADSMConnect SQL Agent, lets you protect your Microsoft SQL Server databases using the storage management capabilities of any of the ADSTAR (R) Distributed Storage Manager (ADSM) Version 2 or Version 3 server platforms.

The ADSMConnect SQL Agent acts as the interface between a Microsoft (MS) SQL server and an ADSM server. Using the ADSMConnect SQL Agent, you can perform online full or incremental database backups to an ADSM server. The ADSM server then applies its storage management functions to the data, which can be carried on while you are working, with minimal disruption. These functions include migration through a storage hierarchy, management of tape media space, and disaster recovery support.

The benefits provided by the highly automated, centrally scheduled, policy managed backup and restore facilities of ADSM are utilized by the ADSMConnect SQL Agent for the protection of data. The data may be stored on a wide variety of storage devices. Together, the ADSMConnect SQL Agent and ADSM can help manage the costs associated with distributed storage management by leveraging storage resources and automating management tasks.

To let you experience the powerful functions of ADSMConnect Agent for Microsoft SQL Server, IBM plans to offer a 60-day Try and Buy program. Accessible from the ADSM Web site, the Try and Buy program lets you evaluate the code and documentation for 60 days. After the 60-day evaluation period expires, Try and Buy cannot be extended. To continue using the ADSMConnect Agent for Microsoft SQL Server, you must order the product. In addition to this Agent, you may download other ADSMConnect Agent Try and Buys from the ADSM Web site. The ADSM Web site is located at:

http://www.storage.ibm.com/adsm

The ADSMConnect SQL Agent is another in a series of agents to provide the storage management capabilities of ADSM for a variety of formats of data. The ADSMConnect SQL Agent requires an ADSM server at Version 2 or Version 3. The ADSM server platforms that are currently supported at the Version 2 level are AIX (R), OS/2 (R), Windows NT (TM), VM, MVS (R), AS/400 (R), Hewlett-Packard HP-UX, and Sun Solaris. The ADSM server platforms that are currently supported at the Version 3 level are AIX, Windows NT and MVS.

Intended Customers

Customers who want to backup their Microsoft SQL Server databases

Key Prerequisites

Microsoft SQL Server Version 6.0 or 6.5
Windows NT Version 3.5.1 or 4.0
Any ADSM Version 2 or Version 3 server

Planned Availability Date

November 21, 1997

------------------------------

This announcement is provided for your information only. For additional information, contact your IBM representative, call 800-IBM-4YOU, or visit the IBM home page at: http://www.ibm.com

DESCRIPTION

The ADSMConnect SQL Agent helps you protect your MS SQL Server databases by using the backup and recovery services of ADSM. The ADSMConnect SQL Agent acts as an interface between MS SQL Server and ADSM by using the SQL DB-Library API to communicate with MS SQL Server, and the ADSM API to communicate with any ADSM Version 2 or Version 3 server.

The ADSMConnect SQL Agent performs backups and restores of MS SQL Server databases running on the local machine. The ADSMConnect SQL Agent includes a command line and Graphical User Interface (GUI). The ADSMConnect SQL Agent's capabilities:

Multiple instances of the ADSMConnect SQL Agent can be run for added performance when backing multiple MS SQL Server databases on the same machine.
The use of the ADSM scheduler to schedule the SQL database backup at a time of low usage, minimizes the impact of the backup.
The GUI displays all of the MS SQL Server databases on a given machine as well as ADSM servers to which the SQL Agent has access. To perform backup, the user chooses a database and an ADSM server and then initiates the operation. This means that you can easily select any MS SQL Server database to backup or restore with any ADSM server on your network.

Once data has been stored on an ADSM server, the ADSM server can apply its storage management functions to this data. The ADSM server's capabilities include:

Access to a storage hierarchy
Migration (server Hierarchical Storage Management or HSM) through the storage hierarchy
Management of tape media space
Central scheduling and automation of your environment
Disaster recovery support including off-site management of tapes

Year 2000

This product is Year 2000 Ready. When used in accordance with its associated documentation, it is capable of correctly processing, providing, and/or receiving date data within and between the 20th and 21st centuries, provided all other products, (for example, software, hardware, and firmware) used with the product properly exchange date data with it.

PRODUCT POSITIONING

ADSMConnect Agent for Microsoft SQL Server enables customers with MS SQL Server databases to take advantage of the key storage management functions of ADSM. MS SQL Server database users can also take advantage of ADSM's best of breed scalability, server hierarchical storage management and powerful disaster recovery functions without disrupting the daily user activities.

ADSM is well suited for customers with multi-platform and complex environments who seek a market-leading, storage management solution that protects and manages mission-critical data spread across the entire enterprise. ADSMConnect SQL Agent provides consistent and reliable backup and recovery of MS SQL Server databases.

EDUCATION SUPPORT

The following classes are available to provide information on ADSM:

ADSM Implementation and Planning (course number J3741)
Advanced Topics (course number SS520)
ADSM Version 3 Update (course number SS530)*

*     SS530 is of particular value for those familiar with ADSM
      Version 2.

The appropriate curriculum will be updated, as necessary, to include the product features described in this announcement.

Descriptions of all classroom and self-study courses are available.

Call IBM Education and Training at 800-IBM-TEACH (426-8322) for education catalogs, schedules and enrollments.

REFERENCE INFORMATION

For ADSM for AIX Version 2.1, refer to Software Announcement 296-402 296-402,:elink. dated October 22, 1996.

For ADSM for AIX Version 3.1, refer to Software Announcement 297-411 297-411,:elink. dated October 7, 1997.

For ADSM for OS/2, refer to Software Announcement 296-343 296-343,:elink. dated September 10, 1996.

For ADSM for Windows NT Version 2.1, refer to Software Announcement 296-198 296-198,:elink. dated June 4, 1996.

For ADSM for Windows NT Version 3.1, refer to Software Announcement 297-412 297-412,:elink. dated October 7, 1997.

For ADSM for AS/400, refer to Software Announcement 296-191 296-191,:elink. dated June 4, 1996.

For ADSM for AS/400, refer to Software Announcement 296-313 296-313,:elink. dated September 3, 1996.

For ADSM for VM, refer to Software Announcement 296-327 296-327,:elink. dated September 10, 1996.

For ADSM for MVS Version 2.1, refer to Software Announcement 295-212 295-212,:elink. dated May 30, 1995.

For ADSM for MVS Version 3.1, refer to Software Announcement 297-414 297-414,:elink. dated October 7, 1997.

For ADSM for HP-UX, refer to Software Announcement 297-034 297-034,:elink. dated March 4, 1997.

For ADSM for Sun Solaris, refer to Software Announcement 297-035 297-035,:elink. dated March 4, 1997.

Trademarks

      ADSTAR, AIX, AS/400, MVS, and OS/2 are registered trademarks of
      International Business Machines Corporation in the United
      States or other countries or both.
      Windows NT is a trademark of Microsoft Corporation.
      Microsoft is a registered trademark of Microsoft Corporation.
      Other company, product, and service names may be trademarks or
      service marks of others.

SUPPLEMENTAL INFORMATION

PUBLICATIONS

The following publication can be ordered after planned availability. To order, contact your IBM representative or local reseller.

Order Title Number

ADSMConnect Agent for SH26-4069 Microsoft (R) SQL Server Installation and User's Guide

Displayable Softcopy Publications: The ADSMConnect Agent for Microsoft SQL Server publication is offered in displayable softcopy form in the Adobe Acrobat and PostScript file formats. The files are shipped on the basic machine-readable material CD-ROM.

The Adobe Acrobat browser may be found on the Adobe web site at:

http://www.adobe.com

A complete list of the ADSM publications may be found on the ADSM Web site at:

http://www.storage.ibm.com/adsm

OPEN BLUEPRINT (R)

ADSM provides the desktop screen look and feel. Its implementation is consistent with the User Interface function described in IBM's Open Blueprint. It provides the OS/2 (R) Presentation Manager (R) interface from IBM, Motif industry-standard interface from the Open Software Foundation (OSF), Windows (R) interface from Microsoft Corp., XWindow Xlib industry-standard interface from X/Open, and to facilitate open, distributed, multivendor interoperability.

ADSM provides the capability to view printable documents on the workstation based on industry-standard formats. Its implementation is consistent with the View function described in IBM's Open Blueprint. It provides the ability to view in a 'What You See Is What You Get' (WYSIWYG) fashion, as well as manipulate and search documents with the Portable Document Format (PDF) from Adobe Systems, Inc., American Standard Code for Information Interchange (ASCII) industry-standard format from the American National Standards Committee (ANSI), and Graphics Interchange Format (GIF), a common Internet graphics format, to facilitate open, distributed, multivendor interoperability.

ADSM provides the ability to retrieve and present, or capture and store, distributed graphics, audio, video, and animation data. Its implementation is consistent with the Multimedia function described in IBM's Open Blueprint. It supports a class of multimedia devices available from different vendors to facilitate open, distributed, multivendor interoperability.

ADSM provides the Relational Database function described in IBM's Open Blueprint. It provides the Structured Query Language (SQL) industry-standard interface from the International Organization for Standardization (ISO), and Open Database Connectivity (ODBC) for Windows client systems interface from Microsoft Corp., to facilitate open, distributed, multivendor interoperability.

ADSM provides access to multiple file systems. Its implementation is consistent with the File function described in IBM's Open Blueprint. It supports the Distributed File Systems (DFS (TM)) industry-standard protocol from the Open Software Foundation (OSF), Server Message Block (SMB) industry-standard protocol from X/Open, and Network File System (NFS) protocol from Sun Microsystems, Inc., to facilitate open, distributed, multivendor interoperability.

ADSM is designed to protect and efficiently manage data and data storage devices. Its implementation is consistent with the Storage Management function described in IBM's Open Blueprint. It provides the Backup Services (XBSA) industry-standard interface from X/Open to facilitate open, distributed, multivendor interoperability.

ADSM provides the ability to transport information over wide area and local area networks. Its implementation is consistent with the Transport Services function described in IBM's Open Blueprint. It supports the Transmission Control Protocol/Internet Protocol (TCP/IP) industry-standard protocol from the Internet Engineering Task Force (IETF), Internetwork Packet Exchange (IPX) protocol from Novell, Inc., and Network Basic Input Output System (NetBIOS) protocol from IBM, to facilitate open, distributed, multivendor interoperability.

ADSM provides for the manageability of hardware and software resources. Its implementation is consistent with the Systems Management function described in IBM's Open Blueprint. It supports the Simple Network Management Protocol (SNMP) industry-standard protocol from the Internet Engineering Task Force (IETF) to facilitate open, distributed, multivendor interoperability.

TECHNICAL INFORMATION

Specified Operating Environment

Hardware and Software Requirements

Any ADSM Version 2 or Version 3 Server
For information on the ADSM Version 2 or 3 server requirements, refer to the Software Announcements listed in the Reference Information section of this announcement.
Microsoft SQL Server Version 6.0 or 6.5
For further information on the requirements for the MS SQL Server, refer to your Microsoft representative. For information on the latest version of MS SQL Server that is supported by the ADSMConnect SQL Agent, you may check the ADSM Web site at:
Intel (R)-based 486DX, Pentium (R), or greater processor with at least 20MB of available disk space. Minimum recommended RAM is 32MB.
Microsoft Windows NT (TM) Version 3.5.1 or 4.0
One of the following communication protocols which are included in the base Windows NT product package (see note):
- TCP/IP
- NetBIOS
- IPX/SPX
- Named Pipes
Note: Refer to the Software Announcements in the Reference Information section for the communication protocols which are supported by the specific server platform.

Planning Information

Packaging: The following basic materials are shipped to all ADSMConnect Agent for Microsoft SQL Server customers with each order:

CD-ROM containing the machine-readable code for ADSMConnect Agent for Microsoft SQL Server support and a softcopy of the Installation and User's Guide

The following hardcopy publications:

ADSMConnect Agent for Microsoft SQL SH26-4069 Server Installation and User's Guide

ADSMConnect Agent for Microsoft SQL GH26-4070 Server License Information

IBM Program License Agreement Z125-3301

Security, Auditability, and Control

ADSMConnect Agent for Microsoft SQL Server uses the security and auditability features of Microsoft SQL Server and the ADSM server operating system.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.

ORDERING INFORMATION

ADSMConnect Agent for Microsoft SQL Server has one charge unit, the install. An additional install is required for each MS SQL server or workstation using ADSMConnect Agent for Microsoft SQL Server.

An ADSM user registration is required for each MS SQL server or workstation using an ADSMConnect Agent. If you want to run multiple MS SQL Agents on one machine using multiple User Registrations, you must purchase the desired number of User Registrations.

Refer to the Ordering Information section in the Software Announcement for the ADSM server of interest, listed in the Reference Information section.

Order Program Name/ Type Feature Part Description Number Number Number

ADSMConnect Agent for 5801-AAR 1943 4301668 Microsoft SQL Server Program Package -- CD-ROM

ADSMConnect Agent for 5802-AAR 1088 4301669 Microsoft SQL Server 1 Install

Software Advantage

Order Type Part Program Name/Description Number Number

ADSMConnect Agent for 5802-AAR 4301670 Microsoft SQL Server 1 Install for Software Advantage

ADSMConnect Agent for 4301680 Microsoft SQL Server Media Pack for Software Advantage

ADSMConnect Agent for 4301681 Microsoft SQL Server Documentation Pack for Software Advantage

Software Advantage Upgrade Protection

Order Type Part Program Name/Description Number Number

Upgrade Protection for 5809-AAR 4301671 ADSMConnect Agent for Microsoft SQL Server 1 Install

TERMS AND CONDITIONS

Licensing: IBM International Program License Agreement. Proofs of Entitlement (PoE) are required for all authorized use.

Limited Warranty Applies: Yes

Program Services: Available until March 1, 2000

Guarantee: 30-day, money-back guarantee for program packages

Copy and Use on Home/Portable Computer: No

Support Line: Personal Systems

Software Advantage Applies: Yes

Upgrade Protection Applies: Yes Entitled Upgrade for Current Upgrade Protection Licensees: No

Variable Charges Apply: No

CHARGES

The charges provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

Order One- Type Feature Part Time Program Name/Description Number Number Number Charge

ADSMConnect Agent for 5801-AAR 1943 4301668 $995 Microsoft SQL Server Program Package -- CD-ROM

ADSMConnect Agent for 5802-AAR 1088 4301669 915 Microsoft SQL Server 1 Install

ADSMConnect Agent for 5802-AAR 1137 4301670 915 Microsoft SQL Server 1 Install for Software Advantage

ADSMConnect Agent for 4301680 5 Microsoft SQL Server Media Pack for Software Advantage

ADSMConnect Agent for 4301681 10 Microsoft SQL Server Documentation Pack for Software Advantage

Upgrade Protection for 5809-AAR 1767 4301671 366 ADSMConnect Agent for Microsoft SQL Server 1 Install

Support Line is covered under the Support Line contract for the specific ADSM Version 2 or Version 3 server. For more information, please contact IBM Support Family Information Center at 800-742-9235.

CALL NOW TO ORDER

To order, contact the IBM North America Sales Centers, your local IBM representative, or your IBM Business Partner (TM).

IBM North America Sales Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.

 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM North America Sales Centers
            Dept. SE010
            P.O. Box 16848
            Atlanta, GA  30321-0848
 Reference: SE010

To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

      DFS and Business Partner are trademarks of International
      Business Machines Corporation in the United States or other
      countries or both.
      Open Blueprint, OS/2, and Presentation Manager are registered
      trademarks of International Business Machines Corporation in
      the United States or other countries or both.
      Intel and Pentium are registered trademarks of Intel
      Corporation.
      Windows NT is a trademark of Microsoft Corporation.
      Microsoft and Windows are registered trademarks of Microsoft
      Corporation.
      Other company, product, and service names may be trademarks or
      service marks of others.

Share this page

Digg Facebook Twitter Linked In

Contact IBM

Feedback

Tell us what you think

-->