Enterprise wide Backup Audit that produces backup information in a csv format.  Read more...

There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.   Read more...

This script provides very useful information about database backup and restoration.  Read more...

A handy script for DBAs to find the last healthy backup of a database.  Read more...

When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.  Read more...

If you are not the only one who takes care of the backups, knowing the backups taken recently is very crucial for a production DBA.  Read more...

We discovered a need to compress our backups so that we could copy the files over the network to the DR location (log shipping), to save on transfer time during emergency restores.   Read more...

A hopefully useful script to delete old files, not just backups, and make use of the archive bit.  Read more...

Save the transaction log and truncate the file to prevent Tlogs FULL Error  Read more...

I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.  Read more...

Script to found out how much time before Restore or Backup Process remain  Read more...

Backup all DBs of a SQL-Server Instance depending on Environment Variable "DBBackupPath". The script also distinguishes between Instances  Read more...

This query gives you an idea of the growth of your database over time.  Read more...

These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.  Read more...

Make backup several databases with a cursor  Read more...

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...

Script to backup 2000/2005 databases.  Read more...