Cool Tips‎ > ‎

Backup and Restore

 

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

 

 

Utilises Red-Gate SQLBakup Pro (v6.2 +), with striped and encrypted backups.

 

 

2000, 2005, 2008, 2008R22012

 

Get restore progress

 Retrieves restore progress and ETA for all DB restores currently running

 

2000, 2005, 2008, 2008R2, 2012

 

 

 

 

 

 

Comments