Search

Saturday, March 3, 2012

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.

4 comments:

  1. Presently I work for Dell and I think your blog on windows dedicated server is quite useful. It will be very helpful to generate backup by scheduling the MSSQL Database on windows server. Thanks for sharing the information with us.

    ReplyDelete
  2. Currently I work for one web application and your blog is useful to complete my web application task. Thanks for sharing above useful information. I am always looking out for dedicated servers

    ReplyDelete
  3. Hello
    Excellent post its very helpful for me sir. Really thank you so much.
    Dedicated Server

    ReplyDelete
  4. Bluehost is definitely one of the best hosting provider with plans for all of your hosting needs.

    ReplyDelete