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...

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...

Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...  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...

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...

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...

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...

Learn how to write a script for regular database backups using Powershell and SMO.  Read more...

Today we have an editorial reprinted from April 27, 2005. Steve Jones is on vacation, so we are reprinting this look at backup strategies and media.  Read more...

How to set the default locations for backups, data files, and log files in SQL Server.  Read more...

Learn how to restore a LiteSpeed backup on a server without the software in 2 Simple Steps.  Read more...

A new article that shows how you can automate a basic function that many environments need: the backup of a production database and the restore on a development system.  Read more...

Today Steve Jones looks at the new release of restore technology from Red Gate software that allows you to "fool" SQL Server.  Read more...

When is backup not enough? Steve Jones talks about a few things that can cause you issues and a backup can't help you recover from.  Read more...

Steve Jones talks about the loss of data, and how it can impact your life. And why you want to be sure that your restores are ready in the event of a disaster.  Read more...

The need to archive data is becoming more and more important as data sizes grow. However when you choose to archive data, you might need to reconsider how your DR plan is structured.  Read more...

A DBA's huge workload can start to threaten best practices for data backup and recovery, but ingenuity, and an eye for a good tactic, can usually find a way. For Tom, the revelation about a solution came from eating crabs. Statistical sampling can be brought to bear to minimize the risk of failure of an emergency database restore.   Read more...