{"id":204,"date":"2017-09-19T14:03:28","date_gmt":"2017-09-19T14:03:28","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=204"},"modified":"2017-09-19T14:03:28","modified_gmt":"2017-09-19T14:03:28","slug":"sql-bak-explorer-1-0-released","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2017\/09\/19\/sql-bak-explorer-1-0-released\/","title":{"rendered":"SQL BAK Explorer 1.0 released"},"content":{"rendered":"<p>We just released SQL BAK Explorer, which is a useful tool to work with SQL Server backup files. \u00a0Basically, it can read the backup details off the backup files without requiring SQL Server. \u00a0The details it can provide are almost similar to what you can retrieve using the RESTORE HEADERONLY and RESTORE FILELISTONLY commands. \u00a0It supports backup files created using SQL Server 2005 up to SQL Server 2017. \u00a0However, it doesn&#8217;t support encrypted backup files.<\/p>\n<p style=\"padding-left: 30px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-208\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/details.png\" alt=\"\" width=\"827\" height=\"734\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/details.png 827w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/details-300x266.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/details-768x682.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/details-150x133.png 150w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/p>\n<p>Beyond just listing out the backup details, you can also view the details of multiple backup files simultaneously, in a summary window. \u00a0This makes it easy to compare backup set details.<\/p>\n<p style=\"padding-left: 30px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-207\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/backupsets.png\" alt=\"\" width=\"832\" height=\"589\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/backupsets.png 832w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/backupsets-300x212.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/backupsets-768x544.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/backupsets-150x106.png 150w\" sizes=\"(max-width: 832px) 100vw, 832px\" \/><\/p>\n<p>Since we already have the backup details, SQL BAK Explorer can also generate the restore script for you. \u00a0The restore script for a full database backup will include the MOVETO options, so that you can easily move the database files around. \u00a0Hints are also provided on how much disk space is required.<\/p>\n<p style=\"padding-left: 30px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-209\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/restore-sql.png\" alt=\"\" width=\"568\" height=\"600\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/restore-sql.png 568w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/restore-sql-284x300.png 284w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/restore-sql-142x150.png 142w\" sizes=\"(max-width: 568px) 100vw, 568px\" \/><\/p>\n<p>Each time a backup file is read, SQL BAK Explorer stores the backup details in a local database. \u00a0The next time the same file is selected, the details are read from the database instead of re-reading the file again. \u00a0This allows the backup details to be displayed very fast. \u00a0In addition, SQL BAK Explorer can search this database for files making up a complete backup media set, when generating the restore script for a backup that has been split across multiple files.<\/p>\n<p style=\"padding-left: 30px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-210\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/split.png\" alt=\"\" width=\"863\" height=\"515\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/split.png 863w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/split-300x179.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/split-768x458.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/split-150x90.png 150w\" sizes=\"(max-width: 863px) 100vw, 863px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>If there is anything you would like to see added to SQL BAK Explorer, please do drop us a line at <a href=\"mailto:\/\/support@yohz.com\">support@yohz.com<\/a>.<\/p>\n<p><a href=\"http:\/\/www.yohz.com\/downloads\/sqlbakexplorer\/SQLBAKExplorerSetup.zip\">Download<\/a> the free 14-day trial now, or learn more about <a href=\"http:\/\/www.yohz.com\/sbex_details.htm\">SQL BAK Explorer<\/a>.<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2017\/09\/19\/sql-bak-explorer-1-0-released\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2017\/09\/19\/sql-bak-explorer-1-0-released\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>We just released SQL BAK Explorer, which is a useful tool to work with SQL Server backup files. \u00a0Basically, it can read the backup details off the backup files without requiring SQL Server. \u00a0The details it can provide are almost similar to what you can retrieve using the RESTORE HEADERONLY and RESTORE FILELISTONLY commands. \u00a0It [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[33],"tags":[34,36,35],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/204"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=204"}],"version-history":[{"count":3,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/204\/revisions"}],"predecessor-version":[{"id":211,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/204\/revisions\/211"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}