Restore Options in sybase

[Former Member]

Hi ,

i have installed ECC 6.0 ehp6 with sybase . working fine , now requirement is need to build same system using backup .

for that i have taken backup using below commands .

1. Login as syb<sid>

used command prompt for log in (isql )

isql -Usapsa -SDQ1 -w4901

>

than i used for backup below command ,

dump database <SID> to 'path to backup/backup.dmp'

it completed shown completed 100 % dumped .

please let me know procedure for do restore into new server . please help me regarding this ,

Regards

Kumar

[tilman_model-bosch]

I assume the new server is up and running . If not you have to create the new ASE server.

Frist create the database in the new ASE server . You may retrieve the DDL statement for the database using the command line tool 'ddlgen.bat' which is located in %SYBASE%\ASEP\bin 

<drive>:\%SYBASE%\ASEP\bin\ddlgen -S<SID> -U<username> -TDB -N<DBNAME>  -F%

You will probably have to adapt its output to match the device names in the new server , you may also change the database name in the output .

Then use the changed DDL statment to create the new database .

To speed up creation of the new empty database in the other server specify 'FOR LOAD' in the CREATE DATABASE command .

Then load the dump of the original database

load database from '<location of dump>'

In 15.7.0 ESD#3 , which is available for use with SAp business Suite, there is a tool 'sybrestore' which helps to do all that.

Documentation for "sybrestore" is avilable online. 

Rgds

Tilman

[sap_mk]

On the new server, your database needs to be defined with the same data / log layout as the source. Then, use the command mentioned by Deepak, with one small correction (to -> from):

load database <SID> from <location/name of dump file>

Regards,
Mark Kusma

[former_member188883]

Hi Kumar,

For restore you may use the following command

load database <SID> to < location of backup dump>

Regards,

Deepak Kori

[Former Member]

Hi

i tried to load database using bellow commnad .

load database   DV1  from path of .dmp file

but it showing bwlow error can you tel me how to restore .

i logged in like

isql -Usapsa -SDV1 -w4901

and hit below commnad

load database DV1 from ".dmp"

Server 'DV1', Line 1:

Database in use.  A user with System Administrator (SA) role must have exclusive

use of database to run load.

1> exit

Regards

Kumar

[former_member188958]

Hi Kumar,

This message means that ASE thinks some session is in the database (i.e. it is their current database, they have done a "use database") or accessing an object in the database.  You can only load a dump into a database that isn't in use.

The most obvious things to check:

1) make sure your own session isn't using the database.  Do a "use master" before issuing the LOAD command.

2) Check for other users that have the database as their current database.  Run sp_who and look for the database name.  Alternatively, run

     select spid from master..sysprocesses where dbid = db_id("DV1")

3) Check for users that are in other databases but accessing tables in DV1 in cross-database transactions by looking for locks held in DV1 by running

     select spid from master..syslocks where dbid = db_id("DV1")

Those three checks will catch 99% of the cases causing this situation.

-bret

[Former Member]

Hi Bret

I have completed this using

use master

go

load database <SID> from "Path of .dmpfile"

go

Thanks

[Former Member]

This is the correct way to do that. No one can use the database while recovering it.

Take a look on a Blog that I wrote. I believe it will be helpfull..

http://scn.sap.com/community/sybase-ase/blog/2013/05/31/backup-challenges-on-sybase

BR  

Fred