Hi Phil,
This sounds good, but you say you have enclosed the scripts?
Did you really or did you accidently forget to enclose them?
Thanks
Christo
>Due to popular(!) demand, I have enclosed my scripts for automating the
>SQL and Exchange connect agent backups and deletions.
>
>***********
>***SQL***
>***********
>
>SQL backups are automated by a batch file (SQL_BACKUP.BAT) which is
>scheduled by ADSM Scheduler.
>
>Firstly, it uses the "sqldsmc /sqlquerydb" command to query all the SQL
>databases on the system and then uses a perl script (SQL_GET_DBS.PL) to
>put all the database names into a temporary file.
>
>Secondly, it uses the "sqldsmc /backupfull" command to backup each SQL
>database in the temporary file (this is in effect, the same as using the
>wildcard operator for SQL backups which some people were asking about).
>
>Thirdly, it issues a "sqldsmc /adsmquerydb" to get a list of all backed
>up databases.
>
>Fourthly, it runs another perl script (SQL_LIST_OLD_DBS.PL) to find all
>databases more than %window% days old and writes this out to another
>temporary file.
>
>Finally, it issues a "sqldsmc /adsmdelete" command for each database in
>this temporary file.
>
>
>
>
>
>
>
>********************
>***EXCHANGE***
>********************
>
>This is essentially the same as for SQL but without the perl script to
>generate a list of databases as there are only two, IS and DIR. The
>scheduled script is EXCHANGE_BACKUP.BAT.
>
>Firstly, this runs a utility to generate the current day of the week
>(GETDAY.EXE) which is a binary file someone here found on the Internet
>somewhere.
>
>Secondly, according to which day of the week it is, it will perform
>either a full or incremental backup of the Exchange databases.
>
>Thirdly, it issues a "excdsmc /adsmquerydb" to get a list of all backed
>up databases.
>
>Fourthly, it runs another perl script (EXC_LIST_OLD_DBS.PL) to find all
>databases more than %window% days old and writes this out to a temporary
>file.
>
>Finally, it issues a "excdsmc /adsmdelete" command for each database in
>this temporary file.
>
>
>
>
>
>
>
>Watch out for the next exciting episode in this series, coming soon when
>the Oracle Connect Agent is released for NT....
>
>Good luck.
>
>Phil
>
>Phil Chissell
>National Power plc
>Windmill Hill Business Park
>Whitehill Way
>Swindon
>Wilts. SN5 6PB
>UK
>
>Tel: +44 (0)1793 894237
>Fax: +44 (0)1793 894230
>E-mail: Phil.Chissell AT natpower DOT com
|
