Connecting Tech Pros Worldwide Forums | Help | Site Map

need help with a smal script

Newbie
 
Join Date: Apr 2007
Posts: 1
#1: Apr 20 '07
Hello,

I run a simple backup on my BES Server to do a backup everyday. The commands I run are as follows:

C:\>osql -E
1> backup database besmgmt1 to disk = "c:\besdbapr19.bak"
2>go
Processed 3112 pages for database 'besmgmt1', file 'BESMgmt1_data' on file 1.
Processed 1 pages for database 'besmgmt1', file 'BESMgmt1_log' on file 1.
BACKUP DATABASE successfully processed 3113 pages in 3.222 seconds (7.913
MB/sec).

Is there a way to script this? I am fairly new to this so some handholding would be required Basically, the script should be smart enough to change file names as well.

Any help would be appreciated.

Thanks....

RedSon's Avatar
Site Moderator
 
Join Date: Jan 2007
Location: America
Posts: 3,393
#2: Apr 20 '07

re: need help with a smal script


You could write it into a bat file and put it as a task which is Microsoft's version of a cronjob. Or you could try python since that is a pretty popular scripting language. It is capable of much more but its easy to learn.
Reply


Similar Software Development bytes