Specific steps for Sybase remote tape backup:
1. Add a tape device to the INTDB
Sp_addumpdevice "type", Logicalname,physicalname[,tapesize]
Such as:
Sp_addumpdevice "Type", Mytapedump, "/dev/nrmt8", 100
Note:
Mytapedump for configuring the tape device service name (optionally named)
/DEV/NRMT8 is a local tape device
100 is configured for 100m.
2. Configure the Netmdb backup service connection string on the Intdb
Configure the Host Backup service connection string in the interfaces file to include the remote backup server entry in the same name as the host backup service name.
However, the backup service name cannot be the same as the host backup service name.
3. Use Netmdb Backup connection string in Intdb, export data to local tape device
DUMP DATABASE database_name to mytapedump with Init at Bs_server_name
Note:
Database name of database_name backup
Mytapedump Tape Device
Bs_server_name Backup Service Connection string
Dump database my_sf to '/dev/rmt 0.1 ' at Jf_backup capacity=4000000 with Init