9002 ERROR

  • Comments posted to this topic are about the item 9002 ERROR

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

  • What's DOA?

  • 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

  • DOA = Dead on Arrival πŸ˜‰

    Best Regards,

    Chris BΓΌttner

  • sqlnaive (10/29/2013)


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

    +1

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

  • 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!

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

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

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

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

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

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

  • 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

  • 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 :-).

  • 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