Byakko

The other reason that I wanted to use a script is that I want to generate the file name on the fly so that it contains the current date with the following format: Database_tlog_yyyymmdd.exe ie. Database_tlog_20050419.exe Forgot this when I replied to your recomendation to use a batch. Regards, Terry

Yeah, that was what I was originally thinking of, but I want to move teh files out of the directory as well so that they are not grabbed by the process on the next day. I will be leaving the country for a bit for training and can't guarantee that I'll be able to login to the server daily and wanted to automate the process untill I return. The other alternative is to do up a console app in Delphi to do this for me, just figured that a script will be less resource intensive. Regardless, thanks for the input. Regards, Terry

Hi, What I am hoping to do is to create a script that will run every morning to compress SQL transaction logs from the day before and move them to another location for off loading. Personal History: - I am new to scripting - language wise I have experience with Delphi / C++ / a little VB Environment & Apps: - Win 2003 Server Standard - WinRar 3.3x - SQL 2000 Standard My questions are this: 1. VBS or JScript? I understand JScript is newer but is it worth using it over VBS? 2. How to call rar.exe from the script. I'm assuming that once I know this, passing paramaters with the execute command will be a snap. 3. I am assuming that I can setup a script as a scheduled task for the purpose of running it daily. If there is another post/resource which will cover this, please point me in the right direction. I tookk a brief search through the forums and on the net, but have come up empty handed thus far. Thanks in advance for any assistance you can offer. Regards, Terry