{"id":18351,"date":"2018-12-20T15:20:51","date_gmt":"2018-12-20T11:20:51","guid":{"rendered":"https:\/\/www.msp360.com\/resources\/?p=18351"},"modified":"2024-02-14T15:49:04","modified_gmt":"2024-02-14T11:49:04","slug":"sql-server-backup-database","status":"publish","type":"post","link":"https:\/\/www.msp360.com\/resources\/blog\/sql-server-backup-database\/","title":{"rendered":"SQL Server Database Backup with MSP360"},"content":{"rendered":"<p>To keep your Microsoft SQL Server databases safe, you need to back them up. Today, it is considered a best practice to have at least two backup copies of all of your data, one on-site and one off-site.<\/p>\n<p>In this article, we will demonstrate how MSP360 Backup can provide both on-site and off-site SQL <a href=\"https:\/\/www.msp360.com\/resources\/blog\/database-backup-best-practices\/\">database backups<\/a> by backing up data to both local storage and cloud storage, and how to backup a database in SQL Server.<br \/>\n<!--more--><\/p>\n<div class=\"table-of-content \">\n\t\t\t\t<p>Table of Contents<\/p>\n\t\t\t\t<ul><\/ul>\n\t\t\t\t<\/div>\n<h2>SQL Database Backup and Restore with MSP360 Backup<\/h2>\n<p>MSP360 Backup integrates with Microsoft SQL Server\u2019s built-in backup and restore mechanism. MSP360 Backup also features encryption, flexible scheduling and a range of other options.<\/p>\n<blockquote><p>You need <a href=\"https:\/\/www.msp360.com\/backup\/\">MSP360 Backup for MS SQL Server<\/a> or <a href=\"https:\/\/www.msp360.com\/backup\/\">MSP360 Backup Ultimate<\/a> editions in order to be able to perform SQL Server database backup and restore.<\/p><\/blockquote>\n<p>In this article, we\u2019ll describe how to back up a database in SQL Server using MSP360 Backup. We\u2019ll also explain some important details that you need to know and take into account when performing backups of your databases.<br \/>\nFor instructions on the SQL Server database restore process, please check out our article \u201c<a href=\"https:\/\/www.msp360.com\/resources\/blog\/restore-database-sql-server\/\">SQL Server Database Restore<\/a>.\u201d<\/p>\n<blockquote><p>For the purposes of this article, we assume that you\u2019re already familiar with how SQL Server functions. We\u2019ll focus below on how our backup solution interacts with the SQL Server.<\/p><\/blockquote>\n<h2>How to Back Up a Database in Microsoft SQL Server<\/h2>\n<p>Launch the Backup Wizard by clicking <strong>MS SQL Server<\/strong>\u00a0button on the main toolbar or pressing <em>Ctrl+B<\/em>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18412 size-full\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture3-1.png\" alt=\"Launch SQL Server database backup in CloudBerry Backup\" width=\"363\" height=\"147\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture3-1.png 363w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture3-1-300x121.png 300w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/><\/p>\n<p>In the Backup Wizard, specify whether you want to perform backup to a single location <strong>(Local or Cloud Backup)<\/strong> or whether you'd like to back up to a local storage first and then to a cloud storage (<strong><a href=\"https:\/\/www.msp360.com\/resources\/blog\/hybrid-backup\/\">Hybrid Backup<\/a><\/strong>).<br \/>\nIn this guide, we will choose the <strong>Hybrid Backup<\/strong> option, which allows us to follow the <a href=\"https:\/\/www.msp360.com\/resources\/blog\/following-3-2-1-backup-strategy\/\">3-2-1 backup rule<\/a>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19130\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/SQLHybrid.png\" alt=\"Selecting database backup type for SQL Server database backup\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/SQLHybrid.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/SQLHybrid-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/SQLHybrid-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>Select a local storage for your backup and click <strong>Next<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19230\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/sqlLocal.png\" alt=\"Selecting local backup destination for SQL Server database backup\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/sqlLocal.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/sqlLocal-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/sqlLocal-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>Select a cloud storage location for your backup and click <strong>Next<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19228 size-full\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/sql.png\" alt=\"Selecting off-site backup destination for SQL Server database backup\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/sql.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/sql-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/09\/sql-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>Enter a plan name and proceed to the next step.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18357\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture3.png\" alt=\"Enter the backup plan name for SQL Server database backup\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture3.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture3-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture3-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>Select the desired SQL Server instance from the drop-down menu and enter your login authentication type\/credentials. Enable the option <strong>Check if the specified account has necessary permissions to perform backup<\/strong> in order to make the wizard automatically check whether the specified user account has all necessary permissions for backing up the database. When you\u2019re done, click <strong>Next<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18358 size-full\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture4.png\" alt=\"Selecting SQL Server instance for SQL Server database backup\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture4.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture4-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture4-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>On the database selection step you have 3 options:<br \/>\n- <strong>Back up all databases<\/strong>.<br \/>\n- <strong>Back up all user databases only<\/strong>.<br \/>\n- <strong>Back up selected databases<\/strong>.<br \/>\nSelect the option you desire and click <strong>Next<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18359\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture5.png\" alt=\"Select SQL Server databases for backup\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture5.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture5-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture5-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>Configure compression and encryption options.<br \/>\nMicrosoft uses a proprietary backup compression algorithm to compress data for SQL Server in certain versions. Here are the versions that support this feature:<br \/>\n<em>- SQL Server 2008: Enterprise, Developer.<\/em><br \/>\n<em>- SQL Server 2012 and higher: Enterprise, Business Intelligence, Standard, Developer.<\/em><br \/>\nMSP360 Backup will use native SQL Server compression if supported by your SQL Server version. Otherwise, MSP360 software will use a custom compression algorithm.<br \/>\nAs for security, you can choose whether you\u2019d like to use 256-bit encryption offered by MSP360 Backup.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18360 size-full\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture6.png\" alt=\"Compression and encryption for MS SQL Server database backup\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture6.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture6-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture6-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>Specify the retention policy.<br \/>\nYou can save only the necessary number of copies. This helps to prevent you from running out of space or paying more than necessary when using cloud storage.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18361\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture7.png\" alt=\"Retention policy for SQL Server database backup\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture7.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture7-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture7-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>On the scheduling step you have the following options to choose from:<br \/>\n-<strong> No schedule<\/strong> or <strong>Specific date<\/strong>. If you choose this option, your backup will run as a one-time job; in other words, a full-backup will be performed with no <a href=\"https:\/\/www.msp360.com\/resources\/blog\/differential-backup-explained\/\">differential backup<\/a> or transaction log backup taking place.<br \/>\n- <strong>Recurring (predefined templates)<\/strong> or <strong>Recurring (advanced schedule)<\/strong>. These two options enable you to configure the frequency of <em>full<\/em>, <em>differential<\/em>, and <em>transaction log backups<\/em>.<br \/>\nHere are the definitions of these SQL database <a href=\"https:\/\/www.msp360.com\/resources\/blog\/backup-types-comparison\/\">backup types<\/a>:<br \/>\n<em>Full backup<\/em> \u2014 a database backup that contains all the needed information in a database to perform a full restore.<br \/>\n<em><a href=\"https:\/\/www.msp360.com\/resources\/blog\/microsoft-sql-server-differential-backup\/\">Differential SQL Server backup<\/a><\/em> \u00a0\u2014 a database backup that contains only the data that has changed since the last full backup.<br \/>\n<em><a href=\"https:\/\/www.msp360.com\/resources\/blog\/sql-server-transaction-log-backup\/\">Transaction log (T-log) backup<\/a> <\/em>\u2014 a backup of current database transactions that includes all log records that were not backed up in a previous log backup.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18362\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture8.png\" alt=\"Scheduling of sql database backups\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture8.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture8-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture8-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><br \/>\nNote that SQL Server database backup and restore operations occur within the context of the recovery model of the database. A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are available. Three recovery models exist: <em>simple<\/em>, <em>full<\/em>, and <em>bulk-logged<\/em>. If you want to perform transaction log backup, ensure that your database recovery model property is set to <em>Full<\/em> or <em>Bulk<\/em>; any other value will result in an error.<\/p>\n<p>Having selected the <strong>Recurring (predefined templates)<\/strong> option on the previous step, you\u2019ll be able to choose from one of our recommended templates.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18363\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture9.png\" alt=\"Scheduling of SQL Server database backups: predefined options\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture9.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture9-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture9-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-18364\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture10.png\" alt=\"Scheduling of SQL Server database backups: select and apply\" width=\"625\" height=\"488\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture10.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture10-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture10-624x487.png 624w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>Alternatively, if you use the <strong>Recurring (advanced schedule)<\/strong> option, you can set the required frequency by minutes\/hours\/days, schedule bi-weekly backups, and so on.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18365\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture11.png\" alt=\"Advanced Scheduling of SQL Server database backups\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture11.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture11-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture11-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-18366\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture12.png\" alt=\"Advanced Scheduling of SQL Server database backups part 2\" width=\"625\" height=\"488\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture12.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture12-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture12-624x487.png 624w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>Set up <b>pre- &amp; post- actions<\/b>: specify scripts to be executed prior to and right after the backup plan execution. You can also create a <a href=\"https:\/\/www.msp360.com\/resources\/blog\/chain-backups-in-backup-5-6\/\">backup chain<\/a>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18367\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture13.png\" alt=\"Backup chain for SQL Server database backup\" width=\"643\" height=\"502\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture13.png 643w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture13-300x234.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture13-624x487.png 624w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>Complete the backup wizard and wait for the next scheduled execution or, if you wish, execute the backup plan immediately.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18369 size-full\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture14.png\" alt=\"SQL Server database backup report\" width=\"1424\" height=\"273\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture14.png 1424w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture14-300x58.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture14-768x147.png 768w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture14-1024x196.png 1024w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture14-624x120.png 624w\" sizes=\"auto, (max-width: 1424px) 100vw, 1424px\" \/><\/p>\n<p>Once complete, the backups will be displayed in the backup storage tab.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18370 size-full\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture15.png\" alt=\"Stored SQL Server database backups overview\" width=\"1070\" height=\"469\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture15.png 1070w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture15-300x131.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture15-768x337.png 768w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture15-1024x449.png 1024w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2017\/07\/Capture15-624x274.png 624w\" sizes=\"auto, (max-width: 1070px) 100vw, 1070px\" \/><\/p>\n<h3>How to Backup a Database in SQL Server Using More Than One Product<\/h3>\n<p id=\"last\">We don't recommend using multiple backup methods for a single SQL Server. You should instead use a single backup software or scripts in order to keep your toolset and process simple, and avoid data conflicts.<\/p>\n<div id=\"slidebox\"><a class=\"close\">\u00a0<\/a><!--HubSpot Call-to-Action Code --><span class=\"hs-cta-wrapper hs-cta-deferred\" id=\"hs-cta-wrapper-3032fa20-c25d-4554-b82e-0e1d01d94ecd\" data-portal=\"5442029\" data-id=\"3032fa20-c25d-4554-b82e-0e1d01d94ecd\"><span class=\"hs-cta-node hs-cta-3032fa20-c25d-4554-b82e-0e1d01d94ecd\" id=\"hs-cta-3032fa20-c25d-4554-b82e-0e1d01d94ecd\"><!--[if lte IE 8]><div id=\"hs-cta-ie-element\"><\/div><![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/5442029\/3032fa20-c25d-4554-b82e-0e1d01d94ecd\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"hs-cta-img\" id=\"hs-cta-img-3032fa20-c25d-4554-b82e-0e1d01d94ecd\" style=\"border-width:0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/5442029\/3032fa20-c25d-4554-b82e-0e1d01d94ecd.png\" alt=\"CTA\"><\/a><\/span><\/span><!-- end HubSpot Call-to-Action Code --><\/div>\n<p>If you want to perform SQL database backup to two different locations, take advantage of the <a href=\"https:\/\/www.msp360.com\/resources\/blog\/hybrid-backup\/\">Hybrid Backup<\/a> feature offered by MSP360 Backup. (This option was chosen in step 2 of our guide above.)<\/p>\n<p>If you have two products running backups on the same set of databases, you may end up with differential and transaction log backups that cannot be restored.<\/p>\n<p>As an example, let\u2019s say you use two backup products and do the following procedure:<\/p>\n<ol>\n<li>Back up your customer database using MSP360 Backup (CustomerFull1).<\/li>\n<li>Perform the first differential backup for that database using MSP360 Backup (CustomerDiff1).<\/li>\n<li>Back up the Customer database using another product (CustomerFull2).<\/li>\n<li>Perform the second differential backup for the master database using MSP360 Backup (CustomerDiff2).<\/li>\n<\/ol>\n<p>You would expect that CustomerDiff2 could be restored after CustomerFull1, but in reality, CustomerDiff2 is based on the CustomerFull2 database, which was created by a different product. You may not be able to perform the restore in the way you expect.<br \/>\nThis case only applies to individual databases. If you perform a backup of two different databases using two different <a href=\"https:\/\/www.msp360.com\/resources\/blog\/data-backup-plan\/\">backup plans<\/a> or backup products, there should be no issues.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To keep your Microsoft SQL Server databases safe, you need to back them up. Today, it is considered a best practice to have at least two backup copies of all of your data, one on-site and one off-site. In this article, we will demonstrate how MSP360 Backup can provide both on-site and off-site SQL database [&hellip;]<\/p>\n","protected":false},"author":46,"featured_media":29105,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[877,894,882],"tags":[],"class_list":["post-18351","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-articles","category-msp360-backup","category-msp360-news"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/18351","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\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/comments?post=18351"}],"version-history":[{"count":5,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/18351\/revisions"}],"predecessor-version":[{"id":57616,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/18351\/revisions\/57616"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/media\/29105"}],"wp:attachment":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/media?parent=18351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/categories?post=18351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/tags?post=18351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}