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?

  • Since the days of SQL Server 7.0, if I've seen backups impacting a system in a way that affected performance, it was because there were already a bunch of other issues with the system that needed to be addressed. Backups by themselves, I've never seen them take a system down. I'd strongly suggest addressing all the other issues that are likely to be found in the system. Use wait statistics and gather query performance metrics to understand what is happening on the system.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning