• Mike Scalise (9/29/2016)


    Grant Fritchey (9/29/2016)


    I'd just do them one after another.

    I did set up a Powershell script once that spawned threads to run multiple backups simultaneously. I'll never do that to a production system again. Huge mistake. Seemed like a good idea at the time.

    Thanks, Grant. I suppose that's how we learn, right.........?

    Many have a lot more have to learn than a few others which are not at the top of the food chain like Grant.:-D

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/