Remote DB Dump
Posted on 2000-03-21
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.