SQL Server Performance Forum – Threads Archive
Find logs
Hi 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. SRJ2005Check 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
CategoryServer
Event1073746908
UserDomainMohammedU
ComputerMOHAMMEDU Message
Setting database option OFFLINE to ON for database Pubs. MohammedU.
Moderator
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
http://www.SQL-Server-Performance.Com
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.
]]>