Post reply

Can't Reduce VLFs

  • July 12, 2013 at 2:19 am

    #279898

    Hi guys, I have a job that tries to make sure every DB has < 50VLFs. It shrinks the log then regrows it to its original size in 1 step. I have one DB that I can't get < 300 VLFs. I think its because I can't shrink the log smaller than its original size but I'm not sure how I can get my 50 VLFs. Any ideas guys?

    Cheers

  • July 12, 2013 at 4:43 am

    #1631875

    What recovery model?

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • July 12, 2013 at 4:53 am

    #1631876

    fool recovery model

  • July 12, 2013 at 5:04 am

    #1631877

    _nzrdb6 (7/12/2013)

    fool recovery model

    You need to backup the log first.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

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