Home > Link, Query, Script, SQL Query, SQL Server, SQL Server 2016, SQL Tips and Tricks, SQL Tricks, TSQL, Vishal Pawar > BI SQL # 279 : Get all last back up date and time with physical bak file path

BI SQL # 279 : Get all last back up date and time with physical bak file path

November 20, 2016 Leave a comment Go to comments

Hi Friends,

Lets see how to Check all last database back up date and time with physical bak file path

image

In this post we are going to discuss following “how to Check all last database back up date and time with physical bak file path”following points:

  • Problem Statement of SQL Script:
  • Description of SQL Script:
  • SQL Script Output Column
  • SQL Script Code

Problem Statement of SQL Script:

how to Check all last database back up date and time with physical bak file path.

Description of SQL Script:

Simple self-explanatory script.

SQL Script Output Column

backup

SQL Script Code

SELECT @@Servername AS ServerName,
	d.NAME AS NAME,
	b.Backup_finish_date,
	bmf.Physical_Device_name
FROM sys.databases d
INNER JOIN msdb..backupset b
	ON b.database_name = d.NAME
		AND b.[type] = 'D'
INNER JOIN msdb.dbo.backupmediafamily bmf
	ON b.media_set_id = bmf.media_set_id
ORDER BY d.NAME,
	b.Backup_finish_date DESC;

User Level to execute

500

    Hope you will like “how to Check all last database back up date and time with physical bak file path”.

    If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.

    Connect With me on

    | FaceBook |Twitter | linkedIn| Google+ | WordPress | RSS |

Advertisement
Categories: Link, Query, Script, SQL Query, SQL Server, SQL Server 2016, SQL Tips and Tricks, SQL Tricks, TSQL, Vishal Pawar
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

%d bloggers like this: