June 11, 2004 at 5:55 am
I have a real basic question:
What happens if during a backup, a user inserts adds or dels froma table?
Will the Backup stop?
Should all users be booted out before a bK?
I know this is 101 question, but just trying to understand this aspect.
Thanks
June 11, 2004 at 2:11 pm
From my experience, Users should not have to exit out of the database during a backup. The user may experience slowness if trying to access the database during the backup, or the query may crash. I haven't experienced a backup stopping if it was accessed while a backup was going.
June 11, 2004 at 3:25 pm
There should be no issues with users accessing a database during a SQL backup. Any inserts/updates/deletes are put into the transaction log, and committed after the backup. Further, the backup picks up these uncommitted transactions, so that they are included in the backup.
Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply