Step by step automatic database backup using SQL Server

I would share you information about step by step database backup automaticly using SQL Server :

1. Open SQL Server Enterprice manager
2. Click name of your database (ex : localhost)
3. Click Managament
4. Right click on Database Maintenance Plans. Then choose New Maintenance Plans Menu
5. It will appear new window-form wizard. Follow the instruction then click Next
6. Choose the database which will be backup then click NEXT
7. After Update Data Optimazation Information form appeared (there is nothing to do at this form). You just click NEXT
8. After Database Integrity Check form appeared (there is nothing to do at this form). You just click NEXT
9. After Specify Database Backup Plans form appeared, click CHANGE to arrange schedule of backup process then click NEXT.
10 After Specify Backup Disk Directory form appeared, Specify the directory in wich to store the backup file. then click NEXT.
11. After SpecifyThe Transaktion Log Backup Plans form appeared, check Back up the transaction log as part of maintenance plan if you want to make log , if you dont, ignore this instruction then click NEXT.
13. After that follow the instruction on the form until Completing the Database Maintenance Plan Wizard form appeared then input name of Plan: then Click Finish

NB : you have to switch off SQL Server Agent service before

0 comments: