Cannot backup db over lan... SQL error

Posted by Matt on January 12, 2006, 11:31 am

Please log in for more thread options

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
SettingsMattDesktopwine.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!

Posted by Matt on January 12, 2006, 11:31 am

Please log in for more thread options

I should point out that RMS is using MSDE and not a full SQL server.

"Matt" wrote:

> 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

> SettingsMattDesktopwine.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!

Posted by Glenn Adams [MVP - Retail Mgmt on January 12, 2006, 1:06 pm

Please log in for more thread options

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:
\ServerBackupMyRMSBackupFile.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"...

--
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information

> 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

> SettingsMattDesktopwine.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!

Posted by Jeff on January 12, 2006, 9:19 pm

Please log in for more thread options

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.

--
*
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
SettingsMattDesktopwine.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!

Posted by Tom Platinum sy on February 2, 2006, 8:12 am

Please log in for more thread options

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.platinumsystemsltd.com

"Jeff" wrote:

> 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.

> --

> *

> 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

> SettingsMattDesktopwine.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!