How to back up and restore SQL Server Database?

To backup SQL Server database open its properties screen:

  • Click on the Database name.
  • Expand "Maintenance Tool" section and click on the "Backup" button under the section.

Sqlbackup.png

  • Enter the backup File name.
  • Select your preferred method for storing backup. You can download it immediately or copy to some folder within your hosting space.
  • Click on the " Backup" Button.
    The control panel produces SQL Server backups in the BAK format. The resulting file could be very large, depending upon the actual size of the database and its transaction log, but you can compress it by ticking the “ZIP Backup” option.

Sqlbackup1.png

Restoration of SQL Database

  • To restore SQL Server database click “Restore” button under the "Maintenance Tool" section.

Restoresql.png

  • Click on the “Browse…” button to select the backup file from your local file system or tick the “Hosting Space File” option and then pick the backup file from the hosting space file system. 
  • Click on the “Restore” button to finish the restoration wizard.

View this video tutorial and learn more about how to back up and restore SQL Server Database in WebsitePanel.  

Ask a question

"Hey couldn't find what you were looking for in our knowledgebase? Please enter your question here".

First Name *
Last Name *
Email Address *
Question *
Captcha *