SQLServerCentral.com Articles tagged Backups

Windows Server 2012 Deduplication – Should you use it with SQL Server Backups?

Fri, 08 Feb 2013 07:00:00 UT

Windows Server 2012 introduces native deduplication functionality. While this is a promising new Windows feature for other file types and characteristics, there are some potential pitfalls that you need to be aware of when it comes to deduplication specifically for SQL Server backup files.

Handling Backups for Rapid Resilience

Wed, 12 Dec 2012 07:00:00 UT

The backup and restore system in SQL Server hasn't changed a great deal over the years despite a huge growth in the typical size of databases. When disaster strikes, and an important service is taken offline while a restore is performed, there is often time to reflect on whether it might be possible to design databases for a more rapid recovery of the most critical parts of a database application.

What’s in YOUR Recovery Plan?

Mon, 10 Dec 2012 07:00:00 UT

Author Craig Outcalt gives advice on preparing for the worst with a look at what you should consider putting in your disaster recovery plan and why.

Handling Backups for Rapid Resilience

Wed, 12 Dec 2012 07:00:00 UT

The Importance of Validating Backups

Mon, 24 Sep 2012 06:00:00 UT

You may think that if your database has backed up without errors, that it's going to restore without errors. Think again, says Paul Randal.

How to Get Information About Your Backups

Tue, 03 Apr 2012 06:00:00 UT

When you need to restore but aren't 100% sure about the contents of your backup files, what do you do? Head to the headers. Grant Fritchey explains how to find the useful bits in these huge stores of information and make sure you restore the right files.

Quick and Dirty DR Solution Using Robocopy

Mon, 07 Nov 2011 07:00:00 UT

This article covers how to use robocopy with SQL Server Agent to copy database backup files to another server.

What’s in YOUR Recovery Plan?

Mon, 10 Dec 2012 07:00:00 UT

Author Craig Outcalt gives advice on preparing for the worst with a look at what you should consider putting in your disaster recovery plan and why.