|
Home > Archive > SQL Anywhere Feedback > October 2005 > Can't DBBACKUP touch the dababase file?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can't DBBACKUP touch the dababase file?
|
|
| Volker Barth 2005-09-29, 7:24 am |
| (This is the third attempt to submit this posting - please
excuse me if the former attempts may also be visible...)
Hi all,
I just altered our backup procedure from using the BACKUP
DATABASE statement to DBBACKUP.
And then I stumbled over the fact that the backup .DB file
had an old file timestamp and got worried for a while.
Fortunately, I remembered the following thread in this
newsgroup, which was started by Breck on Jan 13, 2005:
"thread "dbbackup should "touch" backup database file".
From this thread, with all its hints and explanations, the
question remains:
Can't DBBACKUP touch the dababase file?
Or is this going to be changed in a future release/EBF?
I'm using ASA 8.0.3.5251, so "DBBACKUP -s" is not available
(if this would influence the file time, as it seems to use
BACKUP DATABASE internally).
TIA
Volker
| |
| Breck Carter [TeamSybase] 2005-10-27, 7:41 am |
| I agree with you; at the very least, it should be an *option* on the
dbbackup command line.
I remember that discussion, it certainly confused me but it did not
convince me. A separate "touch" process cannot be trusted and is not
acceptable, it must be dbbackup that does it.
Not a week goes by when the lack of up-to-date backup file timestamps
doesn't REALLY BUG ME! (shouting intended :)
Breck The Impaler
On 29 Sep 2005 03:29:08 -0700, Volker Barth wrote:
>(This is the third attempt to submit this posting - please
>excuse me if the former attempts may also be visible...)
>
>Hi all,
>
>I just altered our backup procedure from using the BACKUP
>DATABASE statement to DBBACKUP.
>And then I stumbled over the fact that the backup .DB file
>had an old file timestamp and got worried for a while.
>
>Fortunately, I remembered the following thread in this
>newsgroup, which was started by Breck on Jan 13, 2005:
>"thread "dbbackup should "touch" backup database file".
>
>From this thread, with all its hints and explanations, the
>question remains:
>Can't DBBACKUP touch the dababase file?
>Or is this going to be changed in a future release/EBF?
>
>I'm using ASA 8.0.3.5251, so "DBBACKUP -s" is not available
>(if this would influence the file time, as it seems to use
>BACKUP DATABASE internally).
>
>TIA
>
>Volker
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|