Post reply

DTS - Recovery Model

  • January 31, 2003 at 2:40 am

    #63245

    SQL Server 2000 SP3.

    Prior to SP3 the recovery model was switched to simple during transfer (Copy object task) and changed back to the previouis setting after DTS was complete.

    Nice thing because performance was increased and T-Log was keep small.

    Now I assume that the recovery model is switched to bulk-logged causing the T-Log to explode, to be onest not in all my databases.

    1.Is my interpretation regarding recovery model correct?

    2.Does anybody knows the reason of this change?

    Any suggestion is really appreciate.

    Thank you very much - kind regards.

    Franco

    Franco


    Franco

  • January 31, 2003 at 11:20 am

    #447736

    Franco,

    Prior to SP3, when you use DTS to transfer objects(not data), the database would be but into simple mode as you mentioned. Due to this, you will have to take a full backup after the DTS package. This was considered to be a bug and to make the recovery model more rigid, the change was expected. You are right that the log file would grow but your recovery model would be more rigid. I'm not sure whether it is put in bulk-logged or full recovery mode but hope someone would help us out here.

Viewing 2 posts - 1 through 1 (of 1 total)

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