{"id":119300,"date":"2023-01-04T11:43:54","date_gmt":"2023-01-04T11:43:54","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=119300"},"modified":"2023-02-14T04:24:17","modified_gmt":"2023-02-14T04:24:17","slug":"sql-server-hot-backup","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/","title":{"rendered":"SQL Server Hot Backup"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>SQL Server offers options to take cold back and hot backup. Below, we will discuss hot and cold backups in detail and how to take these backups. We will explain how to repair and recover the corrupted hot and cold backups.<\/p><h2 class=\"wp-block-heading\" id=\"cold-backup-in-sql-server\">Cold Backup in SQL Server<\/h2><p>Cold backup is done after setting the database offline and then copying the files to another place.<\/p><p>To do that in SSMS, we can right-click the database and select the Tasks&gt;Take Offline option.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/take-offline-option.png\" alt=\"Take database offline by right-clicking on database in SSMS\" class=\"wp-image-119302 apply-gradient-on-post-images\" width=\"533\" height=\"117\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/take-offline-option.png 710w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/take-offline-option-300x66.png 300w\" sizes=\"auto, (max-width: 533px) 100vw, 533px\" \/><\/figure>\n<\/div><p>This option will take the database offline.<\/p><p>The option will disconnect the database from the SQL Server database engine.<\/p><p><strong>Note:<\/strong> A disconnect icon will be displayed in the database.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/database-with-disconnect-icon.png\" alt=\"offline database with a disconnect icon\" class=\"wp-image-119304 apply-gradient-on-post-images\" width=\"491\" height=\"92\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/database-with-disconnect-icon.png 654w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/database-with-disconnect-icon-300x56.png 300w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/><\/figure>\n<\/div><p>Once the database is offline, copy the data files and the transaction log files. The SQL Server stores the data in the data files and the information about transactions in the transaction logs.<\/p><ul class=\"wp-block-list\">\n<li>If you do not know the location of data files and logs, take the database online again by right-clicking the database and selecting <strong>Task &gt; Bring Online<\/strong>.<\/li>\n<\/ul><ul class=\"wp-block-list\">\n<li>Once it is online, right-click the database and select Properties.<\/li>\n<\/ul><ul class=\"wp-block-list\">\n<li>Select the <strong>File<\/strong><strong>s<\/strong> page and look for the <strong>Path<\/strong>. You will find the path of the log and data files.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/files-page-in-database-properties-1-1024x642.png\" alt=\"view the path by selecting the files page under db properties\" class=\"wp-image-119306 apply-gradient-on-post-images\" width=\"768\" height=\"482\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/files-page-in-database-properties-1-1024x642.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/files-page-in-database-properties-1-300x188.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/files-page-in-database-properties-1-768x482.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/files-page-in-database-properties-1.png 1075w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>If the backup is online, take it offline and copy the files to a different location.<\/li>\n<\/ul><p>The cold backup is just a simple way to copy the files when they are offline. You can only move the log and data files when the database is offline.<\/p><h2 class=\"wp-block-heading\" id=\"hot-backup-in-sql-server\">Hot Backup in SQL Server<\/h2><p>Hot backup is done when the database is online. The process is simple. To do a hot backup, simply right-click the database and select <strong>Tasks &gt; Back Up<\/strong>.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/backup-database.png\" alt=\"click on back up from tasks \" class=\"wp-image-119307 apply-gradient-on-post-images\" width=\"462\" height=\"218\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/backup-database.png 616w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/backup-database-300x142.png 300w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Then, select a path and configure the backup according to your needs. Press OK.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/configure-back-up.png\" alt=\"configure the database back up\" class=\"wp-image-119308 apply-gradient-on-post-images\" width=\"523\" height=\"506\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/configure-back-up.png 697w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/configure-back-up-300x290.png 300w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/figure>\n<\/div><p>Alternatively, you can use the below T-SQL command to back up your database:<\/p><p class=\"has-background\" style=\"background-color:#d5d5d5\">BACKUP DATABASE [AdventureWorks2019] TO DISK = N&rsquo;C:\\data\\AdventureWorks2019.bak&rsquo; WITH NOFORMAT, NOINIT, NAME = N&rsquo;AdventureWorks2019-Full Database Backup&rsquo;, SKIP, NOREWIND, NOUNLOAD, STATS = 10<br>GO<\/p><h2 class=\"wp-block-heading\" id=\"which-backup-option-is-better?\">Which Backup Option is Better?<\/h2><p>In a cold backup, you make sure that no transactions are done during the backup. This is the main advantage of this option. On the other hand, hot backup does not require you to take the database offline. Everybody can use the database during the backup process. Hot backup is the most common.<\/p><h3 class=\"wp-block-heading\">Restrict Access during Hot Backup<\/h3><p>If you want to restrict access to the database while doing a hot backup, you can use the single-user mode or the restricted user option. To do that, right-click the database and select Properties. <\/p><ul class=\"wp-block-list\">\n<li>In Properties, go to the <strong>Options <\/strong>page and select the restrict access option.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/restrict-access-of-database.png\" alt=\"under database properties, go to options page and restrict access\" class=\"wp-image-119309 apply-gradient-on-post-images\" width=\"523\" height=\"506\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/restrict-access-of-database.png 697w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/restrict-access-of-database-300x290.png 300w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/figure>\n<\/div><p>Alternatively, you can use the following T-SQL command to set the database in single-user mode:<\/p><p class=\"has-background\" style=\"background-color:#d5d5d5\">ALTER DATABASE AdventureWorks2012<br>SET SINGLE_USER<br>WITH ROLLBACK IMMEDIATE;<br>GO<\/p><p>The below command will set the database to the Restricted User mode:<\/p><p class=\"has-background\" style=\"background-color:#d5d5d5\">ALTER DATABASE AdventureWorks2012<br>SET RESTRICTED_USER;<br>WITH ROLLBACK IMMEDIATE;<br>GO<\/p><p>The single-user mode permits only one user to handle the database. The restricted mode provides access to the database only to db_owners and db_creators.<\/p><h3 class=\"wp-block-heading\">Read-Only Mode in the Database<\/h3><p>Another way to avoid inserting and deleting transactions during the backup is to set the database in read-only mode.<\/p><ul class=\"wp-block-list\">\n<li>To do this, open SSMS, right-click the database and select the <strong>Options<\/strong> page.<\/li>\n<\/ul><ul class=\"wp-block-list\">\n<li>Go to the State section, set the <strong>Database Read-Only<\/strong> property to True, and press <strong>OK<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/database-read-only.png\" alt=\"go to options page, and set Database Read-only State to True\" class=\"wp-image-119315 apply-gradient-on-post-images\" width=\"523\" height=\"506\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/database-read-only.png 697w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/database-read-only-300x290.png 300w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>If everything is fine, the database will be in the Read-Only state.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/database-read-only-status.png\" alt=\"database status set to read-only\" class=\"wp-image-119316 apply-gradient-on-post-images\" width=\"207\" height=\"113\"><\/figure>\n<\/div><p>Another way to set it to read-only mode is by using the following T-SQL command:<\/p><p class=\"has-background\" style=\"background-color:#d5d5d5\">USE [master]<br>GO<br>ALTER DATABASE [AdventureWorks2019] SET READ_ONLY WITH NO_WAIT<br>GO<\/p><p>The read-only option allows to read the database and avoid writing data (insert, update, alter, drop, and create operations). This option allows taking a hot backup without worrying about changes in the database. The main problem is that you cannot insert, update, and delete data in this mode.<\/p><h3 class=\"wp-block-heading\">Hot Backup Limitations<\/h3><p>If you do a SQL Server hot backup with the multi-user mode and the database is not in read-only mode, you can face some limitations, such as:<\/p><ul class=\"wp-block-list\">\n<li>You can only back up online data.<\/li>\n\n\n\n<li>You can make INSERT, UPDATE, and DELETE operations during a hot backup.<\/li>\n\n\n\n<li>If you are removing or adding a data file to the database during the backup, it waits for the completion of process.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"how-to-repair-corrupted-cold-backup?\">How to Repair Corrupted Cold Backup?<\/h2><p>Sometimes, the data files get corrupted due to some problems and you cannot do a cold backup. To check if your data file is corrupted, you can use the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/database-console-commands\/dbcc-checkdb-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">DBCC CHECKDB<\/a> command and verify that everything is fine.<\/p><p>If the data file is severely corrupted, you can use <a href=\"https:\/\/www.stellarinfo.com\/sql-recovery.php\" target=\"_blank\" rel=\"noreferrer noopener\">Stellar Repair for MS SQL<\/a>. This software will repair your data file and recover all the data.<\/p><h2 class=\"wp-block-heading\" id=\"how-to-repair-corrupted-hot-backup?\">How to Repair Corrupted Hot Backup?<\/h2><p>To verify if your hot backup is corrupted, you can use the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/statements\/restore-statements-verifyonly-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">RESTORE command with the verify only<\/a> option.<\/p><p>If the hot backup is corrupted, you can use Stellar Toolkit for MS SQL to recover your database.<\/p><h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2><p>In SQL Server, it is possible to do a cold backup or a hot backup. To freeze the operations during the backup process, you could restrict access to the database by using the restricted user mode, single-user mode, or read-only mode. Usually, you take a hot backup and later take the differential and transactional backups for missing operations. You should check the backup restrictions to make sure you are not breaking them during hot backup.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server offers options to take cold back and hot backup. Below,&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/\">Continue reading <span class=\"screen-reader-text\">SQL Server Hot Backup<\/span><\/a><\/p>\n","protected":false},"author":85,"featured_media":121506,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10],"tags":[4360,4245],"class_list":["post-119300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-recovery","tag-sql-server-cold-backup","tag-sql-server-hot-backup","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server Hot Backup | Stellar<\/title>\n<meta name=\"description\" content=\"What is a hot backup and a cold backup? What are their advantages and disadvantages. Here are some tips related to how to use them.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Hot Backup | Stellar\" \/>\n<meta property=\"og:description\" content=\"What is a hot backup and a cold backup? What are their advantages and disadvantages. Here are some tips related to how to use them.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-04T11:43:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-14T04:24:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/SQL-Server-Hot-Backup.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Bharat Bhushan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bharat Bhushan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/\"},\"author\":{\"name\":\"Bharat Bhushan\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a\"},\"headline\":\"SQL Server Hot Backup\",\"datePublished\":\"2023-01-04T11:43:54+00:00\",\"dateModified\":\"2023-02-14T04:24:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/\"},\"wordCount\":916,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/SQL-Server-Hot-Backup.jpg\",\"keywords\":[\"sql server cold backup\",\"sql server hot backup\"],\"articleSection\":[\"SQL Database Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/\",\"name\":\"SQL Server Hot Backup | Stellar\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/SQL-Server-Hot-Backup.jpg\",\"datePublished\":\"2023-01-04T11:43:54+00:00\",\"dateModified\":\"2023-02-14T04:24:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a\"},\"description\":\"What is a hot backup and a cold backup? What are their advantages and disadvantages. Here are some tips related to how to use them.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/SQL-Server-Hot-Backup.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/SQL-Server-Hot-Backup.jpg\",\"width\":1000,\"height\":600,\"caption\":\"Image of SQL Server Hot Backup\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Hot Backup\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/\",\"name\":\"Stellar Data Recovery Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a\",\"name\":\"Bharat Bhushan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g\",\"caption\":\"Bharat Bhushan\"},\"description\":\"Bharat Bhushan is an experienced technical Marketer working at Stellar Data Recovery - expertise in data care. He is skilled in Microsoft Exchange Database, MSSQL Database troubleshooting &amp; data warehousing. He is a Management Post Graduate having a strong grip in Technology &amp; certified in SAP-SD, Oracle 10g &amp; Informatica Powercenter 9.1.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/bharat-bhushan-311956144\/\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/bharat\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Hot Backup | Stellar","description":"What is a hot backup and a cold backup? What are their advantages and disadvantages. Here are some tips related to how to use them.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Hot Backup | Stellar","og_description":"What is a hot backup and a cold backup? What are their advantages and disadvantages. Here are some tips related to how to use them.","og_url":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2023-01-04T11:43:54+00:00","article_modified_time":"2023-02-14T04:24:17+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/SQL-Server-Hot-Backup.jpg","type":"image\/jpeg"}],"author":"Bharat Bhushan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bharat Bhushan","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/"},"author":{"name":"Bharat Bhushan","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a"},"headline":"SQL Server Hot Backup","datePublished":"2023-01-04T11:43:54+00:00","dateModified":"2023-02-14T04:24:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/"},"wordCount":916,"commentCount":0,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/SQL-Server-Hot-Backup.jpg","keywords":["sql server cold backup","sql server hot backup"],"articleSection":["SQL Database Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/","url":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/","name":"SQL Server Hot Backup | Stellar","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/SQL-Server-Hot-Backup.jpg","datePublished":"2023-01-04T11:43:54+00:00","dateModified":"2023-02-14T04:24:17+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a"},"description":"What is a hot backup and a cold backup? What are their advantages and disadvantages. Here are some tips related to how to use them.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/SQL-Server-Hot-Backup.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/01\/SQL-Server-Hot-Backup.jpg","width":1000,"height":600,"caption":"Image of SQL Server Hot Backup"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-hot-backup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Hot Backup"}]},{"@type":"WebSite","@id":"https:\/\/www.stellarinfo.com\/blog\/#website","url":"https:\/\/www.stellarinfo.com\/blog\/","name":"Stellar Data Recovery Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a","name":"Bharat Bhushan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g","caption":"Bharat Bhushan"},"description":"Bharat Bhushan is an experienced technical Marketer working at Stellar Data Recovery - expertise in data care. He is skilled in Microsoft Exchange Database, MSSQL Database troubleshooting &amp; data warehousing. He is a Management Post Graduate having a strong grip in Technology &amp; certified in SAP-SD, Oracle 10g &amp; Informatica Powercenter 9.1.","sameAs":["https:\/\/www.linkedin.com\/in\/bharat-bhushan-311956144\/"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/bharat\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/119300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/users\/85"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=119300"}],"version-history":[{"count":10,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/119300\/revisions"}],"predecessor-version":[{"id":123919,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/119300\/revisions\/123919"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/121506"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=119300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=119300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=119300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}