Home Forums SQL Server 2008 SQL Server 2008 Administration Is there such a backup configuration you know of that can eliminate the impact backups have in the system? RE: Is there such a backup configuration you know of that can eliminate the impact backups have in the system?

  • Backups do not take locks. Full stop. End of story.

    Yes, in my experience backups do usually have some impact on the system. To be honest that's pretty unavoidable. It is, however, possible for the impact they have not to cause problems with the application.

    Get some benchmarks for your systems. What do things look like when the app's running fine? What do things look like during backups? What do things look like when other nightly processes are running? What do things look like when there's these timeout problems. The more data the better (to a point). Once you know what normal looks like and what abnormal looks like you can start digging into what causes the differences.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass