MS SQL Database Backup and Restore

From Lunarpages Web Hosting Wiki
Jump to: navigation, search

The Windows hosting plan comes with a web-based management tool designed for MS SQL Server 2005. Now you can manage your own databases, including but not limited to uploading and restoring your own database.

MyLittleAdmin for MS SQL 2005 is a tool that will allow you to manage almost all objects of your database from creating tables, schema, snapshots, to backup and restore.

How do you login to MyLittleAdmin?

The login link for MyLittleAdmin will vary depending on the MS SQL server your hosting account uses:

To find out which server/link you should use, check your welcome e-mail. The MS SQL database server information can also be found in the Customer Account Page, under Hosting Information.

You can login using the following information:

  1. Type in your database user name and password.
  2. You must choose 'SQL Server Authentication'
  3. Choose 'Options' and change the drop down for 'Network Protocols' to 'TCP/IP'.

Once logged in please follow the Restore instructions below:

Restoring Database

  1. Provide your own database backup in .bak format
  2. Log in, click on Tools > Restore Wizard (Web Hosting)
  3. Select the database from the drop-down menu and choose 'Browse' to upload the .bak file from your local computer
  4. Choose 'Restore Database' to continue
  5. A warning message will appear indicating the backup file is being uploaded and in the process of restore
  6. If the restore is successful, another message will appear indicating restore has finished

If you find that you can no longer access the database with the user that you have setup, then you will need to login to Plesk, delete the user and set it back up. You will then be able to access it through MyLittleAdmin again.

Backing up Database

To backup a MS SQL database, follow the above instructions to login to MyLittleAdmin. Once logged in please follow the Backup instructions below:

  1. Log in, click on Tools > Backup Wizard (Web Hosting)
  2. Select the database from the drop-down menu and choose a name for it where it says 'Set name'
  3. Choose 'Backup' to continue
  4. Within 5 minutes, it should backup your database and provide you with a link that you can use to download the new backup. It will be in .bak format. If you find that you can no longer access the database with the user that you have setup, then you will need to login to Plesk, delete the user and set it back up. You will then be able to access it through MyLittleAdmin again.
Share |
Want to read this in another language?