Results 1 to 4 of 4

Thread: load database

  1. #1
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Unanswered: load database

    i'm trying to load database with these command and receive this error; i'm newbie with Sybase

    1> load database arbor_db_cat_srr
    2> from '/roaming/dump_arbor_db_cat_srr_1012.dmp'
    3> go
    Msg 7205, Level 17, State 2:
    Server 'SRR_ARBOR_SQL', 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:
    Server 'SRR_ARBOR_SQL', Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL
    Server boot directory.


    Thanks for helping

  2. #2
    Join Date
    Sep 2005
    Location
    France, Paris
    Posts
    34
    mmmmh arbor db, telecom...

    Are you sure your backup server is up and running ?
    Regards.

  3. #3
    Join Date
    May 2003
    Location
    France
    Posts
    112
    Backup server is now installed and running; but how can i change default backup server (SYB_BACKUP => xxx_BACK) ?

    Thanks for help

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    sp_dropserver SYB_BACKUP
    go
    sp_addserver SYB_BACKUP,NULL,xxx_BACK
    go

    where xxx_BACK is from your interfaces 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
  •