attempting to run the command gives me the following reply

FATAL ERROR: D:\PROGRA~1\CSCOpx\databases\dfmlnv\orig\odbc.tmplorig does not exist, or is not readable.

Verify that the DSN exists, before contacting a Cisco support engineer.

The file does exist though and the contents are below....

UID=itemInvUser

PWD=c2kY2k

Start=dbsrv10

DatabaseName=dfmInvDb

EngineName=dfmInvEng

CommLinks=tcpip{HOST=localhost;DOBROADCAST=NO;ServerPort=43446}

JdbcDriver=com.sybase.jdbc2.jdbc.SybDriver

AutoStop=yes

CWENCRYPTION=YES

# note __ values are not passed through for odbc registration

# These __ values are skipped by odbcdsn.pl.

# These __ values are used for configuring db engine startup parms.

__Cache=32M

__DbNTSvcLongName=DFM dfmInv database engine

There also appears to be an entry in the OBDC data sources for this - however I will admit to not being a database engineer.

This error would only occur if the file didn't exist, or the parent directories were not accessible to the user running the command. As the same user that ran the dbRestoreOrig.pl command, please run the following command from a DOS prompt, and post the output:

DIR D:\PROGRA~1\CSCOpx\databases\dfmlnv\orig

I have just double checked the file name I have on the server is dfmInv (Uppercase 'I') and not dfmlmv (lower case 'L'). So on the server I have a directory called delta foxtrot mike india november victor.

Is this folder missing then?

I have attached a screen print of the directory listing below.

The datasource name is dfmInv, so your directory structure looks correct. However, the test for the file is fairly straightforward. I would still like to see the DIR output requested in my previous post.

directory listing as requested

C:\Documents and Settings\Administrator>DIR D:\PROGRA~1\CSCOpx\databases\dfminv\orig

Volume in drive D is Data

Volume Serial Number is E413-8E02

Directory of D:\PROGRA~1\CSCOpx\databases\dfminv\orig

05/11/2008 10:21

05/11/2008 10:21

27/11/2007 19:14 2,113,536 dfmInv.dborig

06/10/2008 16:41 506 odbc.tmpl

26/11/2007 10:53 467 odbc.tmplorig

3 File(s) 2,114,509 bytes

2 Dir(s) 117,760,270,336 bytes free

C:\Documents and Settings\Administrator>

OK that command has run successfully and I have deleted the backup.lock file - I will post back tomorrow morning with the results of the backup process.

Giles

The backup ran successfully. So all is well on that system now....

Thanks

Giles

ok, thank you so much.
The solution is right ....
: D