Auditing users

[dhulbert]

I have just found a random backup file on my server created around 1 hour ago and I have no idea who has been runing backup jobs.
Is there anyway to se who has recently run a backup. It wasn't run through the SQL agent as I've checked the history in there and no times match up so it must have been run as an ad-hoc command.
Any ideas??

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[djj55]

Try the profiler. Navigate to: C:\Program Files\Microsoft SQL Server\MSSQL10_50.yourinstance\MSSQL\Log or something close to that and look for log_xx.trc files.

I hope this helps,

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[gmmastros]

Try this query:

Select  B.database_Name,B.user_name, b.backup_start_date
FROM    MSDB.dbo.BackupSet As B             
Order By backup_Start_Date DESC

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[djj55]

Nice, George, and much better than my guess.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!