January 23, 2012 at 7:54 pm
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?
January 23, 2012 at 10:13 pm
How differential backup works.
http://msdn.microsoft.com/en-us/library/ms345448(v=sql.90).aspx
January 24, 2012 at 7:07 am
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.
January 24, 2012 at 7:23 am
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
January 24, 2012 at 7:43 am
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?
January 24, 2012 at 8:29 am
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply