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.
(Full) task is the focus of this chapter, it is not the only backup task available from the Maintenance Plan Wizard. ...