• Bhuvnesh (9/24/2013)


    Perry Whittle (9/19/2013)


    Using the @affinity and @throttle parameters you are able to specify which processors the backup uses and the max CPU %

    Can we take help of Resource Governor in Sql 2008 for this ?

    If you're using SQL 2008, I would suggest using native backup compression over LiteSpeed. Litespeed has it's own issues when running concurrent backup processes that native compression doesn't suffer from.

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]