25 Aug 10 How do I restore a MS SQL database?
Gossimer Windows Hosting Control Panel allows you to restore an existing database from a backup copy as explained below:
1. Login to your Control Panel, search for the domain name for which you have purchased the Web Hosting package and go to the Order Details view. Click here to know how >>
2. Click Manage Web Hosting Service in the lower toolbar.
3. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> List Databases.
4. Click the database you wish to manage.
5. Click Restore Database. Select the Database Username from the drop-down menu next to Database Username. This user will own all tables, views and stored procedures in the restored database, if the current owner of the backup file does not exist on Gossimer SQL server.
Select the backup file from the drop-down menu next to File to be Restored. You can select the backup which was saved on the server in the sqlDatabaseBackup directory or you can upload a .bak backup file onto the sqlDatabaseBackup directory and select it from the list.
6. Click Submit to restore the database.
Reference: Uploading content to your Website using FTP >>
Effective from 15 November 2007, all databases (MS SQL) purchased on Gossimer Windows Hosting Servers will be created on MS SQL 2005 Servers. There exists a backward compatibility issue with SQL 2005 in restoring a database to SQL 2000 (or an earlier version of MS SQL). This is on account of Microsoft not providing backward compatibility with earlier versions of MS SQL due to different internal file structures.
An alternate method would be usage of MS SQL Server Database Publishing Wizard. MS SQL Server Database Publishing Wizard enables the deployment of SQL Server databases either into 2000 or 2005 hosting environment. It generates a single SQL script file which can be used to recreate a database (both schema and data) for SQL 2000 and SQL 2005 versions. Click here to download this tool >>
There is no issue restoring SQL 2000 (or any earlier version) database to SQL 2005 version.
Tags: Alternate Method, Backup File, Backward Compatibility, Compatibility Issue, current owner, Database Manager, Database Publishing, Database Reference, Details View, File Structures, Gt 2, Hosting Servers, Manage Web Hosting Service, Management Interface, Microsoft, Microsoft Windows, Ms Sql Database, Ms Sql Server, SQL, Sql 2000, Sql Databases, Sql Script, Sql Server Database, Sql Server Databases, Web Hosting, Web Hosting Service, Website Management
Leave a Comment
Gossimer Promotions and Announcements
- TechSupport Notifications February 28, 2010Technical support information and notifications […]
- PHP4 Discontinuation - 18th September September 7, 2009As announced earlier, PHP4 will not be supported on our Linux Hosting Servers from the 18th of September, 2009. Please pass on this information to your Customers and Resellers to ensure that they can update their websites to work with PHP5. […]
- .CN Launch - Coming Soon August 16, 2009We are glad to announce the launch of .CN - the most popular and fastest growing ccTLD worldwide. The .CN domain extension has seen an exemplary growth since its launch throughout the world. Earlier this year, .CN crossed over 13 million registrations to become the second most registered domain extension after .COM. Moreover, with China now representing the […]
- Live Chat Product Discontinuation - Moved to 18th August August 16, 2009Based on feedback that we received from several Resellers, we have decided to postpone the Live Chat discontinuation to the August of 18th, 2009 at 12:30 UTC. From the 18th of August, it will not be possible to purchase new Live Chat packages but exisiting packages will continue to function normally. […]