Backup error

[Former Member]

Hi

Quality system automatic backup is showing error..tape drive also some problem..

i want to setup manuall back ..please where i am going to configure..

please steps

OS: Windows

DB : DB2

Edited by: Sri Sap N on Feb 16, 2010 9:34 AM

[former_member524429]

Hi,

You can perform Disk to Disk Backup.

You can perform manual backup using DB13 job "Database Backup to Device", where you will have to provide full directory path of the location where you want to save Backup File, along with other required parameter values as mentioned in below command.

At command level (DB2CLP) you can execute the following command.

> db2 BACKUP DATABASE <DBSID> TO <directory location> WITH 2 BUFFERS BUFFER 4096 INCLUDE LOGS WITHOUT PROMPTING

If you want to take DB Backup to remote Disk/directory location of remote host, then make sure that the User (with with the DB2 Instance processes/service are running ) should have the read/write/change access authorizations at remote location.

Regards,

Bhavik G. Shroff

[former_member190272]

Hi,

Try To This Command db2 BACKUP DATABASE IDS TO F:/backup. IDS is your SID.

Regards,

Pankaj

[Former Member]

Hi,

Please give the error log also when posting any issue which will help us to help you soon. As you already said there is a problem with tape and you want to take manual backup, take the backup to a disk (based on availability of space)

For that you need to make changes in the below parameters in init<SID>.sap file

backup_type (online or offline)

backup_dev_type (disk)

backup_root_dir (path of disk where u r taking backup)

After this you can start the backup from DB13 or from BRTOOLS

Thanks & Regards,

Sharath

[Former Member]

hi

Database is DB2

here no initQAS.sap file...

[Former Member]

Hi,

Please refer the below link

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/80e61772-e471-2c10-60b1-9529b69b50c5

Also, you can try to set the parameters from DBACOCKPIT tcode and see if can find any file init<SID>.db6

Thanks & Regards,

Sharath Babu M

[Former Member]

Hi Sri,

For DB2 use DB2CC tool to schedule backup and edit the file "init<DBSID>.db6 to adjust the required parameters. Please refer to the following link to explore the guide for DB2 on NW 04 on windows:

https://websmp108.sap-ag.de/instguides

Regards

Sourabh Majumdar

Edited by: Sourabh M on Feb 16, 2010 2:48 PM