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. 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 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.