HotCopy can't find drive/directory

je79ayps

I'm trying to backup our database to a network share but HotCopy keep's complaining about this:

C:\Documents and Settings\dataabc>"D:\Program Files\Navision Attain\Database Ser
ver"\hotcopy source=D:\NavisionDB\DT2KTEST.fdb destination=z: nettype=tcp server
name=dt2ktest user=backup password=backup
Backup W1 3.10.A

Backup Tool for Navision Attain version 3.10.A
Copyright (c) 1987-2002 Navision a/s.

Backup started at 2006/10/30 12:38:28.

Free space on the destination volume Z:\ is 464962944 KB.
Total size of database files is 4000000 KB.

List of database files to be backed up on volume Z:\:
        D:\NavisionDB\DT2KTEST.fdb

List of backup files for volume Z:\:
        Z:\DT2KTEST.fdb


The following message came from the server.

The operating system cannot find the drive and directory specified for the file
 .

Please check that the drive, directory and file names are correct.

Backup ended with an error at 2006/10/30 12:38:28.

The network share is on a different domain and the drive Z: is therefore mapped with a user on that domain. However, if I use the UNC path instead of Z: it gives me the same error.

I can manually copy and paste the file to the network share.

Can anyone please tell me where the error is?

je79ayps

No scheduled tasks - just in a DOS window.

I've been wondering about the network share too but since there's this example in the manual I think UNC shares are okay:

hotcopy source=database.fdb
destination=\\backupcomputer\backup\Monday

Waldo

try to copy to the \\myserver\myshare\ instead of the mapped drive Z:. I remember that there is a difference for NAV.

je79ayps

Unfortunately it's the same.

But it must almost certain be something with network share because if I state a non-existing database file I get this:

The operating system cannot find the file D:\NavisionDB\DT2KTEST1.fdb .

Please check that the drive, directory and file names are correct.

The backup description file  could not be parsed.

So HotCopy can access the database file it seems. Can it have something to do with user permissions? Remember that the share is on another domain.

matteo_montanari

je79ayps wrote:

Unfortunately it's the same.

But it must almost certain be something with network share because if I state a non-existing database file I get this:

The operating system cannot find the file D:\NavisionDB\DT2KTEST1.fdb .

Please check that the drive, directory and file names are correct.

The backup description file  could not be parsed.

So HotCopy can access the database file it seems. Can it have something to do with user permissions? Remember that the share is on another domain.

HotCopy ask Navision Service to create a new DB.
Navision Service run as System Profile and it can create a new database only where System can access.

Matteo

je79ayps

So I should have the service running as a user that has access to the share? Is there any "problems" involved with changing this?

Waldo

No problem.

Just make sure the user is able to run the service, to log into Navision and to write to the folder.

je79ayps

OK, here's what I've tried so far.

1. Create 2 identical users with the same password in both domains. Configured the Navision service to use this user to start the service. I know this should work, as you also point out, but it didn't.

2. Tried to backup to a drive located on another server in the same domain. Still same error.

3. Insert a new drive to the server so the backup is done locally and not through the network. This works so I guess this is the solution.

I think perhaps my HotCopy 3.10 is too old to deal with network shares - maybe.

Thanks for all your help!

BBlue

I recently had the same problem. Appearently, hotcopy doesn't handle network shares. You can:
-use task scheduler from Windows to have hotcopy make you backups of database at specified dates and times on a local computer(it doesn't need to be in the domain where you have the destination network share)
-create a user on that domain with write access on a network share
-log in from the local computer with that user, to access the network share
-make a .bat file which should contain, for example, the following line:
"copy \Backupfolder\database.fdb Z:\Backupdestination", where the first part is the source path on the local computer, and the second one is the destination path on the network share, accesible through that account.
In the .bat file, make sure you use dos names for folders, e.g. if you have a folder named MicrosoftNavisionBackup, in dos it would be micros~1 (a maximum of 8 characters).
-use task scheduler to automatically perform the copying operation, making sure the time when the backup is made on the local computer is prior to the time when the copying on the network share is being done.
Bear in mind that if you set automatically backup for hotcopy, it will overwrite the previous database file, without asking you. The same is when the system copies the database file on the network share.
This way, you won't have to manually create the backup file and copy it to the network share. These 2 processes can be done automatically by task scheduler, at specified moments. I wish you good luck.

BBlue

I forgot to mention that you can use a parameter text file for hotcopy that will be placed in the Navision server folder. This should look like this:

"[Backup Files]
\SourceDatabaseFolder\database.fdb=D:\Backupfolder

[Options]
description="Backup"
dbtest=normal
cc=yes
osauthentication=no
servername=MYSERVER
nettype=tcp"

In task scheduler, to have hotcopy use the parameter file every time, you can call the program like this: "hotcopy.exe source=parameters.txt", where parameters.txt is the text file containing the above lines(which you cand modify according to your needs), located in the same folder as the hotcopy file (the Navision server folder). This will automatically make a backup of the database on the local computer.