How do I back up and restore my MS-SQL database?

You can back up and restore your MS-SQL database by using the MS-SQL Web Data Administrator tool.

You can access it by:

1. Log into your eXtend Control Panel
2. Click 'MS-SQL Web Data Administrator Tool'

To back up your MS-SQL database:

1. Select your MS-SQL database
2. Click ‘Backup’
3. Download the .sql file

To restore your MS-SQL database:

1. Click ‘Restore’
2. Select your .sql file from your computer
3. Click ‘Upload’

The MS-SQL Web Data Administrator Tool can only produce and restore .sql files.  Please raise a Support Ticket with the Customer Services team if you have a .bak file from another MS-SQL server you need to restore from.

Article ID: 1
Created On: Thu, Feb 26, 2015 at 4:34 PM
Last Updated On: Thu, Apr 23, 2015 at 10:03 AM

Online URL: https://www.heartinternet.uk/support/article/how-do-i-back-up-and-restore-my-ms-sql-database.html