I have access to the SQL box, via management studio only. I have access to a web server (that hosts the app), with management studio on it, residing in the same subnet. I'd like to run a backup from management studio on the web server, to backup the DB to the web server.
I have created a shared directory on the web server to backup to - when I try to add this as a destination, I get the following alert - cannot verify the existence of the backup file location. If I accept and try to run I get the following error - backup to mirrored media sets requires all mirrors to append.
Any ideas? Not sure what I am missing. :-)