Backup and Restore


Get File Growth - Calculates and returns file growth data for all files in databases that are being backed up.

Get File Autogrowth Events - Retrieves a list of data file autogrowth events from the SQL Server default trace file(s).

Get Backup File Size History - Retrieves the file size history for all database files. Also performs some daily aggregation calculations to aid in space/bandwidth forecasting.

Backup all DBs with COPY_ONLY option - Creates and runs the commands to backup all databases using the COPY_ONLY option which does not upset any existing backup sequence.

Get all Database File Sizes - Retrieves the database size and associated file size on disk for each file of every database on a server.


Get Last Full Backup Date - Retrieves the last full backup for every database on a server. Extended version with TXLog and Differential backups and the ability to email out when they are overdue.

Get Latest DB Restore Details - Retrieves the last restore operation details for every DB on the server, including details of the source backup file and when the backup was taken.

Get Backup Compression Effectiveness - Retrieves backup compression percentage for all backup types for all databases on a server.

Cleanup Symantec Backup Exec 10d Job History - An emergency script to be used when the task cleanup has never been run and the one provided cannot cope.

How to: Transfer a large database across a slow WAN - Utilizes Red-Gate SQLBackup Pro (v6.2 +), with striped and encrypted backups.

Get restore progress - Retrieves restore progress and ETA for all DB restores currently running

Retrieve Default Backup Location - Retrieves Default backup location from the registry.

Get Database and Backup File Sizes - Retrieve database data and log sizes plus the last DB and log backup sizes for each DB on a server

Daily Backup Check - Retrieve a list of latest Data and Log backup dates and annotate those that are potentially overdue