{"id":9945,"date":"2019-03-01T06:56:28","date_gmt":"2019-03-01T06:56:28","guid":{"rendered":"https:\/\/dbtut.com\/?p=9945"},"modified":"2019-03-02T09:34:36","modified_gmt":"2019-03-02T09:34:36","slug":"restore-master-database-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/","title":{"rendered":"Restore master database in SQL Server"},"content":{"rendered":"<p>master database is a database that keeps all the information at the system level in an instance. For example, logins, endpoints, linked servers, system configuration settings.<\/p>\n<p>Therefore, without a master database, a sql server instance does not work. Therefore, you should regularly back up the master database and other system databases. You can get detailed information about system databases in my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/08\/sql-server-system-databases\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server System Databases<\/a>&#8221;<\/p>\n<h3>So how do we restore the master database when it is corrupted?<\/h3>\n<p>The need to restore the master database usually begins with the failure to open the sql server service as a result of a corruption in the master database. When you want to start the SQL Server service from SQL Server Configuration Manager, you will see an error as follows.<\/p>\n<p>In the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/23\/sql-server-configuration-manager-settings\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Configuration Manager Settings<\/a>&#8220;, you can access the article that explains the settings that can be made through Configuration Manager.<\/p>\n<p>Do not panic. This error does not always mean that your database is corrupted. Your problem may not be corruption. This error only says that the service is not responding and we need to look at the event log.<\/p>\n<p><span style=\"color: #ff0000;\"><em>The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.<\/em><\/span><\/p>\n<p id=\"ifxUYIY\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9947  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png\" alt=\"\" width=\"467\" height=\"209\" \/><\/p>\n<p>In Windows Search, we open the Event viewer as follows.<\/p>\n<p id=\"ySltQah\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9949  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ceaf5fc2b.png\" alt=\"\" width=\"406\" height=\"446\" \/><\/p>\n<p>You can see the related error on the right side after clicking on Application under the windows logs as below. In my example, the log file of the master database has been deleted. Therefore, the sql server service cannot start because it cannot find the log file of the master database.<\/p>\n<p><span style=\"color: #ff0000;\"><em>FCB::Open failed: Could not open file C:\\Program Files\\Microsoft SQL Server\\MSSQL12.TESTINSTANCE\\MSSQL\\DATA\\mastlog.ldf for file number 2.\u00a0 OS error: 2(The system cannot find the path specified.)<\/em><\/span><\/p>\n<p id=\"CukUYlr\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9951  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ceda9a05d.png\" alt=\"\" width=\"716\" height=\"279\" \/><\/p>\n<p>You cannot start the sql server service without a master database.<\/p>\n<p>First of all, you can start instance in single user mode and try to restore the master database from the cmd command line.<\/p>\n<p>If you cannot succeed, you can restore the master database to another instance in the same version and copy the files.<\/p>\n<p>Or you can try the third way, which is a longer but definitive solution. Rebuild system databases.<\/p>\n<p>Before performing Rebuild system databases, make sure that you have the latest backup of the master, model and msdb databases. Because when you rebuild your system databases, everything will be reset. Then we need to restore not only the master database, also the model and msdb databases. To rebuild the system databases, you can use the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/03\/02\/rebuild-system-databases-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Rebuild System Databases in SQL Server<\/a>&#8220;.<\/p>\n<p>After reboot, right-click on the relevant instance in SQL Server Configuration Manager, click Properties, and add -m parameter as below by clicking Add. After then stop the service.<\/p>\n<p id=\"BdqZrtu\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9953  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78cf08615b1.png\" alt=\"\" width=\"563\" height=\"287\" \/><\/p>\n<p>Then we write cmd in windows search and run it as an administrator.<\/p>\n<p id=\"WskkUJz\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9955  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78cf1e612b9.png\" alt=\"\" width=\"382\" height=\"411\" \/><\/p>\n<p>And start the sql server service as follows. You must write your own instance name instead of TESTINSTANCE.<\/p>\n<pre class=\"lang:default decode:true \">NET START MSSQL$TESTINSTANCE<\/pre>\n<p id=\"GlypMQj\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9958  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78cf3b4b925.png\" alt=\"\" width=\"486\" height=\"37\" \/><\/p>\n<p>After you start the service, if your instance is default instance, you should just type sqlcmd and press enter.<\/p>\n<p>If you are going to connect to the named instance, you must type;<\/p>\n<pre class=\"lang:default decode:true\">sqlcmd -S servername\\instancename<\/pre>\n<p>or<\/p>\n<pre class=\"lang:default decode:true\">sqlcmd -S .\\instancename<\/pre>\n<p>Of course, in the above script, you should write the name of your own server instead of servername, and the name of your own instance instead of instancename.<\/p>\n<p>I performed this process for the instance named TESTINSTANCE in the screenshot below. This is an important step. You should not connect to the wrong Instance.<\/p>\n<p id=\"nMZTEOO\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9960  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78cf8596f11.png\" alt=\"\" width=\"458\" height=\"29\" \/><\/p>\n<p><strong>Restore master;<\/strong><\/p>\n<p>Then we start the restoration process. We perform the restore with the following command. Instead of &#8220;C:\\MSSQL&#8221;, you should write the path where your backup is located.<\/p>\n<pre class=\"lang:default decode:true \">RESTORE DATABASE master FROM DISK = 'C:\\MSSQL\\master.bak' WITH REPLACE;<\/pre>\n<p id=\"JXqAGWp\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9962  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78cfb1b7d3f.png\" alt=\"\" width=\"641\" height=\"159\" \/><\/p>\n<p>SQL Server automatically stopped the service when the restore was finished. We need to go to Configuration Manager and remove the -m parameter that we added earlier.<\/p>\n<p>When you connect to the instance after the Restore process, you will see your old databases and login. If you rebuild the master database before you restore it, you will not be able to see your jobs. In such a case, you must restore the msdb database.<\/p>\n<p>You can perform the restore operations of the msdb and model database as normal database restore. There is no extra setting. But, to restore the msdb database, you must stop the SQL Server Agent Service from SQL Server Configuration Manager.<\/p>\n<p>You can find the restore scripts of msdb and model system databases below.<\/p>\n<p><strong>Restore model;<\/strong><\/p>\n<pre class=\"lang:default decode:true\">RESTORE DATABASE model FROM DISK = 'C:\\MSSQL\\model_backup.bak' WITH REPLACE;<\/pre>\n<p><strong>Restore msdb;<\/strong><\/p>\n<pre class=\"lang:default decode:true \">RESTORE DATABASE msdb FROM DISK = 'C:\\MSSQL\\msdb_backup.bak' WITH REPLACE;<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9945\" class=\"pvc_stats all  \" data-element-id=\"9945\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>master database is a database that keeps all the information at the system level in an instance. For example, logins, endpoints, linked servers, system configuration settings. Therefore, without a master database, a sql server instance does not work. Therefore, you should regularly back up the master database and other system databases. You can get detailed &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9945\" class=\"pvc_stats all  \" data-element-id=\"9945\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[2255,2253,2257,2249,2250,2251,2252,2258,2256,2254],"class_list":["post-9945","post","type-post","status-publish","format-standard","","category-mssql","tag-fcbopen-failed-could-not-open-file","tag-master-database-corrupted","tag-net-start","tag-restore-master","tag-restore-model","tag-restore-msdb","tag-restore-system-databases","tag-sqlcmd","tag-start-sql-server-from-cmd-command-prompt","tag-the-system-cannot-find-the-path-specified"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Restore master database in SQL Server - Database Tutorials<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Restore master database in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"master database is a database that keeps all the information at the system level in an instance. For example, logins, endpoints, linked servers, system configuration settings. Therefore, without a master database, a sql server instance does not work. Therefore, you should regularly back up the master database and other system databases. You can get detailed &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-01T06:56:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-02T09:34:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Restore master database in SQL Server\",\"datePublished\":\"2019-03-01T06:56:28+00:00\",\"dateModified\":\"2019-03-02T09:34:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/\"},\"wordCount\":757,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png\",\"keywords\":[\"FCB::Open failed: Could not open file\",\"master database corrupted\",\"NET START\",\"restore master\",\"restore model\",\"restore msdb\",\"restore system databases\",\"sqlcmd\",\"start sql server from cmd command prompt\",\"The system cannot find the path specified\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/\",\"name\":\"Restore master database in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png\",\"datePublished\":\"2019-03-01T06:56:28+00:00\",\"dateModified\":\"2019-03-02T09:34:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png\",\"width\":696,\"height\":311},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Restore master database in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Restore master database in SQL Server - Database Tutorials","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:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Restore master database in SQL Server - Database Tutorials","og_description":"master database is a database that keeps all the information at the system level in an instance. For example, logins, endpoints, linked servers, system configuration settings. Therefore, without a master database, a sql server instance does not work. Therefore, you should regularly back up the master database and other system databases. You can get detailed &hellip;","og_url":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-03-01T06:56:28+00:00","article_modified_time":"2019-03-02T09:34:36+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Restore master database in SQL Server","datePublished":"2019-03-01T06:56:28+00:00","dateModified":"2019-03-02T09:34:36+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/"},"wordCount":757,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png","keywords":["FCB::Open failed: Could not open file","master database corrupted","NET START","restore master","restore model","restore msdb","restore system databases","sqlcmd","start sql server from cmd command prompt","The system cannot find the path specified"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/","name":"Restore master database in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png","datePublished":"2019-03-01T06:56:28+00:00","dateModified":"2019-03-02T09:34:36+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78ce932e09e.png","width":696,"height":311},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/restore-master-database-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Restore master database in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9945"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9945\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}