1. Home
  2. Point-Of-Sale Software
  3. Cannot backup db over lan... SQL error

Cannot backup db over lan... SQL error

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!

Reply to
Matt
Loading thread data ...

Reply to
Matt

You are trying to back up to the 'servers' C: drive and you don't have rights to do it remotely. You need to use a path that will resolve to the same physical location from both the 'server' and the remote computer - UNC paths are usually the easiest was to do this.

Create a shared directory on the machine that you want the backup file to be stored on. Lets say that is machine name "Server" and the share is named "Backup"

When you go to backup the database, enter the filename as: \\Server\Backup\MyRMSBackupFile.bck

This should work, but you will need to make sure that the Share is setup to allow "Modify" access to whomever is going to run the backup - mayber just grant "Modify" to "Everyone"...

Reply to
Glenn Adams [MVP - Retail Mgmt]

Matt,

If Glenn's answer doesn't work for you, backup the file to the same machine that MSDE is on and then copy it to the other computer.

Reply to
Jeff

Had the exact same problem.

i wanted to be able to backup to the a removable drive on a remote computer i got round this by simply sharing the e: drive on the computer.

www.plat> Matt,

Reply to
Tom Platinum systems ltd

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.