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:
You will need the following information to login:
Server name. You can select it from the list of our servers.
Authentication: SQL Server Authentication
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/
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.
2. The next step informs you of the size and when backup was created. After verifying the information click “Ok”.
You will have two options before performing a database restore:
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.
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.
Check database options. Now that your database has been successfully restored, several important database options will be checked and reset if necessary.