{"id":577,"date":"2021-02-19T09:00:39","date_gmt":"2021-02-19T08:00:39","guid":{"rendered":"http:\/\/www.server1.dk\/?p=577"},"modified":"2021-02-19T09:00:39","modified_gmt":"2021-02-19T08:00:39","slug":"microsoft-sql-get-latest-backup-time","status":"publish","type":"post","link":"http:\/\/www.server1.dk\/?p=577","title":{"rendered":"Microsoft SQL &#8211; Get latest backup time"},"content":{"rendered":"\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> SELECT  name ,\n            recovery_model_desc ,\n            state_desc ,\n            d AS 'Last Full Backup' ,\n            i AS 'Last Differential Backup' ,\n            l AS 'Last log Backup'\n    FROM    ( SELECT    db.name ,\n                        db.state_desc ,\n                        db.recovery_model_desc ,\n                        type ,\n                        backup_finish_date\n              FROM      master.sys.databases db\n                        LEFT OUTER JOIN msdb.dbo.backupset a ON a.database_name = db.name\n            ) AS Sourcetable \n        PIVOT \n            ( MAX(backup_finish_date) FOR type IN ( D, I, L ) ) AS MostRecentBackup<\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[109,9],"class_list":["post-577","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-backup","tag-sql"],"_links":{"self":[{"href":"http:\/\/www.server1.dk\/index.php?rest_route=\/wp\/v2\/posts\/577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.server1.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.server1.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.server1.dk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.server1.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=577"}],"version-history":[{"count":1,"href":"http:\/\/www.server1.dk\/index.php?rest_route=\/wp\/v2\/posts\/577\/revisions"}],"predecessor-version":[{"id":578,"href":"http:\/\/www.server1.dk\/index.php?rest_route=\/wp\/v2\/posts\/577\/revisions\/578"}],"wp:attachment":[{"href":"http:\/\/www.server1.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.server1.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.server1.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}