Post reply

Backup multiple databases concurrently

  • December 7, 2010 at 12:30 am

    #229485

    Hello,

    can anyone tell me how SQL Server treats the backup of multiple databases simultaneously on a single instance.

    I am using SQL Server 2005 sp2.

    In my company we use a dedicated job scheduler. After business hours a number of backup jobs are send to an instance of SQL Server. Will they run simultaneously(on different threads), or will SQL Server limit this to make sure normal threads can still run?

    Thanks,

    Marc

  • December 7, 2010 at 1:08 am

    #1259411

    I am not very clear on what is meant as a dedicated job scheduler but my general understanding is that sql server will assign a thread from the thread pool (Depending on the availability of threads in the pool) for each task.

    Even if the backup job is executed sequentially there is no guaranty that sql server will use the same thread for a given SPID.

    Hope this makes sense.

  • December 7, 2010 at 3:34 am

    #1259440

    @marc Bonjean,

    Multiple backups will run simultaneously using different threads.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply