In order to take and retrieve a backup of an existing MS SQL database in your hosting account please follow the instructions below:
- Login to your hosting control panel.
- Click the MS SQL database version your working with under the Databases icons.
- Click your database name from the list.
- Click Maintenance Tools.
- Click Backup.
- If your database is small (less than 50MB) you can choose to download the backup via HTTP.
- If your database is large, we recommend you do not do that and select the Copy To Folder option.
- If you do choose to backup via HTTP then click the Backup button, be patient while the database is backed up and zipped, when its ready your browser will alert you that a download is available.
- If selecting the Copy To Folder option you need to click in the path box and navigate to a path in your webspace where you want to store the backup file.
- When ready, click Backup.
- Once you have clicked Backup, please be patient. If your database is large it could take a long time to complete.
- Also if your database is large and the systems are busy your backup may be queued. Its worth waiting a while and checking the backup location in the File Manager or FTP to see if its completed.
- You can now login to your webspace via FTP or the File Manager and navigate to where you placed the backup and download it.
- Once you have a copy please delete it from your web space to reserve space.
