To transfer your local SQL Server database to a WinHost database, you will need to:
1. Backup your local database with Management Studio,
2. Upload the backup of your database with .BAK extension to your web site with your favorite ftp client,
3. Use restore tools in WinHost control panel to restore the backup to your WinHost database.
Please use
Microsoft Book Online for the instructions on how to backup your local database or see
this community forum post for instructions.
You can restore a backup of SQL Server 2008 or earlier versions only. The backups taken on SQL Server 2008 R2 version or later will not restore to WinHost servers. All our SQL servers on WinHost are SQL Server 2008. Microsoft has a restriction on their SQL Servers product line that databases cannot be attached or restored to the previous versions of SQL Servers. That means that SQL Server 2008 R2 database can be attached/restored to R2 version only.
After you backed up your local database and uploaded the backup file with .BAK extension to your web site, please follow the instructions below to restore this backup to your database on WinHost SQL Server:
- Upload a backup file with .bak extension you want to restore to your site with your favorite ftp client
- Login to your WinHost Control Panel at https://cp.winhost.com
- In the navigation menu under WinHost logo click on "Sites" tab
- In "Your Sites" section click "Manage" link next to a site you'd like to manage
- In the "Site Tools" section click on "MS SQL 2008" button
- Click on "Manage" link next to the database you'd like restore your backup to
- Click on "Restore" button next to "Tools" label
- Click on "Browse" link next to "Backup File to Restore" text box and locate your backup file on your site.
- When the .bak file is located, click on it and hit "Select" button
- Click "Restore Backup" button
Article ID: 699, Created On: 9/25/2009, Modified: 4/21/2011