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 override default spam settings for this domain?

Login to your webmail - http://mail.yourdomain with your administrator email account Go to...

Which is your WEBMAIL?

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

How to send email from page code?

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

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...

Do you support ASP.NET MVC 3?

Yes, we support ASP.NET MVC 2 and ASP.NET MVC 3