Solved

Remote DB Dump

Posted on 2000-03-21
6
449 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

 
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

734 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