{"id":1736,"date":"2016-04-20T20:39:22","date_gmt":"2016-04-21T01:39:22","guid":{"rendered":"http:\/\/swildow.darktech.org\/wp\/?p=1736"},"modified":"2016-04-20T20:39:22","modified_gmt":"2016-04-21T01:39:22","slug":"sql-backup","status":"publish","type":"post","link":"http:\/\/www.wildow.com\/blog\/?p=1736","title":{"rendered":"SQL backup"},"content":{"rendered":"<p>For details on how to use Windows Server Backup\u00a0for application level recovery\u00a0please look at the article\u00a0<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/cc725726.aspx\">http:\/\/technet.microsoft.com\/en-us\/library\/cc725726.aspx<\/a><\/p>\n<p>Note:<br \/>\n1. The application needs to be registered with Windows Server Backup\u00a0for showing it as a recoverable\u00a0item in the recovery\u00a0wizard. Please see details on how to register any application @<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/cc307260(VS.85).aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/cc307260(VS.85).aspx<\/a>\u00a0If you&#8217;ve Backup plugin installed this may already be done for you.<br \/>\n2. You should select\u00a0full application volumes for backup.<\/p>\n<p>Please share\u00a0the outcome after trying out above steps.<\/p>\n<p>&nbsp;<\/p>\n<p>Please confirm if\u00a0you tried recovering application using the steps given @<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/cc725726.aspx\">http:\/\/technet.microsoft.com\/en-us\/library\/cc725726.aspx<\/a>. Are you able to see SQL as recoverable application?<\/p>\n<p>Let me explain\u00a0Backup application behaviour:<br \/>\n1. Backup application uses VSS snapshot to get the consistent copy of the source volumes selected in the backup. In most backup applications,\u00a0this will involve all the writers for that volume.<br \/>\n2. Most applications (like SQL) logs that there writer has been involved and the backup snap was created.<br \/>\n3. It&#8217;s upto the backup application to copy the files reported by the application writer.<br \/>\nSo you may see application log that backup snap has been created for that application, but the backup may not have copied\u00a0those files at all.<\/p>\n<p>Please try to backup the full volumes where your SQL application resides and the retry application recovery flow and update your results.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For details on how to use Windows Server Backup\u00a0for application level recovery\u00a0please look at the article\u00a0http:\/\/technet.microsoft.com\/en-us\/library\/cc725726.aspx Note: 1. The application needs to be registered with Windows Server Backup\u00a0for showing it as a recoverable\u00a0item in the recovery\u00a0wizard. Please see details on &#8230; <a class=\"more-link\" href=\"http:\/\/www.wildow.com\/blog\/?p=1736\">Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1736","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1736","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1736"}],"version-history":[{"count":1,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1736\/revisions"}],"predecessor-version":[{"id":1737,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1736\/revisions\/1737"}],"wp:attachment":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1736"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}