Results 1 to 7 of 7

Thread: Dump

  1. #1
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81

    Unanswered: Dump

    Hi,
    I use 11.9 on Solaris
    I try to backup my database from ISQL:

    1> dump database users to "/tmp/syb_users.bak"
    2> go

    And the result is:

    Msg 7205, Level 17, State 2:
    Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
    Msg 7205, Level 18, State 3:
    Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.

    The error log file says the following:

    00:00000:00007:2003/09/01 12:33:25.67 kernel Connectivity Library (Directory Control Layer) Error: Error returned by service provider.
    00:00000:00007:2003/09/01 12:33:25.76 kernel Connectivity Library (Directory Control Layer) Error: (InterfacesDriver): Requested server name not found.
    00:00000:00007:2003/09/01 12:33:25.76 server Error: 7220, Severity: 11, State: 1
    00:00000:00007:2003/09/01 12:33:25.76 server Site 'SYB_BACKUP' not found in interfaces file.
    00:00000:00007:2003/09/01 12:33:25.76 server Error: 7235, Severity: 17, State: 0
    00:00000:00007:2003/09/01 12:33:25.76 server No other query entry found for the remote server SYB_BACKUP - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.


    Could anyone please explain me how to perform this backup ?
    What are interfaces files ? Where are they stored ?

    Thanks
    --
    kukuk

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    I'd simply drop and re-create a new backup server(much quicker) than finding whatz wrong?

    The interfaces file by default is in $SYBASE directory.

    Cheers,

    Willy

  3. #3
    Join Date
    Aug 2003
    Posts
    123
    check that the backup server is running, else start the backup server first and run the dump command. if you still face the same problem follow willy advice.

    --Jaggu

  4. #4
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    How can I check whether backup server is running ?
    How can I start it ?

    Tx.
    --
    kukuk

  5. #5
    Join Date
    Aug 2003
    Posts
    123
    In unix run the following command
    'ps -eaf grep backup' u will know whether the backup server is running or not, else send me the out put.

    --Jaggu

  6. #6
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    Well, it is not running.
    How can I start it ?
    --
    kukuk

  7. #7
    Join Date
    Aug 2003
    Posts
    123
    U must be having the startup script for starting the backup server if not
    run this
    startserver -f RUN_<backup server name> you can find this value in interface file.

Posting Permissions

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