Home Forums SQL Server 2005 Administering DBCC CHECKDB - how use it in a maintenance plan ? RE: DBCC CHECKDB - how use it in a maintenance plan ?

  • Hi Gila,

    Sorry, I get back to you a bit late. I am not fully understanding about Transaction Log. Let say I switched my DB Model to 'SIMPLE'. I don't need to worry about transaction log anymore as you said. But what do I do if transaction log is getting bigger, for example -

    Transaction log initial size 4GB [that is okay and I am happy with this size], During the day or when I check the database at night, Transaction Log is about 40GB . What do I do?

    I know, you will hate me but I really want to understand this which mean I want to learn from your experience. Last question.......

    Insert or Reading the record from Database is very slow sometime, is that anything to do with transaction log? How to solve it?

    Thanks again.