Scheduling Auto Backup in SQL Server 2012

1. Open SSMS and connect to SQL Authentication

SQL-Server-2012-Scheduling-Auto-Backup-1.jpg

2. Open Management Tab then Maintenance plan ,new maintenance plan

SQL-Server-2012-Scheduling-Auto-Backup-2.jpg

3. Create new maintenance plan, then give name to it.

SQL-Server-2012-Scheduling-Auto-Backup-3.jpg

4. New maintenance plan has been created like this.

SQL-Server-2012-Scheduling-Auto-Backup-4.jpg

5. Open the Tool box ,select Backup database task.

SQL-Server-2012-Scheduling-Auto-Backup-5.jpg

6. After create Backup database task doubleclick the box backup database task.

SQL-Server-2012-Scheduling-Auto-Backup-6.jpg

7. Backup types on the window like this.

SQL-Server-2012-Scheduling-Auto-Backup-7.jpg

8. Next is Database selection all DB's or Single DB

SQL-Server-2012-Scheduling-Auto-Backup-8.jpg

9. Choosen the Backup type disk or tape then Designation

SQL-Server-2012-Scheduling-Auto-Backup-9.jpg

10. Select the backup format like bak, etc…

SQL-Server-2012-Scheduling-Auto-Backup-10.jpg

11. Verify backup Integrity to user defined mode

SQL-Server-2012-Scheduling-Auto-Backup-11.jpg

12. After completing all steps. Go to toolbox select the Cleanup box.

SQL-Server-2012-Scheduling-Auto-Backup-12.jpg

13. So Double click the Maintenance cleanup task

SQL-Server-2012-Scheduling-Auto-Backup-13.jpg

14. Choose new for the new connection as same as sql authentication

SQL-Server-2012-Scheduling-Auto-Backup-14.jpg

15. Type the backup type then backup expire date then ok ,tats all.

SQL-Server-2012-Scheduling-Auto-Backup-4.jpg

Ebook Download
View all
Learn
View all