O'Reilly logo

SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Backing Up a Database

Data loss to business is unacceptable. A copy of the most recent data should always be available. A backup copy of data is therefore indispensable for restoring the database, if for some reason the production data becomes unavailable due to media problems, hardware failures, etc. While backup activity is always paired with restore activity, SSIS has only the backup task. The backup activity requires a lot of planning as to how frequently the data has to be backed-up, what is to be backed-up, data or data files; what type of media will be used for keeping the backup, what type of backup is needed, etc. The Back Up Database Task takes these into consideration, as will be seen in the hands-on exercise.

In this chapter, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required