---
title: "Backup Your MSSQL Database in Cloud Sites"
source: "https://docs.nexcess.com/hosting/cloud-sites/database-management/mssql/backup-your-mssql-database-in-cloud-sites/"
description: "Regularly backing up your database is crucial for site maintenance on Cloud Sites. To manually backup your MSSQL database, access myLittleAdmin from the Cloud S…"
vertical: "Hosting"
date: "2024-03-04"
last_modified: "2026-07-02"
---

# Backup Your MSSQL Database in Cloud Sites

Backing up your database is an important part of site maintenance in Cloud Sites. In order to create a manual backup of your MSSQL database from the Cloud Sites control panel, you will need to log into myLittleAdmin.

This tutorial assumes you are already logged into myLittleAdmin. If you need instructions on how to log into your database, see our article [Logging into myLittleAdmin from Cloud Sites](https://www.liquidweb.com/help-docs/logging-into-mylittleadmin-from-cloud-sites/).

| ### **Note:** |
|---|
| For myLittleBackup to open, please disable pop-up blockers for the myLittleAdmin page. |

1. From the home page of myLittleAdmin, click on the **Tools** section.  
    ![tools link highlighted on phpmyadmin home page](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_jXKNyq.png)
2. From the menu, click **Database Backup and Restore**.  
    ![database backup and restore highlighted](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_nB763e.png)
3. myLittleBackup will open in a new window.  
    ![](https://hc-images.ops.liquidweb.com/hc/article_attachments/217312707/mylittlebackup.png)
4. Click the link **Backup databases**.  
    ![backup databases highlighted](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_2qtD2i.png)
5. The **Back Up A Database** page will open.  
    ![backup database home page](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_93Mrc7.png)
6. Choose the database you want to backup using the drop-down menu at the top of the page.  
    ![database drop down section highlighted](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_w2DtaY.png)
    
    | ### **Warning:** |
    |---|
    | If you see the notification “There are too many backup files in your backup folder”; it means you already have a backup file saved in myLittleBackup. You need to delete that backup before you can create a new one |
7. Click **Ok** to verify the information for the database.  
    ![ok button highlighted](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_k25zMq.png)
8. Give the backup a name and description.  
    ![backup name entered](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_YJ6C3C.png)
9. Click **Backup**.  
    ![backup button highlighted](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_QVyXI3.png)| ### **Note:** |
    |---|
    | During the backup process, a loading message displays on the screen with the following warning message: You’re now ready to backup your database. The process can take several minutes. Be patient and do not click the stop button until done. |
10. Once the backup is complete, a link will appear for you to download the backup to your local workstation.  
    ![backup link for download highlighted](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_3dQoIv.png)

You can learn how to restore your database in our article [Restoring Your MSSQL Database in Cloud Sites](https://www.liquidweb.com/help-docs/restoring-your-mssql-database-in-cloud-sites/).