SQLServerCentral.com Articles tagged Backup / Restore

Powershell Database Backup Script

Fri, 17 May 2013 06:00:00 UT

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

Free eBook: SQL Server Backup and Restore

Fri, 25 Jan 2013 07:00:00 UT

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.

Free eBook: SQL Server Backup and Restore

Fri, 25 Jan 2013 07:00:00 UT

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Disaster In The Real World - #2

Fri, 14 Dec 2012 07:00:00 UT

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.

SQL Server Backup Questions We Were Too Shy to Ask

Tue, 11 Dec 2012 07:00:00 UT

During presentations about doing database backups and restores, there seem to be two two types of questions that are commonly asked, Those that come from the floor during the presentation, and those that are asked in private afterwards. These are sometimes more interesting, and challenging to answer well.

Free eBook: SQL Server Backup and Restore

Fri, 25 Jan 2013 07:00:00 UT

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.

Simplified Restores with SQL Server 2012 Recovery Advisor

Wed, 27 Jun 2012 06:00:00 UT

Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.

Instant File Initialization and restores

Mon, 21 May 2012 06:00:00 UT

Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.

Partial Backup and Restore

Tue, 15 May 2012 06:00:00 UT

Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup.

Replace existing Database? JFDI!

Mon, 02 Apr 2012 06:00:00 UT

Tony Davis argues that the WITH REPLACE option of the RESTORE DATABASE command is a case where the naming of the option masks its true "JFDI" nature…

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

How to create a database backup using visual studio

Fri, 30 Mar 2012 06:00:00 UT

This article describes how to backup a database using a C# Windows Form.

Backing Up a SQL Server Database Directly Onto a Remote Server

Thu, 22 Dec 2011 07:00:00 UT

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

Automating Daily Checks with Powershell

Mon, 19 Dec 2011 07:00:00 UT

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

Automatically Scripting Out Permissions for Cross Environment Restores

Mon, 05 Dec 2011 07:00:00 UT

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

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Initialize SQL Server replication using a database backup

Thu, 08 Sep 2011 06:00:00 UT

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.

SQL Server Restore Tutorial

Fri, 19 Aug 2011 06:00:00 UT

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.

Backup to multiple files for faster and smaller SQL Server backup files

Fri, 29 Jul 2011 06:00:00 UT

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.

SQL Server Database Backup and Restore Failure Notifications

Fri, 22 Jul 2011 06:00:00 UT

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.

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

Mon, 30 May 2011 06:00:00 UT

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

SQL Server Central Webinar Series #10: SQL Server Backup and Restore for the Accidental DBA

Thu, 26 May 2011 06:00:00 UT

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.

SQL Server Central Webinar Series #10: SQL Server Backup and Restore for the Accidental DBA

Thu, 26 May 2011 06:00:00 UT

Backup and Restore of an Analysis Services Database

Mon, 25 Apr 2011 06:00:00 UT

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.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Change SQL Startup Parameters with PowerShell

Tue, 05 Apr 2011 06:00:00 UT

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

Streamlining granular recovery for SharePoint, with Red Gate and Metalogix

Wed, 23 Feb 2011 07:00:00 UT

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:

SQL Azure - Creating backups and copies of your databases

Thu, 10 Feb 2011 07:00:00 UT

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?

A Full Backup can Impact a Log Backup–MCM Prep

Mon, 07 Feb 2011 07:00:00 UT

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

SQL Server Central Webinar Series #8: Creating smaller and comprehensively verified backups

Thu, 27 Jan 2011 07:00:00 UT

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

Backup and Housekeeping with Maintenance Plans

Wed, 26 Jan 2011 07:00:00 UT

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

SQL Server Central Webinar Series #8: Creating smaller and comprehensively verified backups

Thu, 27 Jan 2011 07:00:00 UT

SQL Server Central Webinar Series #8: Creating smaller and comprehensively verified backups

Thu, 27 Jan 2011 07:00:00 UT