December 20, 2011 at 3:21 am
durai nagarajan (12/20/2011)
My question is will the backup wait for the current activities and backup those activities log as well.
I just answered that. No, a backup is not blocked (will not wait) for any data modification queries.
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
December 20, 2011 at 3:48 am
thank you all
Regards
Durai Nagarajan
December 20, 2011 at 6:25 am
logically, updating an index and doing backup doesn't suit as updated index should go into backup file.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2011 at 6:57 am
Bhuvnesh,
It is not advisible to schedule two jobs even it is irrelevant.
what do you say.
Regards
Durai Nagarajan
December 20, 2011 at 8:37 am
Bhuvnesh (12/20/2011)
logically, updating an index and doing backup doesn't suit as updated index should go into backup file.
And depending when the index change finishes and at what point the backup is when it does, it may or it may not. Either way, it's not going to stop the backup.
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
December 21, 2011 at 3:18 am
baabhu (12/15/2011)
If the online = off with index rebuild option on a huge table will certainly block the full backup. The table will be available if you use the online = on option. But curious to know why did not you use online option. Is there any constraint.
online = on is only available in Enterprise versions
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply