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]