How to setup weekly auto backup in SQL Server 2012?

Question

How can I set up an automated database backup in my SQL Server 2012?

I want of all the databases to take a backup (presently it has only 3) in the SQL server an automated weekly backup which goes on Each Friday at 01:00 h (1 AM).

These back up files (*.bak) must be placed in E:Backups folder.

Answer 1

In the Microsoft SQL Server Management Studio, open the Object Explorer and then:

Right-click on Management > Maintenance Plans

Click on New Maintenance Plan...

Give a name to your plan

Create as many sub-plans as you need for your strategy

Select a sub-plan and drag and drop the appropriate tasks from the Toolbox panel

To back up a database, the appropriate task is Back Up Database Task

For the configuration of the backup schedule, you simply have to follow the wizard and define what you need. 

If you want more information, I recommend you go on the official website of Microsoft: Create a Full Database Backup.

Looking for SQL Tutorial? Come and join the SQL training course to gain more knowledge on SQL.