Coffeehouse Post

Single Post Permalink

View Thread: If you never do a Full backup on SQL server. Can that give performance issues?
  • User profile image

    , blowdart wrote


    What did you run to do the backup? It's possible that the transaction logs were truncated at that point, as you no longer needed them to roll back - you have the backup for that.



    that may well be what happened.

    you may also want to setup some maint. plans to re-build indexes and some other stuff...

    like a nightly backup ....