Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    2

    Unanswered: saybase backup error

    hey all

    im trying to take a backup of the sybase database.

    1) a backup server(OVPI_BS) is successfully created and configured( for the netowrk connection the protocol is TCP Winsock TCP/IP Net-library driver, and for the connection info "computer name,2084)

    2)the service Sybase BCKserver_OVPI_BS is started
    3)a dump device is succefully created by running the following commands:

    a) sp_addumpdevice "disk", diskdump, "C:\HOME\diskdump.dat
    b) go

    the below output appear:
    'disk' device added.
    <return status=0>

    4) when trying to dump the database to a device by executing the below commands the following outputs appear:

    C:\Documents and Settings\Administrator>isqL -Usa -P
    1> dump database master to "C:\sybdump\mastdump.dat"
    2> go
    WARNING: In order to LOAD the master database, the ASE must run in single-user
    mode. If the master database dump uses multiple volumes, you must execute
    sp_volchanged on another ASE at LOAD time in order to signal volume changes.
    Msg 7205, Level 17, State 2:
    Server 'OVPI_SYBASE', Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE
    boot directory.
    Msg 7205, Level 18, State 3:
    Server 'OVPI_SYBASE', Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE
    boot directory.


    1> dump database sybsystemprocs to "C:\sybdump\procdmp.dat"
    2> go
    Msg 7205, Level 17, State 2:
    Server 'OVPI_SYBASE', Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE
    boot directory.
    Msg 7205, Level 18, State 3:
    Server 'OVPI_SYBASE', Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE
    boot directory.


    1> dump database dpipe_db to "C:\sybdump\dpipedmp.dat"
    2> go
    Msg 7205, Level 17, State 2:
    Server 'OVPI_SYBASE', Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE
    boot directory.
    Msg 7205, Level 18, State 3:
    Server 'OVPI_SYBASE', Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE
    boot directory.


    is there any idea about this error msg!?

    can someone plz check my steps if there is something missed or wron?

    thank you in advance

    Regards

  2. #2
    Join Date
    Oct 2009
    Posts
    2
    ?????????????

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    if you run sp_helpserver does SYB_BACKUP point to your backup server BCKserver_OVPI_BS?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •