Backing up and Restoring SQL Server Databases


To backup SQL Server database:

  1. Login to the Easy Hosting Control website. Learn How.
  2. Click Database icon and select SQL Server
  3. Click the Database Name
  4. Select Maintenance Tools
  5. Click the Backup button
  6. Specify backup name and select preferred method for storing backup. You could download it immediately or copy to a folder within your hosting space.
  7. The panel produces SQL Server backups in BAK format. The resulting file could be very large, but you have an option to compress it by selecting the "Zip Backup" option.
  8. Click the Backup button

To Restore a SQL Server Database:

  1. Follow steps 1-4 in backup procedure above.
  2. Click the Restore button
  3. Click Browse button to select backup file from your local file system or select "Hosting Space File" option and then pick the backup file from the hosting space file system. If your database backup file is > 5MB, it is recommended to upload the file using FTP and then use the "Hosting Space File" option to restore it.
  4. Click the Restore button

Was this answer helpful?

 Print this Article

Related Articles

Why don't I have any IP addresses allocated to my hosting space?

IP Addresses are allocated to a hosting space only if that space requires it's own unique IP...

Password Complexity Requirements

When creating user accounts (ftp, email, database) in Website Panel, the following complexity...

Web Application Gallery

The Web Application Gallery is a great tool which allows you to equip your...

How do I connect to SQL Server on my Dedicated Machine from my desktop?

If you have a dedicated (physical or virtual) machine with i7MEDIA and you have SQL Server...

What connection string can I use to connect to my MSSQL database?

The following connection string is an example. More connection strings can be found on the...