{"id":5042,"date":"2020-04-21T18:04:46","date_gmt":"2020-04-21T22:04:46","guid":{"rendered":"https:\/\/www.globo.tech\/learning-center\/?p=5042"},"modified":"2020-04-21T18:04:46","modified_gmt":"2020-04-21T22:04:46","slug":"how-to-backup-and-restore-mssql-database","status":"publish","type":"post","link":"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/","title":{"rendered":"How to Backup and Restore MSSQL Database"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"628\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/backup-restore-mssql-database.jpg\" alt=\"How to backup and restore MsSQL database\" class=\"wp-image-5043\"\/><\/figure>\n\n\n\n<p>Backing up your SQL Server databases regularly is a good practice for any database administrator to prevent data loss or corruption. Backing up is the only way to protect and recover your data from many failures including, Media failure, Hardware failures, User errors and many more.<\/p>\n\n\n\n<p>Moreover, a database backup is also useful for day-to-day administrative tasks such as, database mirroring, archiving and copying a database from one server to another.<\/p>\n\n\n\n<p>MSSQL is the most widely used database management system for Windows-based <a href=\"https:\/\/www.globo.tech\/dedicated-server-hosting\">systems<\/a> developed and marketed by Microsoft. It is used to store website data like, blog and user information.<\/p>\n\n\n\n<p>In this tutorial, we will show you how to backup and restore the MSSQL database on Windows operating <a href=\"https:\/\/www.globo.tech\/cloud-server-pricing\">system<\/a>.<\/p>\n\n\n\n<p><strong>Prerequisites<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>A server running Windows server 2016.<\/li><li>SQL Server and SQL Server Management Studio (SSMS) installed in your system.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Create a New Database<\/h2>\n\n\n\n<p>First, we will create a new <a href=\"https:\/\/en.wikipedia.org\/wiki\/Database\">database<\/a> using the SQL Server Management Studio (SSMS) for testing purposes.<\/p>\n\n\n\n<p><strong>Follow the below steps to create a new database:<\/strong><\/p>\n\n\n\n<p><strong>Step 1 &#8211;<\/strong> Open SQL Server Management Studio (SSMS) from the Start menu as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-login.png\" alt=\"MsSQL Management Studio - Login prompt.\" class=\"wp-image-5044\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 2 &#8211;<\/strong> Click on the <strong>connect<\/strong> button to connect with your <a href=\"https:\/\/en.wikipedia.org\/wiki\/Microsoft_SQL_Server\">MSSQL<\/a> Server instance. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-Home.png\" alt=\"MsSQL Management Studio - Home.\" class=\"wp-image-5045\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 3 &#8211;<\/strong> Click on the New Query button to open a new Query window as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-NewQuery.png\" alt=\"MsSQL Management Studio - New query.\" class=\"wp-image-5046\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 4 &#8211;<\/strong> Type the following query in the above query window to create a new database named TESTDB and create a new table named TABLE1:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">USE [master]\nGO\nCREATE DATABASE [TESTDB]\nGO\nUSE [TESTDB]\nGO\nCREATE TABLE TABLE1 (\nID INT NOT NULL PRIMARY KEY,\na1 VARCHAR(100) NOT NULL,\ndt1 DATETIME NOT NULL DEFAULT getdate()\n)\nGO<\/pre>\n\n\n\n<p>Next, click on the <strong>Execute<\/strong> button to run the query. Once the query has been executed successfully, you should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-Execute-Query.png\" alt=\"MsSQL Management Studio - Execure query.\" class=\"wp-image-5047\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Take a Backup with SSMS<\/h2>\n\n\n\n<p>In this section, we will learn how to take a backup of a database named TESTDB using the Microsoft SQL Server Management Studio (SSMS).<\/p>\n\n\n\n<p><strong>Follow the below steps to back up the TESTDB database:<\/strong><\/p>\n\n\n\n<p><strong>Step 1 &#8211;<\/strong> Launch the MSSQL Server Management Studio (SSMS) and expand the Databases as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-Expend-databases.png\" alt=\"MsSQL Management Studio - Expend databases.\" class=\"wp-image-5048\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 2 &#8211;<\/strong> Right-click on the <strong>TESTDB<\/strong> and click on the <strong>Tasks<\/strong> => <strong>Back<\/strong> <strong>Up<\/strong>. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-Backup-database.png\" alt=\"MsSQL Management Studio - Select databases, right click and select &quot;back up&quot;.\" class=\"wp-image-5049\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 3 &#8211;<\/strong> Select all required information like, Database, Backup type, Backup path and click on the <strong>OK<\/strong> button. Once the backup has been created successfully, you should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-Backup-database-2.png\" alt=\"Select  all required informations and then click &quot;OK&quot; to schedule the backup.\" class=\"wp-image-5050\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 4 &#8211;<\/strong> If the backup is successfull, you get the confirmation message &#8220;The backup of database &#8220;DBTEST&#8221; completed successfully, as follow:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-Backup-database-successfull.png\" alt=\"Database backup successfully completed confirmation pop-up.\" class=\"wp-image-5051\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Take a Backup with Transact-SQL<\/h2>\n\n\n\n<p>You can also take a backup of your database with Transact-SQL command from the query window.<\/p>\n\n\n\n<p><strong>Follow the below steps to backup your TESTDB database with Transact-SQL command:<\/strong><\/p>\n\n\n\n<p><strong>Step 1 &#8211;<\/strong> Launch the Microsoft SQL Server Management Studio (SSMS).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-Home2.png\" alt=\"SSMS Home.\" class=\"wp-image-5052\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 2 &#8211;<\/strong> Click on the <strong>New<\/strong> <strong>Query<\/strong> button to open a new Query window as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-NewQuery2.png\" alt=\"SSMS - New Query.\" class=\"wp-image-5053\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 3 &#8211;<\/strong> Type the following query in the above query window to take a backup of TESTDB database:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">BACKUP DATABASE [TESTDB]\nTO DISK = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL14.MSSQLSERVER\\MSSQL\\Backup\\TESTDB.bak'\nWITH NOFORMAT, NOINIT,\nNAME = N'TestDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10\nGO<\/pre>\n\n\n\n<p><strong>Step 4 &#8211;<\/strong> Click on the <strong>Execute<\/strong> button to create a backup.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Restore a Backup<\/h2>\n\n\n\n<p>You can also restore a backup using the SQL Server Management Studio (SSMS).<\/p>\n\n\n\n<p><strong>Follow the below steps to restore your database named TESTDB:<\/strong><\/p>\n\n\n\n<p><strong>Step 1 &#8211;<\/strong> Launch the SQL Server Management Studio (SSMS).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-restore-DB.png\" alt=\"SSMS - Select a DB and right click to Tasks, Restore and Database.\" class=\"wp-image-5054\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 2 &#8211;<\/strong> Right-click on the <strong>TESTDB<\/strong> and click on the <strong>Tasks<\/strong> => <strong>Restore<\/strong> => <strong>Database<\/strong>. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-restore-DB2.png\" alt=\"SSMS - Select Device, and then click on &quot;...&quot; to browse hour devices.\" class=\"wp-image-5055\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 3 &#8211;<\/strong> Select Device and click on the &#8220;<strong>&#8230;<\/strong>&#8220;. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-restore-DB3.png\" alt=\"SSMS - Select &quot;backup media type&quot; to file and then click &quot;Add&quot;.\" class=\"wp-image-5056\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 4 &#8211;<\/strong> Click on the <strong>Add<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-restore-DB4.png\" alt=\"SSMS - Browse your files and then choose your database dump file that you want to restore and then click &quot;OK&quot;.\" class=\"wp-image-5057\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 5 &#8211;<\/strong> Select your database backup file and click on the <strong>OK<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-restore-DB5.png\" alt=\"SSMS - On the next window, click on &quot;OK&quot; once your finished to add all databases dump file.\" class=\"wp-image-5058\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 6 &#8211;<\/strong> Click on the <strong>OK<\/strong> button again to close the &#8220;Select backup devices window&#8221;. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-restore-DB6.png\" alt=\"SSMS - On the next window, check the databses you want to restore and then click &quot;OK&quot;.\" class=\"wp-image-5059\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<p><strong>Step 7 &#8211;<\/strong> Next, click on the <strong>OK<\/strong> button to restore the backup of your database. Once the backup completed successfully, you should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/MsSQL-Management-Studio-restore-DB7.png\" alt=\"SSMS - Once the databases are successfully restore you'll get the confirmation message &quot;Database TESTDB restored successfully&quot;.\" class=\"wp-image-5060\" width=\"683\" height=\"384\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>In this guide, you learned how to backup and restore the MSSQL database in Windows server 2016. I hope this will help you to recover data in case of data corruption issue.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Microsoft SQL is a popular databases engine from Microsoft to run on Windows Servers operating system. Learn how to Backup and Restore MSSQL Database.<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":3,"featured_media":5043,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61],"tags":[161,173,172,174],"class_list":["post-5042","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","tag-database","tag-microsoft","tag-mssql","tag-windows-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Backup and Restore MSSQL Database - Globo.Tech<\/title>\n<meta name=\"description\" content=\"Microsoft SQL is a popular databases engine from Microsoft to run on Windows Servers operating system. Learn how to Backup and Restore MSSQL Database.\" \/>\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.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Backup and Restore MSSQL Database - Globo.Tech\" \/>\n<meta property=\"og:description\" content=\"Microsoft SQL is a popular databases engine from Microsoft to run on Windows Servers operating system. Learn how to Backup and Restore MSSQL Database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Globo.Tech\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-21T22:04:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/backup-restore-mssql-database.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"GloboTech Communications\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"GloboTech Communications\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/\",\"name\":\"How to Backup and Restore MSSQL Database - Globo.Tech\",\"isPartOf\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/backup-restore-mssql-database.jpg\",\"datePublished\":\"2020-04-21T22:04:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87\"},\"description\":\"Microsoft SQL is a popular databases engine from Microsoft to run on Windows Servers operating system. Learn how to Backup and Restore MSSQL Database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/#primaryimage\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/backup-restore-mssql-database.jpg\",\"contentUrl\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/backup-restore-mssql-database.jpg\",\"width\":1200,\"height\":628,\"caption\":\"How to backup and restore MSSQL Database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.globo.tech\/learning-center\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Backup and Restore MSSQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#website\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/\",\"name\":\"Globo.Tech\",\"description\":\"Welcome to the Official Globo.Tech Learning Center\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87\",\"name\":\"GloboTech Communications\",\"sameAs\":[\"http:\/\/www.gtcomm.net\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Backup and Restore MSSQL Database - Globo.Tech","description":"Microsoft SQL is a popular databases engine from Microsoft to run on Windows Servers operating system. Learn how to Backup and Restore MSSQL Database.","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.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/","og_locale":"en_US","og_type":"article","og_title":"How to Backup and Restore MSSQL Database - Globo.Tech","og_description":"Microsoft SQL is a popular databases engine from Microsoft to run on Windows Servers operating system. Learn how to Backup and Restore MSSQL Database.","og_url":"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/","og_site_name":"Globo.Tech","article_published_time":"2020-04-21T22:04:46+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/backup-restore-mssql-database.jpg","type":"image\/jpeg"}],"author":"GloboTech Communications","twitter_misc":{"Written by":"GloboTech Communications","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/","url":"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/","name":"How to Backup and Restore MSSQL Database - Globo.Tech","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/#primaryimage"},"image":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/backup-restore-mssql-database.jpg","datePublished":"2020-04-21T22:04:46+00:00","author":{"@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"description":"Microsoft SQL is a popular databases engine from Microsoft to run on Windows Servers operating system. Learn how to Backup and Restore MSSQL Database.","breadcrumb":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/#primaryimage","url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/backup-restore-mssql-database.jpg","contentUrl":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/04\/backup-restore-mssql-database.jpg","width":1200,"height":628,"caption":"How to backup and restore MSSQL Database"},{"@type":"BreadcrumbList","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-backup-and-restore-mssql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.globo.tech\/learning-center\/"},{"@type":"ListItem","position":2,"name":"How to Backup and Restore MSSQL Database"}]},{"@type":"WebSite","@id":"https:\/\/www.globo.tech\/learning-center\/#website","url":"https:\/\/www.globo.tech\/learning-center\/","name":"Globo.Tech","description":"Welcome to the Official Globo.Tech Learning Center","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87","name":"GloboTech Communications","sameAs":["http:\/\/www.gtcomm.net"]}]}},"_links":{"self":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/5042","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/comments?post=5042"}],"version-history":[{"count":2,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/5042\/revisions"}],"predecessor-version":[{"id":5062,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/5042\/revisions\/5062"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media\/5043"}],"wp:attachment":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media?parent=5042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/categories?post=5042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/tags?post=5042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}