Subject | Backing up a db with users connected can crash it? |
---|---|
Author | kurei_spin |
Post date | 2008-04-10T00:08:01Z |
Hi everybody!
I have a firebird database been used by 10 users simultaneously.
I've made a routine to backup this database 3 times a day.
The thing is: Can the backup routine (using gbak) crash the database
if the users are connected?
I think it can't but I've seen a site once saying that it could.
I don't know how gbak works but I guess it opens a snapshot
transaction and read database structure and records saving it to the
backup file. So, it would act as any other user connected to the
database. Thinking that way, saying that gbak can crash a database
with connected users would mean the same as saying that any user could
crash the database, right?
Am I wrong? Did anyone here have any experience to share?
Thanks in advance.
I have a firebird database been used by 10 users simultaneously.
I've made a routine to backup this database 3 times a day.
The thing is: Can the backup routine (using gbak) crash the database
if the users are connected?
I think it can't but I've seen a site once saying that it could.
I don't know how gbak works but I guess it opens a snapshot
transaction and read database structure and records saving it to the
backup file. So, it would act as any other user connected to the
database. Thinking that way, saying that gbak can crash a database
with connected users would mean the same as saying that any user could
crash the database, right?
Am I wrong? Did anyone here have any experience to share?
Thanks in advance.