We use a 3rd party for hosting our DB and websites, but the machines are in a workgroup and therefore permissions cannot be granted to other servers for what I am trying to do.
The DB server needs and upgrade but I am awaiting financial sign off for a new server to be commissioned.
I asked the 3rd party to restore the BAK file to a web server so I can FTP it to the office to restore on our DEV server, they said they can only restore it back to the DB server, thats alright apart from the fact that the DB server doesnt have enough space for the BAK file to be placed on.
On one of our web servers I created a share and gave everyone full control to the share, but the DB server wont backup to it, so I created the share as a network drive but still no luck.
I know I cant add the DB server into local admins on the Web server as they cant see each other through computer manager, but they are on the same private network and can ping, map drives and talk over name and IP, its just share permissions which is the problem.
Can anyone help with this, don't know if its me or if its Monday morning mind blank.
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'z:\db1.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 1815).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.