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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-08-17 : 18:04:50
|
| Hi thereCould you give some input how's actually backup work. What I mean is ... let say the backup will take 1 hour (without checking media integrity), during the backup and if someone inserting data during that time does it actually part of the backup already or not.Correct if I am wrong, as far as I know the backup is a snapshot of given time of the database. And 1 hour process backup (for example) is actually a time for SQL written to disk/tape or whatever. Correct?So if this above assumption is correct, if I executed the backup job as sysadmin ... therfore no one (other users) can interfere the backup process in term of inserting/updating a record during a backup process. Correct? Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 18:06:53
|
| A backup is a snapshot of the data at one point in time. If the backup started at 6am and continued for 45 minutes, then a user enters data at 6:30am, that user's data is not in the backup. I don't understand your last paragraph. Are you asking a question?Tara Kizer |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-08-17 : 18:29:31
|
Thanks Tara.My assumption is correct then. It's a snapshot of data at one point in time. So in relation to Restric Access - Single User, this is not really relevant then use this option when backup kick in in order to achieve that no one will interfere the backup (inserting / updating record during the backup). Correct?quote:
Originally posted by tkizer
A backup is a snapshot of the data at one point in time. If the backup started at 6am and continued for 45 minutes, then a user enters data at 6:30am, that user's data is not in the backup. I don't understand your last paragraph. Are you asking a question?Tara Kizer
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 18:31:57
|
| No one is going to interfere with the backup even if there are users on the system making data changes. Data changes do not impact the backup. The data changes will be included in the next scheduled backup.Tara Kizer |
|
|
|
|
|
|
SQL2000: Understanding The Backup Work