Backup and Restore Tables

Truncating the log

Script to check that backup files still exist for SQL Server

You have configured your database backup jobs without any problems. The backups themselves seem to be working, but are the files still where you think they are? How do you know they have not been moved, or worse, deleted to free up some space on your server? And when would you find out that the files were no longer there?

Backup Both Full and TLog Database Backup within a single Job

This script is basically used in SQL Server 2005/2008 as that version not having the option to perform the same activity in the single window.

Restore Database from network location

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

Copy Only Backup for SQL 2005 and SQL 2008

Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?

Script to find latest backups for all databases

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.

Use Backup/Restore to Minimize Upgrade Downtimes

Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.

Backup Monitoring and Reporting

Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.

How to find out how long a SQL Server backup took

Many shops do full backups of their databases as part of a job within SQL Agent, typically as part of a maintenance plan. This job will often times do all database backups in secession. As such, while you may know how long the job takes, you may not know how long any one particular database takes to have a full backup taken.