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

    , fabian wrote

    My question is: I you don't ever perform a full backup. Can that give performance issues? I am thinking about that the transaction log is never commited.

    or is this just pure coincidence?

     

    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.