February 10, 2012 at 8:19 am
Hi,
while backup job is running can we alter the data?
February 10, 2012 at 8:29 am
Yes. After you restore the database from the backup, transactions commenced while the backup was being taken will either be rolled back or rolled forward, so that the database is left in a consistent state.
John
February 10, 2012 at 9:32 am
Yes. A backup is an online operation, it takes no locks and it will not block normal user activity.
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
February 10, 2012 at 2:44 pm
thank you all.. 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply