Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mondeo
Constraint Violating Yak Guru
287 Posts |
 Posted - 2007-07-24 : 12:20:25
|
| What happens if an UPDATE, DELETE or INSERT command comes in while the server is backing up (using BACKUP DATABASE)Do the subsequent commands wait until the backup completes?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-24 : 12:55:34
|
| No, a backup is a snapshot of the database at one point in time. Queries are able to continue while the backup is running.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Backup integrety question