Post reply

9002 ERROR

  • October 28, 2013 at 9:30 pm

    #281859

    Comments posted to this topic are about the item 9002 ERROR

  • October 29, 2013 at 12:44 am

    #1662221

    Easy but good question (had some harsh experience in the start of my career). 🙂

  • October 29, 2013 at 2:03 am

    #1662227

    What's DOA?

  • October 29, 2013 at 2:50 am

    #1662240

    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

  • October 29, 2013 at 4:59 am

    #1662278

    DOA = Dead on Arrival 😉

    Best Regards,

    Chris Büttner

  • October 29, 2013 at 6:28 am

    #1662319

    sqlnaive (10/29/2013)

    Easy but good question (had some harsh experience in the start of my career). 🙂

    +1

  • October 29, 2013 at 6:57 am

    #1662340

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

  • October 29, 2013 at 7:42 am

    #1662355

    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!

  • October 29, 2013 at 8:33 am

    #1662382

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

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

  • October 29, 2013 at 9:07 am

    #1662402

    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.

  • October 29, 2013 at 9:20 am

    #1662409

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

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

  • October 29, 2013 at 10:07 am

    #1662436

    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.

  • October 29, 2013 at 10:23 am

    #1662446

    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

  • October 31, 2013 at 10:46 am

    #1663184

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

  • November 21, 2013 at 7:56 am

    #1668129

    good memory despite certain age

    +1

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

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