How to setup weekly auto backup in SQL Server 2012?

Question

Please advice how can i setup automated database backup in my SQL Server 2012.

I need to take all databases (currently it contains only 3 ) in SQL server an automated weekly backup which runs on Every Friday at 0100 h (1 AM). These back up files (*.bak) should be placed in E:\Backups folder.

Answer 1

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

1. Right-clic on Management > Maintenance Plans
2. Clic on New Maintenance Plan...
3. Give a name to your plan
4. Create as many subplans as you need for your strategy
5. Select a subplan and drag'n'drop the appropriate tasks from the Toolbox panel
6. To backup a database, the appropriate task is Back Up Database Task

For the configuration of the backup schedule, you just need to follow the wizard and define what you want. If you need more information, i suggest you to go on the official website of Microsoft: Create a Full Database Backup

Hope this will help you

Answer 2

Check this opensource backup windows service MFSQLBackupService, it did a great job for me.