{"id":256,"date":"2018-01-23T16:35:06","date_gmt":"2018-01-23T11:05:06","guid":{"rendered":"https:\/\/www.websupporters.com\/support\/knowledgebase\/?post_type=ht_kb&p=256"},"modified":"2018-01-23T16:35:06","modified_gmt":"2018-01-23T11:05:06","slug":"how-to-restore-a-microsoft-sql-database-backup-using-sql-server-management-studio","status":"publish","type":"ht_kb","link":"https:\/\/www.websupporters.com\/support\/knowledgebase\/kb\/how-to-restore-a-microsoft-sql-database-backup-using-sql-server-management-studio\/","title":{"rendered":"How To Restore a Microsoft SQL Database Backup Using SQL Server Management Studio?"},"content":{"rendered":"

If you downloaded the mssql\u00a0database backup from Plesk Control panel and you want to Restore a Microsoft SQL Database Backup Using SQL Server Management Studio<\/p>\n

To Restore a Microsoft SQL Database Backup Using SQL Server Management Studio.<\/h2>\n
    \n
  1. Open SQL Server Management Studio and Connect to the SQL Server you want to restore the database to.
    \n\"\"<\/a><\/li>\n
  2. Once you Connected to the SQL server, right click on the Databases folder and select \u2018Restore Database\u2019.
    \n    \"\"<\/a><\/li>\n
  3. First Select\u00a0From Device<\/strong> then Click the ellipses button<\/strong> next to From device<\/strong> under the Source for restore<\/strong> section.
    \n    \"\"<\/a><\/li>\n
  4. Set File<\/strong> as the backup media and then click Add.
    \n    \"\"<\/a>
    \n<\/strong><\/li>\n
  5. Browse to the SQL backup (.BAK) file you want to restore and Click Ok<\/strong>.
    \n    \"\"<\/a><\/li>\n
  6. Then Click Ok<\/strong>.
    \n    \"\"<\/a><\/li>\n
  7. In the Restore Database dialog, type or select the name of the database you want this backup restored to.\n
      \n
    1. If you select an existing database, it will be replaced with the data from the backup.<\/li>\n
    2. If you type a database name which does not currently exist in your SQL Server installation, it will be created.<\/li>\n<\/ol>\n<\/li>\n
    3. Next, select the restore point you want to use. Since a SQL backup file can hold multiple backups you may see more than one restore point listed.
      \n      \"\"<\/a><\/li>\n
    4. Click OK<\/strong>. You will get database successful restore Message.
      \n      \"\"<\/a><\/li>\n
    5. Once your restore options are set, click Ok.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      If you downloaded the mssql\u00a0database backup from Plesk Control panel and you want to Restore a Microsoft SQL Database Backup Using SQL Server Management Studio To Restore a Microsoft SQL Database Backup Using SQL Server Management Studio. Open SQL Server Management Studio and Connect to the SQL Server you want…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[3],"ht-kb-tag":[],"class_list":["post-256","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-windows-hosting"],"_links":{"self":[{"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/comments?post=256"}],"version-history":[{"count":0,"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/256\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/media?parent=256"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-category?post=256"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-tag?post=256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}