February 18, 2011 at 11:22 am
Hello All,
I'm trying to check the backup job's history and when i clicked on 'View History' options it comes out to be blank.
i want to view the history of 2 different backup jobs so i checked both however, don't see any log for both.
Backupmediaset and Backupmediafamily tables does show the info.
Please suggest at the earliest how to get the same. Thanks
Rgds,
Pankaj
February 18, 2011 at 11:48 am
Can you check this link - http://www.mssqltips.com/tip.asp?tip=1269
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 23, 2011 at 7:17 pm
Something like this could be useful for you.
The WHERE type = 'D' limits it to full database backups.
In this example I am just getting the backups over the last ten days.
The MBs column is the backup rate - MB per second.
The msdb.dbo.backupset table is very useful.
This also works for LiteSpeed backups.
USE msdb
GO
SELECT
database_name
,backup_start_date
,CAST(backup_size / 1024 / 1024 / 1024 AS DECIMAL(5,2)) GB
,DATEDIFF(ss, backup_start_date,backup_finish_date) Secs
,CAST (backup_size / 1024 / 1024 / DATEDIFF(ss, backup_start_date,backup_finish_date) AS DECIMAL (5,2) ) MBs
FROM backupset
WHERE type = 'D'
AND backup_start_date > GETDATE() -10
ORDER BY backup_start_date
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply