SQL Anywhere database - Backup db from Network Server to Client

Author

Backup db from Network Server to Client

Bob Munro

2005-04-06, 8:02 pm

We recently upgraded from ASA 7.0.2.1462 to ASA 9. Previously, users

were able to back up the database and log files that are located on our

network servers to a local client machine (from that client machine).

However, we seem to have lost that capability in ASA9. I am no longer

allowed to browse to any local drives when I'm in the backup utility and

when I manually enter a local directory and click finish to start the

backup, the database and log do not get copied to that specified local

drive. The note under the directory window states that "this file name

is relative to the server computer" but we were always able to backup to

a client machine in previous versions of ASA.. Is there still a way to

do this in ASA9? (we've tried the Creat Backup Images utility)

Nick Elson

2005-04-07, 8:02 pm

Does this sound like your problem?

========(Release Build - Engineering Case #355516)=========
When being asked for the name of a new file in the utility wizards (for
example, the Create Database wizard), clicking the "Browse..." button
and choosing an existing file in the file dialog, would have caused
a prompt asking to replace the file. This was erroneous, since once
returning to the wizard and clicking Next, a "You must specify a new
file" error message would have been displayed. This has been fixed.
Now, the file dialog no longer asks to replace the file when a new file
is required.
====================
====================
======-

If so you will need to go to either 9.0.2 or 9.0.1 and some ebf higher
than 1865 (ie any currently available one).

"Bob Munro" <bob.munro@orps.state.ny.us> wrote in message news:425429c5$1@foru
ms-1-dub...
> We recently upgraded from ASA 7.0.2.1462 to ASA 9. Previously, users
> were able to back up the database and log files that are located on our
> network servers to a local client machine (from that client machine).
> However, we seem to have lost that capability in ASA9. I am no longer
> allowed to browse to any local drives when I'm in the backup utility and
> when I manually enter a local directory and click finish to start the
> backup, the database and log do not get copied to that specified local
> drive. The note under the directory window states that "this file name
> is relative to the server computer" but we were always able to backup to
> a client machine in previous versions of ASA.. Is there still a way to
> do this in ASA9? (we've tried the Creat Backup Images utility)
>

anonymous

2005-04-08, 7:01 am

Hi,

We also have the same problem. This option was available in earlier releases
but in ASA 8+ not available.

"Bob Munro" <bob.munro@orps.state.ny.us> wrote in message
news:425429c5$1@foru
ms-1-dub...
> We recently upgraded from ASA 7.0.2.1462 to ASA 9. Previously, users
>
> were able to back up the database and log files that are located on our
>
> network servers to a local client machine (from that client machine).
>
> However, we seem to have lost that capability in ASA9. I am no longer
>
> allowed to browse to any local drives when I'm in the backup utility and
>
> when I manually enter a local directory and click finish to start the
>
> backup, the database and log do not get copied to that specified local
>
> drive. The note under the directory window states that "this file name
>
> is relative to the server computer" but we were always able to backup to
>
> a client machine in previous versions of ASA.. Is there still a way to
>
> do this in ASA9? (we've tried the Creat Backup Images utility)
>
>

Nick Elson

2005-04-09, 8:24 pm

The option should still be there. See my other posting about a probable
bug fix for this.

If that is not your solution, then post more details about the exact version
and nature of the problem you are seeing.

"anonymous" <yadav.vk@mellonhris.com.sg> wrote in message
news:4255fe45@forums
-2-dub...
> Hi,
>
> We also have the same problem. This option was available in earlier
> releases
> but in ASA 8+ not available.
>
>
> "Bob Munro" <bob.munro@orps.state.ny.us> wrote in message
> news:425429c5$1@foru
ms-1-dub...
>
>

2005-04-14, 3:23 am

We also have the same problem. This option was available in earlier releases
but in ASA 8+ not available.
>
> "Bob Munro" <bob.munro@orps.state.ny.us> wrote in message
> news:425429c5$1@foru
ms-1-dub...
>
>

Bob Munro

2005-04-15, 9:23 am

No Nick, this is not the problem we're talking about. We are currently on
ASA version 9.0.2.2451. The problem occurs when we try to back up a database
that resides on our network server to a directory on a client pc by using
the "create backup images" utility from that client machine. When we reach
the screen in which we're prompted to specify the directory where we want to
save the backup images, we are unable to browse to the desired directory on
the client machine (browse button is grayed out). We can manually type in
the directory (e.g. C:\Backup) to get beyond that screen (BUT it seems that
we should still be able to browse to it as in previous versions). Then,
after the backup process appears to successfully finish, the database does
not appear in the specified client directory (C:\Backup). This client backup
was always available in previous versions of ASA (7 and earlier) and is
something that we need to do often in our office. Thanks for any help you
can provide.

"Nick Elson" < no_spam_nicelson@syb
ase.com> wrote in message
news:4256c08d$1@foru
ms-2-dub...
> The option should still be there. See my other posting about a probable
> bug fix for this.
>
> If that is not your solution, then post more details about the exact
version
> and nature of the problem you are seeing.
>
> "anonymous" <yadav.vk@mellonhris.com.sg> wrote in message
> news:4255fe45@forums
-2-dub...
and[color=darkred]
to[color=darkred]
>
>

Bob Munro

2005-04-15, 9:23 am

Reg Domaratzki $iAnywhere Solutions$

2005-04-15, 9:23 am

You'll need to use the dbbackup command line utility to do this. dbbackup
will place the backup on the client machine when you connect to a network
server.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Bob Munro" <bob.munro@orps.state.ny.us> wrote in message
news:425fc960@forums
-2-dub...
> No Nick, this is not the problem we're talking about. We are currently on
> ASA version 9.0.2.2451. The problem occurs when we try to back up a
database
> that resides on our network server to a directory on a client pc by using
> the "create backup images" utility from that client machine. When we reach
> the screen in which we're prompted to specify the directory where we want
to
> save the backup images, we are unable to browse to the desired directory
on
> the client machine (browse button is grayed out). We can manually type in
> the directory (e.g. C:\Backup) to get beyond that screen (BUT it seems
that
> we should still be able to browse to it as in previous versions). Then,
> after the backup process appears to successfully finish, the database does
> not appear in the specified client directory (C:\Backup). This client
backup
> was always available in previous versions of ASA (7 and earlier) and is
> something that we need to do often in our office. Thanks for any help you
> can provide.
>
> "Nick Elson" < no_spam_nicelson@syb
ase.com> wrote in message
> news:4256c08d$1@foru
ms-2-dub...
probable[color=darkr
ed]
> version
our[color=darkred]
> and
local[color=darkred]

name[color=darkred]
> to
to[color=darkred]
>
>

Bob Munro

2005-04-18, 7:23 am

Thanks Reg. We knew that we could use the dbbackup command line option but
alot of our users have become accustomed to using the backup through Sybase
Central and are asking why that option has been taken away. Do you know
why this change was made?

"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:425fcd26@forums
-2-dub...
> You'll need to use the dbbackup command line utility to do this. dbbackup
> will place the backup on the client machine when you connect to a network
> server.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "Bob Munro" <bob.munro@orps.state.ny.us> wrote in message
> news:425fc960@forums
-2-dub...
on[color=darkred]
> database
using[color=darkred]

reach[color=darkred]

want[color=darkred]
> to
> on
in[color=darkred]
> that
does[color=darkred]
> backup
you[color=darkred]
> probable
users[color=darkred]

> our
machine).[color=darkred]
longer[color=darkred
]
utility[color=darkre
d]
the[color=darkred]
> local
> name
backup[color=darkred
]
> to
>
>

Bob Munro

2005-04-18, 9:23 am

Thanks Reg. We knew that we could use the dbbackup command line option but
many of our users have gotten accustomed to backing up network databases to
their clients through Sybase Central and are wondering why the option was
taken away. Do you know the answer Reg?
"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:425fcd26@forums
-2-dub...
> You'll need to use the dbbackup command line utility to do this. dbbackup
> will place the backup on the client machine when you connect to a network
> server.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "Bob Munro" <bob.munro@orps.state.ny.us> wrote in message
> news:425fc960@forums
-2-dub...
on[color=darkred]
> database
using[color=darkred]

reach[color=darkred]

want[color=darkred]
> to
> on
in[color=darkred]
> that
does[color=darkred]
> backup
you[color=darkred]
> probable
users[color=darkred]

> our
machine).[color=darkred]
longer[color=darkred
]
utility[color=darkre
d]
the[color=darkred]
> local
> name
backup[color=darkred
]
> to
>
>

Sponsored Links