Differential backup

  • What happens when an insert/update is running on the database duriing the same time when there is backup job running (differential). Which job would effect?

  • How differential backup works.

    http://msdn.microsoft.com/en-us/library/ms345448(v=sql.90).aspx

  • I did read this but didnt find which would be effected, either the inserts or the backup time when they both run at the same time.

  • What effects are you asking about?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • If i am doing an insert not knowing there is a differretial backup runing for the same database at the same time, does my insert query is blocked or backup job is blocked?

  • Neither. Backups don't ever block DML activity (or DDL for that matter) on a database.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

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