Post reply

Transaction Log in Simple recovery model

  • June 25, 2008 at 8:26 am

    #188416

    Hi,

    According to Microsoft recommendations log files should be placed on a separated physical disk than other files and filegroups.

    My databases are in simple recovery model and I don't know if it still recommended to place their log files on a separate disks. Can anybody help me ?

    thanks

    regards

    Jarek

  • June 25, 2008 at 9:00 am

    #834071

    In simple recovery mode, the log files get just as much write activity as in full recovery mode. The log files are simply truncated automatically at each checkpoint.

    So, it is still good to move this disk activity onto another set of disks, if possible.

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

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