Backup database on SQL Server 2008 R2 using Maintenance Plans

http://www.sqlserver2008tutorial.com

In this MS SQL Tutorial, we show you how to do SQL Server 2008 R2 database backup using SQL maintenance plans. This is an easy way for you to do Administration things like Backing up database, Updating statistics and other SQL Server DBA tasks. We show you How to use the Maintenance Plan Wizard, we create new Full database backup on MS SQL 2008. We also show you how to select the backup file location, create output log file with history on the backup process and a daily schedule that is run by the SQL Server Agent. Using the Maintenance Plan Wizard, SQL server Administration tasks are made quite easy and pretty easy to follow. We also go over the events and historical view of an existing SQL Job.