Coffeehouse Post

Single Post Permalink

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

    , blowdart wrote

    *snip*

    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 ....