SQL Server Performance

Find logs

Discussion in 'SQL Server 2005 Replication' started by reethu, Apr 18, 2007.

  1. reethu New Member

    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
  2. MohammedU New Member

    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.
  3. satya Moderator

    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.

Share This Page