Table backup

[Former Member]

Hi team,

Suppose i want to take backup of a table in sybase how do we do it ?

bcp SID.SAPSR3.TABLE out TABLE.out -c -t -Usapsa -SSID

I dont want to use BCP.

i want to create a copy of the main table means create table as select * from maintable. is it posisble ?

[former_member59574]

Hi p517710,

Maybe helpful ifno is at SAP Note 1942 - How does R3trans work

I use to backup tables with R3trans - it always works.

Detail info you can find at>

http://basisbibo.blogspot.de/2010/01/bb-note-004-sap-table-copy-with-r3trans.html

best regards,

Peter

[Former Member]

Hi peter,

Thanks for the response.

Many other ways are also there for taking backup, R3trans is good option but i would prefer transport request in case of bigger tables.