I have a server running SQL 2008. I'd like to back up my primary database to a folder that is somewhere else on the network. After having tried a few different ways, I always get the same error.
Msg 3201, Level 16, State 1, Line 3
Cannot open backup device 'Z:\My_Backup_Wednesday.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 3
BACKUP DATABASE is terminating abnormally.
However, the Z:\ drive is mapped properly & I can read from or write to it.
What is the accepted practice on this? If I had more free room I would export to a temp folder & move the file with a batch script, but I need ~100gb and don't have it to spare.