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

  • Jeff Moden (2/26/2014)


    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?

    Yep, You are right. It sounds like an interview\homework question ..

    --

    SQLBuddy