SQL Server - Backup database to remote server - Asked By Ran SIdon on 08-Jul-05 04:27 AM

Hi,
I am trying to backup a database from within a java program via JDBC.

I want to be able to backup a database to a remote computer.

BACKUP DATABASE cowboys_mng_580
TO disk='\\assist\5.1_SP1_Backups\MSSQL\RANS_MNG_HUMPTY_ORACLE_AWEB4.bak'

doesn't work

while 

BACKUP DATABASE cowboys_mng_580
TO disk='d:\RANS_MNG_HUMPTY_ORACLE_AWEB4.bak'

works

Any solutions?

Make sure you are - Asked By Jon Wojtowicz on 08-Jul-05 05:52 AM

referring to a share on the remote server. Verify the SQL Server service account has permissions to the share and the endpoint file on the remote server.