{"id":213,"date":"2017-09-28T08:22:14","date_gmt":"2017-09-28T08:22:14","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=213"},"modified":"2017-09-28T08:22:14","modified_gmt":"2017-09-28T08:22:14","slug":"sql-bak-explorer-2-0-released","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2017\/09\/28\/sql-bak-explorer-2-0-released\/","title":{"rendered":"SQL BAK Explorer 2.0 released"},"content":{"rendered":"<p>We just released SQL BAK Explorer 2.0 today, and the significant addition is that of a Query Window.<\/p>\n<p>As some of you may know, SQL BAK Explorer stores backup details of the files it reads in a SQL Server Compact database.\u00a0 There are 5 tables used to store the details i.e.<\/p>\n<ul>\n<li>backupset<\/li>\n<li>backupmediaset<\/li>\n<li>backupmediafamily<\/li>\n<li>backupfile<\/li>\n<li>backupfilegroup<\/li>\n<\/ul>\n<p>The structure of these tables are similar to the same tables found in the msdb database, so if you&#8217;ve ever queried for backup details in msdb, you&#8217;ll feel right at home here.<\/p>\n<p>So in the Query Window, you simply enter a query to retrieve the backup details you want e.g.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-216\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/query-1.png\" alt=\"\" width=\"789\" height=\"566\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/query-1.png 789w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/query-1-300x215.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/query-1-768x551.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/query-1-150x108.png 150w\" sizes=\"(max-width: 789px) 100vw, 789px\" \/><\/p>\n<p>If you want to return multiple result sets, end each query with a semi-colon, and start each query on a new line e.g.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-215\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/09\/multiquery.gif\" alt=\"\" width=\"789\" height=\"566\" \/><\/p>\n<p>The SQL syntax for SQL Server Compact is fairly similar to the SQL Server syntax, so if you are already familiar with SQL Server query syntax, writing for SQL Server Compact should be easy.<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2017\/09\/28\/sql-bak-explorer-2-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\/28\/sql-bak-explorer-2-0-released\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>We just released SQL BAK Explorer 2.0 today, and the significant addition is that of a Query Window. As some of you may know, SQL BAK Explorer stores backup details of the files it reads in a SQL Server Compact database.\u00a0 There are 5 tables used to store the details i.e. backupset backupmediaset backupmediafamily backupfile [&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],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/213"}],"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=213"}],"version-history":[{"count":1,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/213\/revisions"}],"predecessor-version":[{"id":217,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/213\/revisions\/217"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}