Forum Discussion

evo's avatar
evo
Level 4
9 years ago

restoring sybase database with different database name

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 

7.7
Backup and Recovery
NetBackup
Recovering
Restore
Tip-How to
UNIX
  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    9 years ago

    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.

  • Nicolai's avatar
    Nicolai
    Moderator
    9 years ago

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

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

    Page 62

     

  • evo's avatar
    evo
    Level 4
    9 years ago

    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's avatar
    Marianne
    Level 6
    9 years ago

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

  • evo's avatar
    evo
    Level 4
    9 years ago

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

  • Nicolai's avatar
    Nicolai
    Moderator
    9 years ago

    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's avatar
    Andy_Welburn
    Level 6
    9 years ago

    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's avatar
    Michal_Mikulik1
    Moderator
    9 years ago

    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's avatar
    rakeshrsc
    Level 2
    9 years ago

    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's avatar
    rakeshrsc
    Level 2
    9 years ago

    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...