October 11, 2009 at 7:40 am
If we are taking backup of a database does it allows doing changes in that DB? (for full , ifferential and log backups)
Thanks and Regards
Thank You.
Regards,
Raghavender Chavva
October 11, 2009 at 8:46 am
Raghavender (10/11/2009)
If we are taking backup of a database does it allows doing changes in that DB? (for full , ifferential and log backups)Thanks and Regards
Yes you can make changes to the database.
October 11, 2009 at 9:30 am
ok, Thank You,
But I have got a error when I am trying to do modifications on a table when backup of that database is in progress. Error is something like below:
You cannot modify or insert while backup is in progress.
Thank You
Thank You.
Regards,
Raghavender Chavva
October 11, 2009 at 9:36 am
You can perform DML operations. You cannot perform DDL operations on the database when database backup is happening.
Excerpts from BOL:
SQL Server uses an online backup process to allow a database backup while the database is still in use. During a backup, most operations are possible; for example, INSERT, UPDATE, or DELETE statements are allowed during a backup operation.
Operations that cannot run during a database or transaction log backup include:
File management operations such as the ALTER DATABASE statement with either the ADD FILE or REMOVE FILE options.
Shrink database or shrink file operations. This includes auto-shrink operations.
If a backup operation overlaps with a file-management or shrink operation, a conflict arises. Regardless of which of the conflicting operation began first, the second operation waits for the lock set by the first operation to time out (the time-out period is controlled by a session timeout setting). If the lock is released during the time-out period, the second operation continues. If the lock times out, the second operation fails.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply