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

IMPORTANT

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