{"id":48114,"date":"2023-03-10T15:17:01","date_gmt":"2023-03-10T11:17:01","guid":{"rendered":"https:\/\/www.msp360.com\/resources\/?p=48114"},"modified":"2025-02-12T12:04:27","modified_gmt":"2025-02-12T08:04:27","slug":"sql-server-backup-in-msp360-managed-backup-service","status":"publish","type":"post","link":"https:\/\/www.msp360.com\/resources\/blog\/sql-server-backup-in-msp360-managed-backup-service\/","title":{"rendered":"SQL Server Backup in MSP360 Managed Backup Service"},"content":{"rendered":"<h2 id=\"introduction\">Introduction<\/h2>\n<p>This article will guide you to through setting up Microsoft SQL Server backup, using the MSP360 Managed Backup. It covers all aspects of a database backup, including choice of storage, schedule, and retention policy.<\/p>\n<p><!--more--><\/p>\n<p>Backing up Microsoft SQL Server with all its databases is a must for every organization that uses it and, therefore, is a part of an MSP\u2019s daily work. This process is specific, because of the large amount of data and changes that are very frequent. Not only do you need to copy all this data, but you should also track all the modifications, to be able to recover everything to a certain point in time if this is needed. That is why it is highly recommended to combine several types of backup:<\/p>\n<ul>\n<li>do <a href=\"https:\/\/www.msp360.com\/resources\/blog\/backup-types-comparison\/\">full backups<\/a> regularly<\/li>\n<li>do <a href=\"https:\/\/www.msp360.com\/resources\/blog\/differential-backup-explained\/\">differential backups<\/a> more frequently<\/li>\n<li>back up <a href=\"https:\/\/www.msp360.com\/resources\/blog\/sql-server-transaction-log-backup\/\">transaction logs<\/a>, to be able to restore everything if trouble occurs.<\/li>\n<\/ul>\n<p>Full backups save all the data, differential ones upload changes, and transaction logs capture all the transactions that are being made.<\/p>\n<p>Using MSP360 Managed Backup Service, you can back up your server with all the components of your databases. The solution is fully integrated with the mechanisms of Microsoft SQL Server to prevent data loss, as well as providing you with many features and great usability. To create a backup of your server from your MSP360 Managed Backup Service console, follow the instructions below.<\/p>\n<h2 id=\"starting-backup-configuration\">1. Starting Backup Configuration<\/h2>\n<p>Enter your MSP360 Managed Backup Service console and proceed to the <strong>Remote Management<\/strong> tab. Click the gear icon near the server you want to back up and choose <strong>Show Plans<\/strong> from the drop-down menu.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image1-4.png\" alt=\"MSP360 Managed Backup Service: Creating a Plan\" \/><br \/>\n<\/figure>\n<p>Then, click the plus button and select MS SQL.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image15.png\" alt=\"MSP360 Managed Backup Service: Choosing What to Back Up\" \/><br \/>\n<\/figure>\n<p>Give your plan a name.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image13.png\" alt=\"MSP360 Managed Backup Service: Naming a Plan\" \/><br \/>\n<\/figure>\n<h2 id=\"select-storage\">2. Select Storage<\/h2>\n<p>Define how you\u2019re going to back up your data \u2013 to the local or cloud storage or two storages, local and local or cloud. The latter method is better for keeping your data safe according to <a href=\"https:\/\/www.msp360.com\/resources\/blog\/following-3-2-1-backup-strategy\/\">the 3-2-1 rule<\/a>.<\/p>\n<p><span class=\"further-reading \">Further reading<\/span> <a href=\"https:\/\/www.msp360.com\/resources\/blog\/3-2-1-1-0-backup-rule\/\">The 3-2-1 Backup Rule: Extend Your Backup Security<\/a><\/p>\n<div id=\"slidebox\">\n<a class=\"close\"> <\/a><!--HubSpot Call-to-Action Code --><span class=\"hs-cta-wrapper hs-cta-deferred\" id=\"hs-cta-wrapper-aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\" data-portal=\"5442029\" data-id=\"aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\"><span class=\"hs-cta-node hs-cta-aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\" id=\"hs-cta-aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\"><!--[if lte IE 8]><div id=\"hs-cta-ie-element\"><\/div><![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/5442029\/aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"hs-cta-img\" id=\"hs-cta-img-aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\" style=\"border-width:0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/5442029\/aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6.png\" alt=\"CTA\"><\/a><\/span><\/span><!-- end HubSpot Call-to-Action Code -->\n<\/div>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image16.png\" alt=\"MSP360 Managed Backup Service: Selecting a Storage\" \/><br \/>\n<\/figure>\n<h2 id=\"select-sql-server-instance\">3. Select SQL Server Instance<\/h2>\n<p>Select the required SQL Server instance and the authentication type. If you choose SQL, you\u2019ll need to enter your username and password. Click the checkboxes to verify the permissions and\/or use a secure connection if needed. <img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image9-1.png\" alt=\"MSP360 Managed Backup Service: Selecting an Instance\" \/><\/p>\n<h2 id=\"select-databases-to-back-up\">4. Select Databases to Back Up<\/h2>\n<p>Choose the databases you want to back up. <img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image12.png\" alt=\"MSP360 Managed Backup Service: Choosing Databases\" \/><\/p>\n<p>Enable compression if you need to occupy minimum space in the storage. Encryption provides you with an additional layer of data protection. Please note: if you forget the password, you won\u2019t be able to recover your server.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image10.png\" alt=\"MSP360 Managed Backup Service: Compression and Encryption\" \/><br \/>\n<\/figure>\n<h2 id=\"specify-retention-policy\">5. Specify Retention Policy<\/h2>\n<p>Next, specify the retention policy. You can use the default options (they are on your screen, greyed out) or set up your own. For example, you can:<\/p>\n<ul>\n<li>change the number of full backups you want to keep (along with differential and transaction log backups) or delay purge for more than three days (three is the default setting) so that you will have more time to check whether you need the backups that are going to be deleted.<\/li>\n<li>or delete versions (each version is full backup + differential + transaction log) that are outdated.<\/li>\n<\/ul>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image2-4.png\" alt=\"MSP360 Managed Backup Service: Retention Policy\" \/><br \/>\n<\/figure>\n<h2 id=\"define-advanced-storage-options\">6. Define Advanced Storage Options<\/h2>\n<p>Define advanced storage options, if needed.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image8-1.png\" alt=\"MSP360 Managed Backup Service: Advanced Storage Options\" \/><br \/>\n<\/figure>\n<h2 id=\"define-backup-schedule\">7. Define Backup Schedule<\/h2>\n<p>In the next step, define the schedule for your backup plan. Of course, you can run it manually or choose a specific date to launch the plan, but it is recommended that you choose a schedule according to your estimated <a href=\"https:\/\/www.msp360.com\/resources\/blog\/rto-vs-rpo\/\">RTO\/RPO<\/a>. Also, here you can tell the solution what to do if the plan runs for too long or if it was missed due to a computer being down. Additionally, the <strong>Alert plan as overdue after<\/strong> option allows you to receive a notification if the backup plan fails after the defined number of days.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image3-3.png\" alt=\"MSP360 Managed Backup Service: Main Schedule Options\" \/><br \/>\n<\/figure>\n<p>If you choose the <strong>Recurring (predefined templates)<\/strong> schedule, the solution will prompt you to select a template for running your plan.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image4-3.png\" alt=\"MSP360 Managed Backup Service: Simple Schedule\" \/><br \/>\n<\/figure>\n<p>The <strong>Recurring (advanced)<\/strong> option is for those who prefer to customize everything manually. Here, you can set up the exact starting time for every component of your backup plan.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image5-3.png\" alt=\"MSP360 Managed Backup Service: Advanced Schedule\" \/><br \/>\n<\/figure>\n<h2 id=\"define-actions-before-and-after-backup\">8. Define Actions Before and After Backup<\/h2>\n<p>The <strong>Pre \/ Post actions<\/strong> section allows synchronizing your local repository with backup storage before the plan runs. Additionally, you can set up what script to run before or after backing up your files or choose another plan to be launched after the current one.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image6-2.png\" alt=\"MSP360 Managed Backup Service: Pre- and Post Actions\" \/><br \/>\n<\/figure>\n<p>Finally, set up notifications if you want to get emails about the success, partial failure, or total failure of the backup plan.<\/p>\n<p><span class=\"further-reading \">Further reading<\/span> <a href=\"https:\/\/www.msp360.com\/resources\/blog\/setting-up-backup-and-recovery-plan-notifications-in-msp360-managed-backup\/\">Setting up notifications in Managed Backup Service.<\/a><\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image7-1.png\" alt=\"MSP360 Managed Backup Service: Notifications\" \/><br \/>\n<\/figure>\n<p>That\u2019s it. The plan has appeared in your plans list.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image11.png\" alt=\"MSP360 Managed Backup Service: the Plan is Ready\" \/><br \/>\n<\/figure>\n<h2 id=\"conclusion\">Conclusion<\/h2>\n<p>Now you know how to set up your Microsoft SQL Server backup plan in the MSP360 Managed Backup Server console. Another way to create a plan is to use the Managed Backup Server agent \u2013 just launch it on the required computer and click <strong>MS SQL Server<\/strong> to run the wizard. The settings are similar to those of the console version.<\/p>\n<figure>\n<img decoding=\"async\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2020\/12\/image14.png\" alt=\"SQL Backup in the MSP360 Managed Backup Agent\" \/><br \/>\n<\/figure>\n<p>Backing up your Microsoft SQL Server regularly is very important. It allows you to prevent loss of your vital data and therefore, even if something happens to your server, you can restore it and quickly get back to your normal working schedule.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction This article will guide you to through setting up Microsoft SQL Server backup, using the MSP360 Managed Backup. It covers all aspects of a database backup, including choice of storage, schedule, and retention policy.<\/p>\n","protected":false},"author":89,"featured_media":48122,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[878,931],"tags":[955],"class_list":["post-48114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-msp-university","category-msp360-product-guides","tag-sql-server-backup-in-msp360-managed-backup-service"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/48114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/users\/89"}],"replies":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/comments?post=48114"}],"version-history":[{"count":8,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/48114\/revisions"}],"predecessor-version":[{"id":59536,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/48114\/revisions\/59536"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/media\/48122"}],"wp:attachment":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/media?parent=48114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/categories?post=48114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/tags?post=48114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}