9002 ERROR

  • Mike Hays

    SSCommitted

    Points: 1871

    Comments posted to this topic are about the item 9002 ERROR

  • sqlnaive

    SSCoach

    Points: 17435

    Easy but good question (had some harsh experience in the start of my career). πŸ™‚

  • Carlo Romagnano

    SSC-Insane

    Points: 21810

    What's DOA?

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Nice question, learned something. Thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Christian Buettner-167247

    SSChampion

    Points: 13729

    DOA = Dead on Arrival πŸ˜‰

    Best Regards,

    Chris BΓΌttner

  • twin.devil

    SSC-Insane

    Points: 22208

    sqlnaive (10/29/2013)


    Easy but good question (had some harsh experience in the start of my career). πŸ™‚

    +1

  • rbester

    SSCrazy

    Points: 2601

    Thanks, would be scary id a database becomes DOA:cool:

  • Dana Medley

    SSCertifiable

    Points: 6764

    Koen Verbeeck (10/29/2013)


    Nice question, learned something. Thanks.

    +1 I almost picked DOA for giggles. I don't know why, but that just made me laugh this morning. πŸ˜€



    Everything is awesome!

  • george sibbald

    SSC Guru

    Points: 104200

    answered this just to find out if DOA did mean dead on arrival (or Database Out of Action)

    ---------------------------------------------------------------------

  • Mike Hays

    SSCommitted

    Points: 1871

    Sorry to my international colleagues that do not understand DOA.

    http://en.wikipedia.org/wiki/Dead_on_arrival

    Somethings said locally, may not be understood in other parts. We joke that the server is DOA, when delivered to be fixed.

  • tabinsc

    SSCommitted

    Points: 1812

    My guess was Single User because I was thinking read only would still be logging. I guess not.

    Tony
    ------------------------------------
    Are you suggesting coconuts migrate?

  • marlon.seton

    SSCrazy

    Points: 2623

    I didn't know the answer to this but thought 'read only' the most likely answer. DoA looked to be a joke and the other two seemed unnecessarily restrictive given that I couldn't see any reason why one shouldn't be able to read data without a log file.

  • SQLRNNR

    SSC Guru

    Points: 281210

    Out of curiosity, I wonder how many people have had this happen to them.

    Is the answer rate indicative of experience with this error or do people know this without having experienced it?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Michael Poppers

    SSCrazy

    Points: 2120

    SQLRNNR (10/29/2013)


    Out of curiosity, I wonder how many people have had this happen to them.

    Is the answer rate indicative of experience with this error or do people know this without having experienced it?

    I've recently seen it in two different circumstances:

    (a) lack of free space on the underlying disk volume; and

    (b) autogrowth restriction.

    Both situations related to the same database, and both were caused by the same application. Since that application was written to log the INSERTs it could not perform, I wrote a simple script to extract those INSERTs from the log file and redo them after circumstance (a) occurred. A little while later, circumstance (b) occurred, and I had the script in hand, ready to run :-).

  • jfgoude

    SSCrazy

    Points: 2586

    good memory despite certain age

    +1

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

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