Home Forums SQL Server 2005 Backups Will doing a backup slow down the system RE: Will doing a backup slow down the system

  • A backup does a huge amount of IO. If your system is not bottlenecked on IO, if the additional load the backup puts in place doesn't impact queries trying to read data, then the impact may not be noticable.

    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