{"id":1546,"date":"2012-11-22T17:27:49","date_gmt":"2012-11-22T06:27:49","guid":{"rendered":"http:\/\/support.cybersecure.com\/?p=1546"},"modified":"2020-04-25T10:52:03","modified_gmt":"2020-04-25T00:52:03","slug":"microsoft-sql-server-restore-guide-cybersecure-advanced","status":"publish","type":"post","link":"http:\/\/support.cybersecure.com\/?p=1546","title":{"rendered":"Microsoft SQL Server Restore Guide"},"content":{"rendered":"

Pre-requisites<\/h2>\n
    \n
  1. Ensure that the CyberSecure SQL backups have been successful<\/li>\n
  2. Install the latest version of CyberSecure Advanced from our support download page<\/a><\/li>\n
  3. Make sure you know the encryption password for the SQL backup set you wish restore<\/li>\n
  4. Ensure SQL Management Studio<\/a> is installed<\/li>\n<\/ol>\n

    How to restore a Microsoft SQL Server database<\/h2>\n
      \n
    1. Perform a normal file restore <\/a>of the MS-SQL backup set(s) to a temporary location – this will extract the SQL .BAK files ready to be loaded into SQL management studio.<\/li>\n
    2. Open SQL Server Management Studio.<\/li>\n
    3. Login to the database server using an appropriate administrator-level account<\/li>\n
    4. In the object explorer, right click on “Databases” and choose “Restore database…”
      \n      \"\"<\/a><\/li>\n
    5. Choose the radio button to restore from a device, then click the “…” to pop open the “Select backup devices” dialog
      \n      \"\"<\/a><\/li>\n
    6. Click Add to select the location of the restored backup files from the previous steps
      \n      \"\"<\/a><\/li>\n
    7. Locate the .BAK backup file to restore from
      \n      \"\"<\/a><\/li>\n
    8. Confirm that your selections are OK
      \n      \"\"<\/a><\/li>\n
    9. Review your restore parameters before proceeding
      \n      \"\"<\/a><\/li>\n
    10. In particular, on the options page you may want to overwrite the existing database
      \n      \"\"<\/a><\/li>\n
    11. When satisfied, click OK to proceed with the restore back into SQL server<\/li>\n
    12. The restore should complete successfully
      \n      \"\"<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      Pre-requisites Ensure that the CyberSecure SQL backups have been successful Install the latest version of CyberSecure Advanced from our support download page Make sure you know the encryption password for the SQL backup set you wish restore Ensure SQL Management … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/1546"}],"collection":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1546"}],"version-history":[{"count":12,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/1546\/revisions"}],"predecessor-version":[{"id":3919,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/1546\/revisions\/3919"}],"wp:attachment":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1546"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}