Restore a MSSQL database via myLittleBackup tool

myLittleBackup for SQL Server is the first Backup/Restore solution specially designed for shared SQL Server hosting. It provides an easy and secure solution to backup/restore databases. 

 To perform a Microsoft SQL Restore you must first login to the myLittleBackup interface by visiting the following link:

https://mlb.ixwebhosting.com 

You will need the following information to login:

  • Server name. You can select it from the list of our servers.

  • Authentication: SQL Server Authentication

  • Database name

  • Database Username

  • Database Password

If you do not have this infomation, You can log in to your H-Sphere

control panel and click on the MSSQL Server icon to verify the database username and password. For more information please go to the following links:

how to create a MSSQL database: http://www.ixwebhosting.com/support/st_kb/how-to-create-a-mssql-database/

how to create a MSSQL database user: http://www.ixwebhosting.com/support/st_kb/how-to-create-a-mssql-database-user/

mlb

 

Restore a Database

After logging into myLittleBackup, there you will notice several options on the left hand side of your screen. In order to perform a backup you must first click on the Restore Databases options. This will open the right side of your screen with the required steps to restore a database:

1. You should now select the database you are looking to restore.

mlb2

 

2. The next step informs you of the size and when  backup was created. After verifying the information click “Ok”.

mlb3

 

You will have two options before performing a database restore:

  • You can choose to restore from a previously saved backup. This is a backup which was created using this interface. If a backup was never created by this interface, no backups will be available.
  • You can choose to restore from a backup file you have saved on your computer. This file may have come from your previous hosting provider or by your own creation.

 

mlb4

4. You can now restore the database. Click on the button labeled “Restore” and the process will begin. Once the process begins it may take several minutes before the restore has completed. Do not close your browser or stop the process from continuing as this will cause your database to become corrupt and possibly data loss.

mlb5

mlb6

  1. After the database has been restored a confirmation box will appear letting you know it was completed. If there are any errors, this may be the result of a bad database backup and may require a different back up to be used in order to successfully restore the database.

  2.  Check database options. Now that your database has been successfully restored, several important database options will be checked and reset if necessary.

 

mlb7

Was this article helpful?

Yes (1)
No (0)

We're sorry you didn't find this article very helpful. Please help us improve it by leaving your feedback below.

Error