When creating a backup that will be restored to a development database, you may need to mask PII information. This script will help you with that.  Read more...

Restore Many Backup FIles  Read more...

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...

Thursday, May 26, 2011 5:00 PM - 6:00 PM BST. Steve Jones will be your host to introduce Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate Software. This webinar will take you through the best practices, standards and methods that you can employ to ensure that you have solid backup processes for the databases under your charge. You’ll also learn how to restore, because your backups are only good if you can restore them. Grant will show you how using Red Gate’s SQL Backup Pro and SQL Virtual Restore can make all this easier and more efficient.   Read more...

Thursday, May 26, 2011 5:00 PM - 6:00 PM BST. Steve Jones will be your host to introduce Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate Software. This webinar will take you through the best practices, standards and methods that you can employ to ensure that you have solid backup processes for the databases under your charge. You’ll also learn how to restore, because your backups are only good if you can restore them. Grant will show you how using Red Gate’s SQL Backup Pro and SQL Virtual Restore can make all this easier and more efficient.   Read more...

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

Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups  Read more...

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

One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user and system databases. In this article we will take a look at the steps which a database administrator needs to follow to backup and restore an analysis services database.   Read more...

The script will be helpful to kill all the user sessions before performing the refresh of the database.  Read more...

Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...  Read more...

Read more...

Read more...

We have recently found an elegant way to reduce the time, and disk space required for SharePoint administrators who need to perform granular recovery operations out of their SQL Server backup files. I used to get customer calls that would go something like this:  Read more...

Read more...

Dynanically Generate Backups with Date and time  Read more...

As a DBA you always followed a practice to back up your database (or take a snapshot of your database) before making any changes so that you can revert to your old database state if something goes wrong. Also to setup a development or test environment you use a backup of your database and restore it in the respective environment. If you are moving to SQL Azure, what would you do in these cases as backup / restore and database snapshots are not supported as of now?  Read more...

In the early days of SQL Server you could not run a log backup while a full backup was running....  Read more...

The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore  Read more...

Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.  Read more...