Title
|
Description
|
Applicability
|
Get File Growth
|
Calulates and returns file growth data for all files in databases that are being backed up.
|
2000, 2005, 2008, 2008R2, 2012
|
Get File Autogrowth Events
|
Retrieves a list of data file autogrowth events from the SQL Server default trace file(s).
|
2000, 2005, 2008, 2008R2, 2012
|
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.
|
2000, 2005, 2008, 2008R2, 2012
|
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.
|
2000, 2005, 2008, 2008R2, 2012
|
Get all Database File Sizes
|
Retireves the database size and associated file size on disk for each file of every database on a server.
|
2000, 2005, 2008, 2008R2, 2012
|
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.
|
2000, 2005, 2008, 2008R2, 2012
|
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.
|
2000, 2005, 2008, 2008R2, 2012
|
Get Backup Compression Effectiveness
|
Retrieves backup compression percentage for all backup types for all databases on a server.
|
2000, 2005, 2008, 2008R2, 2012
|
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.
|
2000, 2005, 2008, 2008R2, 2012
|
How to: Transfer a large database across a slow WAN
|
Utilizes Red-Gate SQLBakup Pro (v6.2 +), with striped and encrypted backups.
|
2000, 2005, 2008, 2008R2, 2012
|
Get restore progress
|
Retrieves restore progress and ETA for all DB restores currently running
|
2000, 2005, 2008, 2008R2, 2012
|
Retrieve Default Backup Location
|
Retrieves Default backup location from the registry.
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
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
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
Daily Backup Check
|
Retrieve a list of latest Data and Log backup dates and annotate those that are potentially overdue
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|