I want to take my backups on a network location but when i use the following command
EXEC sp_addumpdevice 'disk', 'mydevice',
'\\servername\sharename\filename'
BACKUP DATABASE MyDB TO mydevice
it gives the operating system error permission denied, although i have full permissions on the share.
can anyone help on this. i would be great
ady