MS SQL

Backup MSSQL database from Website Panel

Step. 1. Sign into your WebSitePanel , Click on the Databases icon and select SQL Server 2008.




Step. 2. Select the database you want to backup




Step. 3. "SQL Database Properties" page appears, expand the Maintenance Tools option then click on Backup button




Step. 4. "Backup SQL database" Page appears

  • Type the file name in the Backup file name text box.
  • Select if you want the file to be zipped or not in the 'Zip Backup' check box
  • 'Backup destination' as \mydomain.com\data\ folder (here replace mydomain.com with your actual domain name). We recommend backup to the server rather than download via HTTP especially for slow connection.
  • After selecting the required options, click on the "Backup" button

Note: Once the backup process is over, download the backup file to your local server /PC via any FTP client. Please make sure to delete the backup file from the server immediately after download.
Related articles
  1. Backup MS SQL db via Microsoft SQL Server 2008 Management Studio Express
  2. Restore MS SQL database from Website Panel
  3. FAQ on MS SQL