SQL DB Backup

[BillNewB]

Hello All,

I'm totally new to AutoIT, and I've tried to make this function work somehow, with AutoIT. This is what I've used in a dos batch file, but want to create an AutoIT script. Any help would be appreciated.

set BACKUPFILENAME1=c:\ck\dbbackups\ServerTT.bak

sqlcmd -S localhost -U sa -P ?????? -d tora -Q "BACKUP DATABASE test TO DISK = N'%BACKUPFILENAME1%' WITH INIT , NOUNLOAD , NAME = 'test_backup', NOSKIP , STATS = 10, NOFORMAT"
 

[Floops]

This should work

 

$BACKUPFILENAME1 = "c:\ck\dbbackups\ServerTT.bak"

Run(@ComSpec & ' /c ' & "sqlcmd -S localhost -U sa -P ?????? -d tora -Q 'BACKUP DATABASE test TO DISK = N'" & $BACKUPFILENAME1 & "' WITH INIT , NOUNLOAD , NAME = 'test_backup', NOSKIP , STATS = 10, NOFORMAT'"

 

[BillNewB]

Floops,

 

Thanks for the reply. I was getting errors at first, but I added a ) at the end, and now I get no errors, but the backup doesn't work.

[rootx]

#RequireAdmin

$BACKUPFILENAME1 = "c:\ck\dbbackups\ServerTT.bak"

Run(@ComSpec & ' /c ' & "sqlcmd -S localhost -U sa -P ?????? -d tora -Q 'BACKUP DATABASE test TO DISK = N'" & $BACKUPFILENAME1 & "' WITH INIT , NOUNLOAD , NAME = 'test_backup', NOSKIP , STATS = 10, NOFORMAT'",@ScriptDir,@SW_SHOW)

 

[BillNewB]

rootx,

 

Thanks for the reply, but I still can't get it to work. No errors, but no backup either.