backup history details

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

msdb.dbo.backupfile

msdb.dbo.backupfilegroup

msdb.dbo.backupmediafamily

msdb.dbo.backupmediaset

msdb.dbo.backupset

Join them together and pull out the pieces of information which are rellivant to what you want to show.

getsimrangujral SSC Veteran Points: 207 More actions · Answer 2

i want to check , how many time i did particular database backup

Thanks

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

msdb.dbo.backupset then database_name column, user_name column, count them, group them

getsimrangujral SSC Veteran Points: 207 More actions · Answer 4

SSC Veteran

Points: 207

February 6, 2013 at 3:35 am

yes

thanks alot