;*************************************************************************
;  Script Name:     SQL Database Backup
;  Author:          Antonio Santiago
;  Date:            18-Dec-03
;  Descritption:    This script will make backups of the Delta V SQL databases 
;                   and compress them for easy storage.
;*************************************************************************
 
;Declaring Variables

GLOBAL $DATABASE

DIM $SQLMAINT, $SERVER, $USERNAME, $PASSWORD,  $BACKUPDIR, $BACKUPMEDIA
DIM $EXPORT, $WINRAR


;Defining Variables

$SQLMAINT="d:\mssql2k\mssql\binn\sqlmaint.exe"
$SERVER="localhost"
$USERNAME="sa"
$PASSWORD=""
$BACKUPDIR="e:\DeltaV_Backup"
$BACKUPMEDIA="DISK"


;Verify that script is executed on the $PROPLUS
:PROPLUS
IF @WKSTA=$PROPLUS or @WKSTA=$HISTORIAN 
GOTO DIRECTORY
ELSE
MESSAGEBOX("Sorry, this script can only be executed in the PROPLUS or HISTORIAN computer.","Script Error!!!",16,0)
goto End
ENDIF 


:DIRECTORY
;Making Backup Folder

MD $BACKUPDIR 


;Exporting Database 

$EXPORT=$SQLMAINT+" -S "+$SERVER+" -U "+$USERNAME+" -P "+$PASSWORD+" -D "+$DATABASE+" -BkUpDB "+$BACKUPDIR+" -BkUpMedia "+$BACKUPMEDIA

SHELL "%COMSPEC% /C "+$EXPORT


;Compresing Database - Winrar (www.rarlabs.com) required
; -m5 = High Compresion
; -df = Delete files after archiving
; -ibck = run in the background
; -r = recurse subfolders
; -x = Exclude files

$WINRAR="c:\progra~1\winrar\winrar a -m5 -r -df -ibck -x*.zip"

SHELL "%COMSPEC% /C "+$WINRAR+" "+$BACKUPDIR+"\"+$DATABASE+"_"+@MDAYNO+@MONTH+@YEAR+".zip"+" "+$BACKUPDIR+"\*.bak"


:END
;END OF SCRIPT
  

Quote:

---

Never, ever use GOTOs in scripts.

An 'sa' admin account with empty password is a huge security risk!

Why not run the backups directly from within SQL Server Enterprise Manager as a scheduled maintenance task?

---

I used the GOTO command to filter by wksta but the condition can be eliminated.

And YES the 'SA' has a password(it's not typed in)

I didn't use the enterprise manager to do the backups because it's only a part of a multilevel script, and at the end it compresses the database using winrar (just saving some tape space).


Thanks for the advice...