| Author |
Question: dbbackup and BACKUP command conflicts ?
|
|
| handheldmaster 2005-12-14, 9:23 am |
| Reposting was not sure if it got to the newsgroup the first time.
Using asa902.3137 on windows3k
have full backup via dbbackup launched using task scheduler
have trans logs backup via BACKUP command inside sql db event
If dbbackup has not yet completed full backup .. and the translogs backup
command fires via sql db ... what will happen ? is this a bad thing ...
Today we are good but as db size increases think the dbbackup will take
longer than it does today.
| |
| Rob Waywell 2005-12-15, 9:23 am |
| I believe that the second backup process will block waiting for the first
backup to complete. What have you observed when you tested this?
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
"handheldmaster" <abc@456.com> wrote in message
news:43a01f46$1@foru
ms-2-dub...
> Reposting was not sure if it got to the newsgroup the first time.
>
> Using asa902.3137 on windows3k
>
> have full backup via dbbackup launched using task scheduler
> have trans logs backup via BACKUP command inside sql db event
>
> If dbbackup has not yet completed full backup .. and the translogs backup
> command fires via sql db ... what will happen ? is this a bad thing ...
>
> Today we are good but as db size increases think the dbbackup will take
> longer than it does today.
>
| |
| Breck Carter [TeamSybase] 2005-12-15, 9:23 am |
| On 15 Dec 2005 06:42:08 -0800, "Rob Waywell"
< rwaywell_no_spam_ple
ase@ianywhere.com> wrote:
>the second backup process will block
....and I believe the reason is, a backup does a checkpoint and then
suspends checkpointing, so the second backup will be unable to do its
checkpoint.
....which I hope will show up in the Jasper version of sa_locks :)
Breck
--
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
| |
| handheldmaster 2005-12-15, 1:23 pm |
| >I believe that the second backup process will block waiting for the first
>backup to complete. What have you observed when you tested this?
Not seen this happen yet but seen some close calls of one dbbackup just
finishing and the trans logs taking off about 2 mins later. Good to know
that it will just block till the first one completes ... as was hoping it
does not messup the offset #'s in the database log file making recovery from
full backup + rolling forward with translogs an issue.
|
|
|
|