Portal Home > Knowledgebase > General Tech Questions > How to restore my current MSSQL database to hosting DB?

Knowledgebase

How to restore my current MSSQL database to hosting DB?

Create backup of your local DB with MS SQL server 2008 Managemet studio, then upload it to your hosting space via FTP.

Then login to Control panel in Databases category, choose SQL server 2008 in the next page click on the your DB name.

In the next page "SQL Database Properties" click on the "Maintenance Tools" tab and will see "Restore" button Choose Hosting Space File radiobutton and click on the textbox bellow. Choose your backup file and click on the Restore button.

* If you have a small DB you can use Uploaded File radiobutton and upload backup directly.

You can use MS SQL Publishing wisard to create SQL script of your local DB and start it in hosting DB query

Was this answer helpful?

 Print this Article

Also Read

How to send email from page code?

To use mail.yourdomain.com, you have to create an account First. To do this - log in to your...

Which are your mail server settings?

Below is the information of your POP3/SMTP/IMAP server. You can always access your mailbox(es)...

How to set my mail client?

Below is information in reference to email settings for mail clients such as Outlook, Outlook...

Which is your WEBMAIL?

You can use webmail http://mail.yourdomain and type your full mail address and it's password....

Which framework is using my site by default?

The Application pool is 2.0 by default, it covers Framework 2.0, 3.0 and 3.5. You can change it...