Solved

Remote DB Dump

Posted on 2000-03-21
6
443 Views
Last Modified: 2008-03-06
I'm running SQL 11.5.1 and trying to dump a database to a remote server.

The syntax I was using:  dump database master to "d:\syback\mastdat.dat" at PC_REMOTE_BS

I have added the appropriate backup servers to DSEDIT, pinged from the remote and master server and stopped and started both SQL servers.  I also checked sp_helpserver on both local and remote servers and see the appropriate server entries.  I have also turned on remote access and enabled the CIS RPC handling options on both boxes.

When I try to dump the database to my remote server I get an error "Cannot open a connection to the slave site ..."?

I have a feeling this is something basic I overlooked - any help suggestions are appreciated.

0
Comment
Question by:edvw4
6 Comments
 

Expert Comment

by:DanSolo
ID: 2641745
Hi,

Often I've encountered clients that where trying to backup to backup servers that where not up and running. Are BOTH the local and remote backup servers up and running?

It's important that the local backup server be running as Sybase uses it to route out to the remote server.

Can you post the results of a select * from sysservers and sysremoteservers.

Dan

0
 

Author Comment

by:edvw4
ID: 2641817
Dan,

I think I forgot to mention but I'm on NT 4.0 w/ SP4.

Both servers are up and running.  When I'm in Sybase Central I can see both the main and remote servers.  The odd thing is that when I'm local to the main or remote server Sybase Central shows a green light for the local BS, but not for the remote BS.  When I check the other server's Sybase Central the BS light is green.  Also the sp_helpserver shows the remote BS and I can ping the remote or main server from the respective DSEDIT.  

Below is the output of select * from sysservers from the remote server (PC_EVANWIN):

srvid       srvstatus   srvname                        srvnetname                       srvclass    srvsecmech                    
----------- ----------- -------                        ----------                       ----------- ----------                    
          1           8 SYB_BACKUP                     PC_EVANWIN_BS                           NULL NULL                          
          2           0 PC_EVANWIN_XP                  PC_EVANWIN_XP                           NULL NULL                          
          3           8 PC_MERRINED_BS                 PC_MERRINED_BS                             1 NULL                          

This is the select * sysservers from the main server (PC_MERRINED) I'm pushing the dat file from:

srvid       srvstatus   srvname                        srvnetname                       srvclass    srvsecmech                    
----------- ----------- -------                        ----------                       ----------- ----------                    
          1           8 SYB_BACKUP                     PC_EVANWIN_BS                           NULL NULL                          
          2           0 PC_EVANWIN_XP                  PC_EVANWIN_XP                           NULL NULL                          
          3           8 PC_MERRINED_BS                 PC_MERRINED_BS                             1 NULL                          


Thanks for the reply.

0
 

Author Comment

by:edvw4
ID: 2641844
Dan,

Sorry I miss copied the select * from sysservers on the PC_MERRINED box.  Here's the output:

srvid       srvstatus   srvname                        srvnetname                       srvclass    srvsecmech                    
----------- ----------- -------                        ----------                       ----------- ----------                    
          1           8 SYB_BACKUP                     PC_MERRINED_BS                          NULL NULL                          
          2           0 PC_MERRINED_XP                 PC_MERRINED_XP                          NULL NULL                          
          3           8 PC_EVANWIN_BS                  PC_EVANWIN_BS                              1 NULL                          
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 2

Expert Comment

by:jkotek
ID: 2641872
Hi,

I have two suggestions for you:

1) check the interfaces files:
on remote site (PC_EVANWIN) you should have the local backup server and local dataserver (both at PC_MERRINED)
on local site (PC_MERRINED) you should have a remote backup server (at PC_EVANWIN)

2) if the above tip won't help - check also the network protocols for named pipes - they sometimes mess up the communication between Sybase servers - avoid them if you can.

Jkotek
0
 

Expert Comment

by:thacsi
ID: 2646622
Have you checked the "number of remote sites" parameter ?
It must at least be 2 if you want to connect to a backup server.
0
 

Accepted Solution

by:
kwitcher earned 50 total points
ID: 2730827
This is due to the following security
 restriction imposed by NT: (refer Microsoft
 Product Support's Knowledge Base article # Q124184)

 By default, all services are started by the 'LocalSystem' user account,
 which operates with what NT calls
 NullSession privileges. These privileges are very limited. It does not
 allow the service to access network mounted
 drives, e.g, NFS, netware or NTFS mounts from other machines.
 Hence, we see the 'Access denied' message when
 dumping to remote drives.

 The resolution is to configure the Backup Server service to start
 using a regular user account, rather than NT's
 default account. This user should have privilege to access the remote
 drives.

 To configure Backupserver with a regular User account:
 -----------------------------------------------------
 1. Double click the Services Icon under the Control Panel.
 2. Double click the entry for backup server service, usually has a
 name beginning with Sybase_BCKServer.
 3. Click 'This Account' button under 'Log on As:' and select the
desired
 user by clicking the button marked with
 '...'. Also supply the password for this user.
 4. Click OK on the Dialog Box and then 'Close' on the Services Dialog
 Box.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Hyena v12.2 is now available for downloading and is available in English, French, German and Spanish versions.
Use of TCL script on Cisco devices:  - create file and merge it with running configuration to apply configuration changes
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now