We've just encountered the following problem a our remote DB location. The
backup was not running properly and the transaction log file got to be 1.16
GB.

I backed up the transaction log but DBRemote is still running out of space
processing it.

Unused space on C: 203 MB
Unused space on D: 35.2 GB

The remote database is acting primarily as a backup to the main image
database in another city so nothing is inserted into it except via the
replciation. The remote previously finished processing several messages from
the consolidated DB so I suspect it's only trying to send an
acknowledgement.

Is there anyway to tell DBRemote to use a temp folder on D:?
Or is there another way to look at the problem?

Thanks
Robin Thompson
LPD Enterprises Inc.

I. 04/11 14:30:30. 1: -c
I. 04/11 14:30:30. 2: ************************************************
I. 04/11 14:30:30. 3: -ek
I. 04/11 14:30:30. 4: ******************
I. 04/11 14:30:30. 5: -m
I. 04/11 14:30:30. 6: 10M
I. 04/11 14:30:30. 7: -t
I. 04/11 14:30:30. 8: -w
I. 04/11 14:30:30. 9: 1
I. 04/11 14:30:30. 10: -v
I. 04/11 14:30:30. 11: -m
I. 04/11 14:30:30. 12: 30M
I. 04/11 14:30:30. 13: D:\database\dms_edm\backup
I. 04/11 14:30:30. SQL Remote Message Agent Version 9.0.2.2551
I. 04/11 14:30:30.
I. 04/11 14:30:30. Copyright 1989-2004 Sybase, Inc.
Portions Copyright 2002-2004, iAnywhere Solutions, Inc.
I. 04/11 14:30:30. All rights reserved. All unpublished rights reserved.
I. 04/11 14:30:30.
I. 04/11 14:30:30. This software contains confidential and trade secret
information of
I. 04/11 14:30:30. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 04/11 14:30:30. by the U.S. Government is subject to restrictions set
forth in a license
I. 04/11 14:30:30. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 04/11 14:30:30. other written agreement specifying the Government's
rights to use the
I. 04/11 14:30:30. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 04/11 14:30:30.
I. 04/11 14:30:30. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
94568, USA
I. 04/11 14:30:30.
I. 04/11 14:30:32. Scanning logs starting at offset 0000972463
I. 04/11 14:30:32. Processing transaction logs from directory
"D:\database\dms_edm\backup"
I. 04/11 14:30:32. Transaction log "D:\database\dms_edm\backup\060411AA.log"
starts at offset 0000410578
I. 04/11 14:30:32. Processing transactions from transaction log
"D:\database\dms_edm\backup\060411AA.log"
E. 04/11 14:33:36. Error writing file
"C:\DOCUME~1\ADMINI~1.ABC\LOCALS~1\Temp\_T85" -- No space left on device
E. 04/11 14:33:36. Sending messages failed
E. 04/11 14:33:36. Error writing file
"C:\DOCUME~1\ADMINI~1.ABC\LOCALS~1\Temp\_T85" -- No space left on device
I. 04/11 14:33:42. Execution completed

DUUHH! - Problem solved

I found the solution. Set the TEMP or TMP environment variable(s) to the
desired location and restart the remote.

Thanks to anyone who looked at this.

Robin

"Robin Thompson" <rthompson (AT) lpdenterprises (DOT) ca> wrote