Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 465
  • Last Modified:

Remote DB Dump

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
edvw4
Asked:
edvw4
1 Solution
 
DanSoloCommented:
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
 
edvw4Author Commented:
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
 
edvw4Author Commented:
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
jkotekCommented:
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
 
thacsiCommented:
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
 
kwitcherCommented:
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now