[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

I have a failed DB restore triggered by an unknown user

Is there a way to get the security information about who ran a failed DB restore in SQL? We are currently dealing with this situation where somebody ran a DB restore that got failed, but we can seem to find who that person is.
1 Solution
It may still be stored in the default trace...

To get the trace name:

SELECT * FROM ::fn_trace_getinfo(default)  

To view the contents :

SELECT * FROM fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_122.trc', default)

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now