O'Reilly logo

Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

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

Chapter 12. Back Up Database (Full) Task

The basic purpose of a backup of a SQL Server database is to make a copy of the data so that it can be used to restore a database in the event of a disaster, such as system failure, damage to the database, corruption of the data it contains, and so on.

Of all the Maintenance Plan tasks that you need to perform, this is the most important. It is critical that you make full backups of your production databases on a regular basis, preferably once a day. A full backup can be performed on any database in SQL Server (except for tempdb), no matter what recovery model it uses.

While the Backup Database (Full) task is the focus of this chapter, it is not the only backup task available from the Maintenance Plan Wizard. ...

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