I'm trying to backup an RMS database from the LAN. The db is located on the server, which is also a cash register. This can be backed up from the LAN to the server with no problem. However, when I try to back up either from the server itself or from another machine to a drive over the LAN, I get an error saying it cannot connect to the location. Here's the error message:
"Cannot open backup device 'C:\Documents and Settings\Matt\Desktop\wine.bck'. Device error or device off-line. See the SQL Server error log for more dtails. BACKUP DATABASE is terminating abnormally."
This happens when trying to back up the database to any place other than locally on the server.
Anyone have any ideas as to what may be happening or how I can fix this?
Thanks!