Krasavita
SSC-Insane
Points: 23138
More actions
June 15, 2009 at 7:25 am
#384774
Someone ran manually fullback,how can I see who did it?Thank you Isee the job ran SQL Logs, but don't know who did it. Thank you
ps.
One Orange Chip
Points: 29422
June 15, 2009 at 7:39 am
#1009646
use msdb
select user_name, * from msdb..backupset where database_name='Your_DB_name'
order by backup_set_id desc
June 15, 2009 at 8:34 am
#1009688
thank you
June 15, 2009 at 8:37 am
#1009692
Krasavita (6/15/2009)thank you
Krasavita (6/15/2009)
Glad I could be of some help 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply