Why backup to remote device doesn't work?

[TheBugSlayer]

I am creating a backup using the Wizard but it fails to run because in 'Select Backup Destination' I am choosing a UNC name.

In QA I tried:
USE master
EXEC sp_addumpdevice 'disk', 'FP_FULL',
'\\sql-archive\sqldata\fp.dat'

BACKUP DATABASE MyDDB FP_FULL

THe device is created successfully however the backup fails with message "Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'FP_FULL'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally."

Does anyone have any idea why this happens? Thank you.

 

[JayKusch]

Is the folder "shared"?

Thanks

J. Kusch

 

[SQLBill]

To add to J.Kusch's comment, does the login you are using to do the backup have permission to write to the file?

-SQLBill

 

[TheBugSlayer]

The folder is shared, yes. But I was suspecting that maybe the login used to do the backup doesn't have the rights to write to the folder. So I will take your suggestion and have the NT guys give the login from each server write permissions to the shared folder. Hmmm, this means that backup will fail each time it is run under an account that does not have write permissions to the folder...

 

[SQLBill]

Give the Backup Exec SERVICE access to the shared folder. Remember, you had to create an account for the SERVICES to run under.

-SQLBill