Home Forums SQL Server 2008 SQL Server 2008 Administration DB will become read only. We cannot make any modifications here, How to avoid this scenario RE: DB will become read only. We cannot make any modifications here, How to avoid this scenario

  • February 26, 2014 at 8:39 pm

    #1692512

    sankepalli (2/26/2014)

    Hello Folks,

    Suppose, there are 1 million records, if we insert all these records in the log file, it will become full & DB will become read only. We cannot make any modifications here, How to avoid this scenario?

    Immediate help would be highly appreciable

    Thanks

    If this doesn't sound like an interview or homework question, I don't know what does.

    So what do YOU think?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)