How to create and restore an MS SQL database backup using SiteBackup

Go to the SiteBackup dashboard and click the Add Database button.
 
You will be taken to the Connection Details page:
 
Winhost add database connection details
 
  • Choose Microsoft SQL database in the dropdown.
  • Port is: 1433
  • The host name is the MS SQL server domain name (e.g.: s04.winhost.com - the host name, database name and user name can be found in the MS SQL Manager in Control Panel).
  • Enter the database name.
  • Enter the database user name.
  • Enter the database password.
 
 
 
When you click "Next," the system will test the connection, and if successful you will be taken to the database Schedule Backup page.
 
  • Verify that all tables are accounted for.
  • Set the number of backups you want to store in the retention field.
  • In the frequency field, select how often the backup should run.
  • Select a start time for the backup.
  • Set the time zone to your local time.
 
Click "Next" to finalize the settings and enter a unique profile name. Check "Start a backup now" to make an immediate backup of your site.
 
 
 
Restoring a MS SQL database 
 
To restore from a backup you will first download the backup file:
  1. Go to the SiteBackup dashboard.
  2. Click the Download  Files button for the database you wish to restore.  
 
You will then be taken to the MS SQL Create Download window:
 
 
Choose the backup date you would like to download. In the Tables list you can view all of the tables and objects you will be downloading.
 
Click on the Download button and the database will be compressed in a zip file and downloaded to your computer.
 
To restore the database to your Winhost SQL database, you will need to decompress the zip file, then upload the backup file (it will end in the extension .BAK) to your site root via FTP.
 
You can use the SQL Management Tool in Control Panel to restore it to your production database.
 
 See the KB article How to backup, generate or restore a backup of an MS SQL database for instructions on using the MS SQL management tool in Control Panel.