MSSQL Tools

microsoft-sql

#1

What are MSSQL Tools

MSSQL Tools will provide you a web interface to manage, backup, and restore your MSSQL databases. This feature is only available on Shared Hosting packages. However, a better alternative to myLittleAdmin is SQL Server Management Studio.



You can download this free from microsoft here.

MSSQL Tools

  1. Login to your WCP control panel.

    Note: You can view our topic on logging into WCP if you need help with this step.

  2. Once logged in if you are not already on the domain in questions control panel page then click on the ‘Hosted Domains’ drop-down from the top of the pages navigation bar. Then select the desired domain from the drop-down.

    Select_Domain


  1. Once you are located in the specific domain you would like to manage a MSSQL database for click on the MSSQL Tools icon.


  1. You will then be presented with the MSSQL Tools Window. From this window you will be able to see all MSSQL domains associated with this domain. You will also have links to the myLittleAdmin and myLittleBackup tools.


myLittleAdmin

My little admin provides many tools used to manage your database. Clicking on the Login button will bring you to a new tab. You can find additional information about the functionality of this software in the Quick Start Guide.



myLittleBackup

myLittleBackup provides a web based interface for backing up and restoring databases. It also allow you to check the integrity of a backed up database.

  1. Click on the Login button under the myLittleBackup heading.


  2. You will now be presented with the starting screen for myLittleBackup. Available functions will be available on the left side in a taskbar. We will be going over each item below.

    Backup Databases

    This section of myLittleBackup allows you to take backups of MSSQL databases.

    1. First, choose the database you would like to take a backup of.

    1. Once a db is selected, step 2 will display general information about the database to show up. Once you have confirmed the information is correct click the Ok button.


    1. Once you have clicked Ok, you will then be allowed to enter a Set Name and Set Description. The set name should not include spaces (use _ underscores instead). The set description allows for up to 255 characters (spaces are ok in this field) to describe this backup.


    1. You will now be able to proceed with the actual backup. Click the Backup button. This will take a few moments, depending on the size of the database.


    1. You will then recieve a confirmation that the backup was completed, as well as a link to download the backup. Click on the link to begin downloading your backup.


    Restore Databases

    This section will allow you to restore a database using a backup created in the previous section.

    1. To begin, select the database you would like restored from the drop-down menu.



    2. Confirm that the information is correct about the database you will be restoring to and click Ok.



    3. Click the Choose File button to upload the previously downloaded backup. Once the file has been successfully selected, click the Ok button. It will then be uploaded. Once completed you should see the .bak file listed in the box above the buttons. Select the backup you have just uploaded and click Ok.



    4. You can now choose the backup set to use. If there is only one set you can proceed by clicking the Restore button. Once you have clicked the Restore button a notification will pop-up. Click Ok to continue.

      Note: Depending on the size of the database this may take several minutes to complete.




    5. Once the database has been restored, any errors that occured will appear under the Check database options heading.



    Check Databases

    The Check Databases section will allow you to check the health of a database.

    1. To begin select the Database you would like to check from the drop-down menu.



    2. You will then be presented with general information about the selected database. Click Ok to continue.



    3. The third step will check to see if any orphaned users are associated with the database. Click Ok to continue.



    4. The final step will perform generic checks on the database configuration. The results of which will be displayed in a table below the section heading.



    Manage Backup Files

    The Manage Backup Files section allows you to manage the folders your backups are stored in on the server.

    1. Select the database you would like to manage database backups for.



    2. Click the Ok button after reviewing the database information you have selected.



    3. Next, you will choose the folder you would like to manage. The Restore Folder will contain backups that you have uploaded. The Backup Folder will hold 2 archived .bak files that you have created using the Backup Databases function. After choosing the folder click the Ok button.



    4. For the final step you will be presented with a list of the files in the selected folder. To the left of the file name are three icons:

      • Delete - This will delete the file
      • Download - Clicking this icon will allow you to download the file.
      • Copy to Restore Folder (if in the backup folder) - This will place a copy of the file in the restore folder.