cancel
Showing results for 
Search instead for 
Did you mean: 

restoring sybase database with different database name

evo
Level 4
Partner Accredited

Hi All,

We are using NBU 7.7 to backup Sybase databases. 

Now we are doing restore tests of Sybase databases. We can restore database with same database name with the following LOAD command.

load database mydb from "sybackup::SYBASE.mydb.D.0.14693.07-08-2015.09:29:37 -SERV saturn"

go 

But we want to restore the database with different name. source db name is mydb and destination db name must be testdb. So what is the LOAD command for this operation?

Regards 

1 ACCEPTED SOLUTION

Accepted Solutions

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

I recommend to test it "off NetBackup" first, so from a simple native disk dump.

If it succeeds, the Restore via NetBackup should succeed, too.

There should be some prereq on Sybase side as I remember, like similar db segment structure etc.

View solution in original post

9 REPLIES 9

Nicolai
Moderator
Moderator
Partner    VIP   

Did you read the section about re-directed restore in the admin manual ?

http://www.symantec.com/docs/DOC5178

Page 62

 

evo
Level 4
Partner Accredited

Hi Nicolai

Yes, I read the guide. But  it is only talking about redirected restore to different client, not different database. I need to restore "mydb" database to "testdb" database.

So I think we need to do something with the LOAD command.

Regards. 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Probably best to look for the answer in Sybase documentation or user forum.
It will be a Sybase parameter, not NBU.

evo
Level 4
Partner Accredited

Yes, I know this is a Sybase issue. But I am just wondering, if someone did this type of Sybase database restore?

Nicolai
Moderator
Moderator
Partner    VIP   

Sybase questions is rare in this forum. I am afraid your question will remain unanswered.

If you dig up a answer elsewhere - please post it.

Best Regards Nicolai

 

Andy_Welburn
Level 6

I presume it's not as simple as:

 

load database testdb from "sybackup::SYBASE.mydb.D.0.14693.07-08-2015.09:29:37 -SERV saturn"

go


 

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

I recommend to test it "off NetBackup" first, so from a simple native disk dump.

If it succeeds, the Restore via NetBackup should succeed, too.

There should be some prereq on Sybase side as I remember, like similar db segment structure etc.

rakeshrsc
Level 2

Hai i am rakesh..

I am Using Adaptive Server Anywhere 7.0(dbeng7.exe)..

When i open ASA 7.0 (dbeng7.exe)..APPCRASH Error comes..

While i Uninstall Symantec End Protection 12.0.6 ..issue solved..

 

Please Help me...

rakeshrsc
Level 2

I am Using Adaptive Server Anywhere 7.0(dbeng7.exe)..

When i open ASA 7.0 (dbeng7.exe)..APPCRASH Error comes..

While i Uninstall Symantec End Protection 12.0.6 ..issue solved..

Please Help me...