{"id":253,"date":"2011-03-09T01:04:29","date_gmt":"2011-03-09T01:04:29","guid":{"rendered":"http:\/\/support.cybersecure.com\/?p=253"},"modified":"2011-03-22T00:02:23","modified_gmt":"2011-03-22T00:02:23","slug":"253","status":"publish","type":"post","link":"http:\/\/support.cybersecure.com\/?p=253","title":{"rendered":"Cannot open backup device"},"content":{"rendered":"<h2>Error:<\/h2>\n<p>[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device &#8216;Temporary_Directory\\Server\\Backup_ID\\Database\\File&#8217;. Device error or device off-line. See the SQL Server error log for more details.<br \/>\n&#8230;&#8230;<br \/>\nMicrosoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally.<\/p>\n<h2>Cause:<\/h2>\n<p>The message suggests that MS SQL cannot access the designated temporary directory.<\/p>\n<h2>Resolution:<\/h2>\n<p>Check the permissions for temporary directory. Make sure the CyberSecure temporary directory has complete Read\/Write permissions.<\/p>\n<p>If the temporary directory is on a network location, ALWAYS use the UNC path instead to mapped drive letter and ensure that the &#8220;Network Resources Authentication for Windows&#8221; configuration section has been completed in the CyberSecure settings.<\/p>\n<p>If the same errors are still present, please verify if the &#8220;Log on&#8221; account of the MS SQL Server (MSSQLSERVER) service has sufficient permission right(s) to access the designated temporary directory. You can do so by following the instructions below:<\/p>\n<ol>\n<li>Open [Control Panel] -&gt; [Administrative Tools] -&gt; [Services] -&gt; [SQL Server (MSSQLSERVER)] -&gt; [Log on]<\/li>\n<li>Select the [This Account] option<\/li>\n<li>Enter the Login Credentials<\/li>\n<li>Restart the [SQL Server (MSSQLSERVER)] service.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device &#8216;Temporary_Directory\\Server\\Backup_ID\\Database\\File&#8217;. Device error or device off-line. See the SQL Server error log for more details. &#8230;&#8230; Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally. Cause: The message suggests that MS &hellip; <a href=\"http:\/\/support.cybersecure.com\/?p=253\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[],"_links":{"self":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/253"}],"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\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=253"}],"version-history":[{"count":8,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/253\/revisions"}],"predecessor-version":[{"id":255,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/253\/revisions\/255"}],"wp:attachment":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=253"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}