Here is a T-SQL query which gives information on who and when was a database deleted.
SELECT name AS EventName, DatabaseName, StartTime, LoginName
FROM sys.traces T CROSS Apply
fn_trace_gettable(CASE WHEN CHARINDEX('_', [path]) <> 0
THEN SUBSTRING(PATH, 1, CHARINDEX('_', T.[path]) - 1) + '.trc'
ELSE [path]
END, max_files) TT
JOIN sys.trace_events TE ON TT.EventClass = TE.trace_event_id
WHERE name like '%Deleted%'
AND ObjectName IS NULL
AND EventSubClass = 1
ORDER BY StartTime DESC
For those interested in nursing education, this essay on https://www.nursingpaper.com/examples/discussion-and-critical-analysis-learning-and-teaching-in-the-nursing-setting-essay/ is a must-read. The critical analysis offers deep insights and practical applications that are really helpful.
ReplyDelete