Backup MSSQL Database on Windows Dedicated Server

It is necessary to take Database regularly. You never know when Server face some problem, So it is necessary to take backup on your dedicated Windows Server. You can schedule the MSSQL Database to generate backup files from the below link :-

1. Start Management Studio. Expand Databases. 
2. Right Click on the data to be backup and Select “All Tasks” 
3. Then Select “Backup Database”.
4. SQL is configured to Select “Database - Complete” by Default.
5. If you do not want to do this you can select “Database - Differential”.
6. Generally, the Destination chosen by many users to save the SQL Backup file is “C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP”.
7. Now, Double Click on the given default path and add “sqlbackup.bak” to the Existing Path.
8. Then Click OK.
9. Now, to Schedule backups select the “Schedule” option.
10. Once done, Click “…” option.
11. Now you will find a Recurring option i.e. Radio option. Click the option and Select “Change” option right after you do that.
12. Select the Time on which you would like to have the backup with the Schedule of the Backup. You will have to enter the Time on which you would like to have the Backup Directory Created and also specificy if you wish to have the Backup Directory Created Daily, Weekly or Monthly.
13. Now click “OK” on Each Dialogue box and proceed.
14. You can also check if the Backup time and the Backups to be taken are Scheduled Successfully through “C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP” Directory.
15. Now, In the Remote Data Backups only Select the SQL Backup Directory and you are done.