May 7, 2010 at 6:28 pm
I have a job that has started running as per shcedule which does bulk insert on a database and without realising that i have started backing up the same database before this job kicked off, its been an hour but still i dont see these sessions blocking each other, what would happend in the worst case scenario. Does my bulk insert job get into some problems?
May 9, 2010 at 12:02 am
back up and job wil run in two different trnsactions so there would be no conflict but i am not sure that if backup is ON and job get started but i still think there would be no blocking. ACID property will help here 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 11, 2010 at 4:56 pm
can i create or alter indexes during the backup ?
May 12, 2010 at 6:12 am
yes you can create
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply