Can I use tape drive for backup with win 2012 OS & Sybase database?

[Former Member]

I have installed enhancement package 6 for SAP ERP 6.0 with OS windows 2012 and database sybase ASE(15.7.050). I am facing problem while taking database backup on tape drive. I want to know how to initialize tape drive in case of sybase DB and is it possible to take back-up on same. I failed to schedule backup from DB13 so now I am doing that activity by command line. So please help me to solve these issues.

Here I am attaching some files related with backup commands that presently I am using. My SAP system ID is DQS.

SAP DQS Backup.txt.zip

[former_member188958]

The attached file appears to show a succesful dump to a disk file, but doesn't demonstrate any issues with trying to dump to a tape device. 

Dumps to tape are supported on Windows.  Backing Up Data with a Tape Drive

Please provide details on the problems you are having.

-bret

[Former Member]

Dear Bret,

As I am new to Sybase ASE , could you please send me the commands for tape drive in detail. In previous message the attached file is for your reference purpose.

The link provided by you not giving me the exact idea.

Here also I am attaching the file showing problem while taking backup on tape drive.

Best Regards,

Vishal Patil

[former_member188958]

Which label is your tape drive mounted under (TAPE0, TAPE1, etc.)?

Lets start with the plain basic DUMP command and worry about setting up a

fancy newfangled dump configuration later.

Assuming TAPE0, your first dump to the tape would be

dump database <your_database_name_here> to TAPE0 with init

go

To append subsequent dumps, you would leave off the "with init" clause.

[Former Member]

Dear Bret,

Thank u very much for your valuable reply. Actually I tried with above given commands, but the backup is stored in OS drive(C:). In my system TAPE1 is the mount pt. for TAPE. I think the tape drive is not initiated, so can you provide me the commands for initialization of tape drive.

See the command line data for your reference.

Best Regards,

Vishal Patil

[former_member188958]

That output actually looks pretty good, it was dumping to the tape drive, it just ran out of tape because the drive apparently doesn't automatically detect when it is reaching the end.

For the next step, try adding a CAPACITY parameter to your dump command as discussed at these places in the documentation.

Specifying tape capacity for dump commands

Set the Maximum Capacity for a Tape Drive

Your output above shows it was able to dump 87565594 KB before it ran out of tape,

so lets be a little conservative and try

dump database DQS to TAPE1 with   capacity = 87000000, init
go

When the dump reaches that point, ASE should prompt you to pop in another new tape

and then issue the sp_volchanged procedure from a second session (it will tell you what parameters to use for sp_volchanged).

Note: once we get the dump working successfully, we can then create a logical dump device that would store the capacity value, and create a full dump configuration so you gain all the new functionality like dump history, etc.

Enhancements to dump and load

-bret