{"id":444,"date":"2016-11-16T16:38:05","date_gmt":"2016-11-16T16:38:05","guid":{"rendered":"http:\/\/www.bartons.org.uk\/?page_id=444"},"modified":"2016-11-16T16:38:05","modified_gmt":"2016-11-16T16:38:05","slug":"see-which-transaction-logs-have-been-created-as-a-backup","status":"publish","type":"page","link":"https:\/\/www.bartons.org.uk\/?page_id=444","title":{"rendered":"See which transaction logs have been created as a backup"},"content":{"rendered":"<p>taken from: http:\/\/blog.sqlauthority.com\/2015\/10\/20\/sql-server-log-shipping-restore-job-error-the-file-is-too-recent-to-apply-to-the-secondary-database\/<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><code>-- Assign the database name to variable below<br \/>\nDECLARE @db_name VARCHAR(100)<br \/>\nSELECT @db_name = 'LSDemo'<br \/>\n-- query<br \/>\nSELECT TOP (30) s.database_name<br \/>\n,m.physical_device_name<br \/>\n,CAST(CAST(s.backup_size \/ 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS bkSize<br \/>\n,CAST(DATEDIFF(second, s.backup_start_date, s.backup_finish_date) AS VARCHAR(4)) + ' ' + 'Seconds' TimeTaken<br \/>\n,s.backup_start_date<br \/>\n,CAST(s.first_lsn AS VARCHAR(50)) AS first_lsn<br \/>\n,CAST(s.last_lsn AS VARCHAR(50)) AS last_lsn<br \/>\n,CASE s.[type] WHEN 'D'<br \/>\nTHEN 'Full'<br \/>\nWHEN 'I'<br \/>\nTHEN 'Differential'<br \/>\nWHEN 'L'<br \/>\nTHEN 'Transaction Log'<br \/>\nEND AS BackupType<br \/>\n,s.server_name<br \/>\n,s.recovery_model<br \/>\nFROM msdb.dbo.backupset s<br \/>\nINNER JOIN msdb.dbo.backupmediafamily m ON s.media_set_id = m.media_set_id<br \/>\nWHERE s.database_name = @db_name<br \/>\nORDER BY backup_start_date DESC<br \/>\n,backup_finish_date<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>taken from: http:\/\/blog.sqlauthority.com\/2015\/10\/20\/sql-server-log-shipping-restore-job-error-the-file-is-too-recent-to-apply-to-the-secondary-database\/ &nbsp; &nbsp; &#8212; Assign the database name to variable below DECLARE @db_name VARCHAR(100) SELECT @db_name = &#8216;LSDemo&#8217; &#8212; query SELECT TOP (30) s.database_name ,m.physical_device_name ,CAST(CAST(s.backup_size \/ 1000000 AS INT) AS VARCHAR(14)) + &#8216; &#8216; + &#8216;MB&#8217; AS bkSize ,CAST(DATEDIFF(second, s.backup_start_date, s.backup_finish_date) AS VARCHAR(4)) + &#8216; &#8216; + &#8216;Seconds&#8217; TimeTaken ,s.backup_start_date ,CAST(s.first_lsn AS [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":392,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-444","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.bartons.org.uk\/index.php?rest_route=\/wp\/v2\/pages\/444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bartons.org.uk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bartons.org.uk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bartons.org.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bartons.org.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=444"}],"version-history":[{"count":0,"href":"https:\/\/www.bartons.org.uk\/index.php?rest_route=\/wp\/v2\/pages\/444\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.bartons.org.uk\/index.php?rest_route=\/wp\/v2\/pages\/392"}],"wp:attachment":[{"href":"https:\/\/www.bartons.org.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}