ActiveX Scripts

- taken from DTS packages but most will also work with the Windows Scripting Host provided the expected DTS global variables and constants are modified to be script parameters or removed as necessary.

Copy procedures from Database A to Database B AxtiveX Script Task
Free Space Monitoring Tool ActiveX Script Task
SQLDMO Script DDL AcitveX Script Task
Check in Scripts Generated by SQLDMO Task into SourceSafe ActiveX Script Task

(Note that these backup scripts here generally support both native and SQL LiteSpeed backups)
Backup a Server
Backup Primary Restore Warm spare (SQLLitespeed or native) ActiveX Script task - a monolithic DTS based backup/restore utility
Backup Driver - the driver for a flexible and highly customizable metadata driven DTS backup solution

    Examples of called packages used by Backup Driver

Archive a Backup Device - In this backup archive strategy, the file system backups to tape does the delete of a file once it is moved to tape. The database backup processing simply renames with a numeric file extension any existing backup file if it is found on disk.
• Backup a Database
• Differential Backup of a Database
• Log Backup of a Database
• Restore a Database
• Restore of a Database With Move
• Log Restore of a Database

    These are jobs built with the DTS Package Builder UI rather than ActiveX DTS tasks
    Presented here as DTS Packages "Save(d) As..." VB Scripts.

• Expunge Users from a Database - not an ActiveX script, but the .bas of a DTS package that uses a Dynamic Properties Task and a SQL Task to call the procedure admin.dbo.ExpungeUsers. Very useful when restoring a database.
• Backup History Delete Archive - not an ActiveX script, but the .bas of a DTS package that uses a Dynamic Properties Task and a SQL Task to call the system procedure msdb.dbo.sp_delete_backuphistory.