Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQL Anywhere 5 Backup

2 posts in Backup and Recovery Last posting was on 2001-05-10 07:44:13.0Z
Quoc_Hien_Ha Posted on 2001-05-10 04:49:35.0Z
From: Quoc_Hien_Ha
Date: Thu, 10 May 2001 00:49:35 -0400
Newsgroups: sybase.public.sqlserver.backup+recovery
Subject: SQL Anywhere 5 Backup
Message-ID: <9F765F5F61FE2B4C001A831685256A48.001A833A85256A48@webforums>
Lines: 15
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:269
Article PK: 1060787

Hi All,

I would like to set up batch files (using dbbackup) and assign them to
WinNT Task Scheduler to do auto backup everyday.

But I am concerned about security because you have to specify the username
and password in the batch files for the connection parameters.

Is there any more secure way than this?

Thanks in advance.

Quoc Hien Ha
Melbourne
Australia


Justin Cole Posted on 2001-05-10 07:44:13.0Z
From: "Justin Cole" <justin.cole@daiwasbcm.co.uk>
References: <9F765F5F61FE2B4C001A831685256A48.001A833A85256A48@webforums>
Subject: Re: SQL Anywhere 5 Backup
Date: Thu, 10 May 2001 08:44:13 +0100
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <j4uaYfS2AHA.178@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
NNTP-Posting-Host: 212.119.2.113
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:268
Article PK: 1060789


<Quoc_Hien_Ha> wrote in message
news:9F765F5F61FE2B4C001A831685256A48.001A833A85256A48@webforums...
> Hi All,
>
> I would like to set up batch files (using dbbackup) and assign them to
> WinNT Task Scheduler to do auto backup everyday.
>
> But I am concerned about security because you have to specify the username
> and password in the batch files for the connection parameters.
>
> Is there any more secure way than this?

I did this by creating a 'password.cmd' script file which sets the password:

@set password=dbateam

And then you can apply NT security to that file. When you want to execute a
command (e.g. backup) do the following:

@echo off
call password.cmd
%SQLANY%\win32\dbbackup -c "uid=sa;pwd=%password%;dbn=mydb" ...
set password=

This is useful if you change the password as you only need to change it in
one place. Or the simplest method is to explicitly code it in the script
and apply appropriate file level security on a NTFS partition...

Justin.