Log file getting filled up

  • pavel 74570 (10/13/2011)


    Wow, looks great! Comments are very usefull as well!

    I'll tweak it a bit today and will try tomorrow.

    Thanks once more!

    I'd actually restore prod right now on a test server and give it a whirl while on site.

    I'd possibly change the settings to only print and not run. That way you'd see what would run.

    Then just let it fly to see how long it takes and how much log activity you need to prepare for.

    The first run will certainly be the longest by far. Then it should speed up. Especially if you run daily and tweak the fill factors to something more reasonable for the actual use of the table.

  • This is a good read for the fill factor issue => http://www.sqlservercentral.com/Forums/Topic1126147-146-1.aspx

    Edit, yes you can start all the jokes you want about infinite loop & recursion :w00t:.

    Note the edit a couple days after the post as well :hehe:.

  • That's exactly what I'm planning to do.

    I'll pickup a last weeks full backup, restore it on the test serv and try to run a script.

    Thx

  • Finding this topic has saved me a lot of work.

    Thanks for the link Ninja

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • Stuart Davies (10/14/2011)


    Finding this topic has saved me a lot of work.

    Thanks for the link Ninja

    Ya I got to turn this into a wiki or something... I must have linked here at least 10 times already ;-).

Viewing 5 posts - 16 through 19 (of 19 total)

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