SQL Server Performance Forum – Threads Archive
Find logsHi guys how to find who have taken database offline. i checked all error logs, i didnot find solution.could any one say how to see this activity .please. SRJ2005
Check the application through SQL Management studion, you should see the infomation about user and hostname…. Ex:
Date4/18/2007 2:21:22 PM
LogWindows NT (Application) SourceMSSQL$SQL2K555
Setting database option OFFLINE to ON for database Pubs. MohammedU.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
That will not be mentioned on the SQL server error log, but it can help the timing it mentioned. By taking up windows event viewer logs such as security log check the times of LOGON & LOGOUT audit in this case. The last resort is to read the transaction log by using third party tools. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.