Read more...

4 out of 5 DBAs agree I’ve covered creating my backup directories and the actual backup of the database(s). The last...  Read more...

I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...  Read more...

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

Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging server using RoboCopy  Read more...

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...

This script will generate a restore statement with supporting MOVE operations to a new directory structure.  Read more...

This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.  Read more...

Read more...

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

You need to configure transactional replication for a very large SQL Server database. Instead of running the snapshot agent to initialize the subscriber, in this tip we look at how you can initialize the subscriber from a SQL Server backup.  Read more...

What good is a backup if you do not know to restore the backup? In this tutorial you will look at what restore options are available and which options are only accessible using T-SQL commands.  Read more...

Finds the last full backup file stored in a given folder.  Read more...

Read more...

Write your database backup to multiple files. In addition to writing your database backup to one file you have the ability to write to multiple files at the same time and therefore split up the workload. The advantage to doing this is that the backup process can run using multiple threads and therefore finish faster as well as having much smaller files that can be moved across the network or copied to a CD or DVD.  Read more...

SQL Server ships with native alerts that can be configured to notify an operator when a backup or restore failure occurs. This chart shows the SQL Server 2000 backup and restore alerts.  Read more...

This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore.  Read more...

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

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...

A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.   Read more...