Differential backup

Question

Post reply

Differential backup

Tara-1044200

SSCoach

Points: 15951
More actions
January 23, 2012 at 7:54 pm

#267021

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?

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

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

umasingh Ten Centuries Points: 1182 More actions · Answer 1

How differential backup works.

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

Tara-1044200 SSCoach Points: 15951 More actions · Answer 2

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.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

Tara-1044200 SSCoach Points: 15951 More actions · Answer 4

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?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

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

Differential backup

Cookies on SQLServerCentral