SAP SQL Anywhere

Question

Hi all

I am trying to create a batch file that will create a folder of todays date, then backup the db file to that folder, something along the lines of..

setlocal enableextensions
set name=%DATE:/=_%
mkdir %name%
dbbackup -c "uid=DBA;pwd=SQL;dbn=BrewMasterWorld" %name%

Appreciate any guidance on this

Thanks

C

Answer 1

1

IMHO that looks ok, but you might want to add the eng={enginename} parameter to the connection string.

Another approach would use an SQL statement for that purpose:

 
create variable @path varchar(127);
set @path= String('C:\Backup\',dateformat(today(),'mm_dd_yyyy'));
backup database directory @path

This could be executed as a batch with ISQL.

permanent link

answered 01 Jun '16, 05:04

Reimer Pods
4.5k●38●48●91
accept rate: 11%

flat view

SAP SQL Anywhere

Client Side Backup

Follow this question

Related questions