Post reply

multiple backups at one time

  • March 24, 2010 at 11:47 pm

    #138026

    Can multiple backups be done on a database at one time? If yes, is there a limit on how many parallel backups are allowed on one db at 1 time.

    Dan.

  • March 24, 2010 at 11:56 pm

    #1139405

    Hi,

    Yes, In same cases multiple backup is available but there is possibilities of process level blocking and its better to schedule the backup on overlapping time interval or after completion of first to reduce unwanted blocking.

    Thanks & Regards,

    Nitin Gupta
    SQl Server (7.0,2000,2005) - Sr. DBA
    HCL Technologies, India

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

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