Use the SQL script below to find your last database backup time

–Use the SQL script below to find your last database backup time.

–SQL Query:

Use Master
declare @sd datetime
declare @ed datetime
SET @sd = CONVERT(date,getdate())
select @sd
Select database_name, backup_start_date ,backup_finish_date From Msdb.Dbo.Backupset where database_name = ‘Database_Name’ and backup_start_date > ‘2016-02-03’

Advertisements

Author: priyathamsystemcenterblog

I am system center operations manager & configuration manager administrator And has good knowledge in windows servers too.................................:)

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s