How to Mount IBM Tape Drive on windows 2008 SAP Platform

[Former Member]

Hi Expert,

What are the steps for Mount IBM Tape drive on windows 2008 SAP Platform on Sybase Database ?

After mounting IBM Tape Drive on windows 2008 SAP Platform , can i use this for Sybase Backup purpose from DBACOKPIT ?

Kindly reply me ASAP.

[Former Member]

Dear All,

Problem Solved by below activity :-

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc38421.1572/doc/html/san1335472614455...

1> dump database pubs2 to "\\.\TAPE0"

2> go

1> load database pubs2 from \\.\TAPE0

2> go

///

Please review  any of these SAP Notes to see if you would be able to

setup dump/load and then copy to tape as an option.

1585981 SYB: Ensuring Recoverability for Sybase ASE  (has some

comments about storing to tape drive)

1588316 SYB: Configure automatic database and log backups

1611715 SYB: How to restore a Sybase ASE database server (Windows)

1618817 SYB: How to restore a Sybase ASE database server (UNIX)

1887068 - SYB: Using external backup and restore with SAP Sybase ASE

Configuration DEVDB:

1> sp_config_dump @config_name='DEVDB' ,

2> @stripe_dir = "\\.\Tape0" ,

3> @compression = '101' ,

4> @capacity = '1520000040960' ,

5> @verify = 'header'

6> go

Configuration DEVLOG:

1> sp_config_dump @config_name='DEVLOG' with init,

2> @stripe_dir = "\\.\Tape0" ,

3> @compression = '101' ,

4> @capacity = '1520000040960' ,

5> @verify = 'header'

6> go

1> dump database DEV using config = 'DEVDB' with capacity = 87000000, init

2> go

1> dump transaction DEV using config = 'DEVLOG' with capacity = 87000000, init

2> go

and

1> dump database DEV to "\\.\TAPE0" with   capacity = 87000000, init

2> go

1> dump transaction DEV to "\\.\TAPE0" with   capacity = 87000000, init

2> go

[former_member188883]

Hi Subhash,

For Tape drive configuration refer to IBM link

http://publib.boulder.ibm.com/infocenter/tsminfo/v6/index.jsp?

topic=%2Fcom.ibm.itsm.srv.doc%2Ft_devices_config_manual_win2008.html

Additional useful information in links

http://scn.sap.com/thread/3422264

You need to configure your tape drive as device in sybase and then use below command

dump database <DBSDI> to <device>

[Former Member]

hi Deepak,

Can i use this for schedule sybase database backup from DBACOCKPIT SAP ?

Which command i have use for this ?

dump databse SID to '\\\\ .\\tape0' or \\\\ .\\tape1'