Post reply

database kept in offline

  • June 25, 2012 at 2:25 am

    #143504

    One of my job is getting fail due to that database kept in offline mode. Here i want to know who (user) kept in offline.

    how to know who has kept that database kept in offline...

  • June 25, 2012 at 2:26 am

    #1504917

    query the default trace (you might get lucky), or create a custom DDL trigger to capture the information you want.

  • June 25, 2012 at 2:58 am

    #1504937

    I need the query to find out the user who kept in offline, and the server version is SQL Server 2000.

  • June 25, 2012 at 3:01 am

    #1504939

    Please post SQL 2000 questions in the SQL 2000 forums. Post in the 2005 forums and you will get answers that are specific to 2005 and above.

    In SQL 2000 you can check the error log, it might be logged in there who did the alter, but I don't think so (it just gives the SPID). If it's not in the error log and you have no custom tracing then there is no way you will be able to tell who set the DB offline.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 25, 2012 at 3:02 am

    #1504940

    Good luck then, unless you have something constantly poling the system tables capturing SPIDs and users who have access to issue ALTER DATABASE then your not going to find out who it is.

    Also check you dont have the auto close option set on for the DB.

    Also it is advised that you post 2000 problems in the 2000 area, that way you wont get information relating to a wrong version which does not apply to your problem.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply