Subject | Re: [firebird-support] Backing up a db with users connected can crash it? |
---|---|
Author | Helen Borrie |
Post date | 2008-04-10T02:26:56Z |
At 10:08 AM 10/04/2008, you wrote:
>Hi everybody!No. Databases don't crash. The server can be made to crash under certain conditions - but never just from reading
>
>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.Ah, well, if it was on a website, it must be true! ;-)
>I don't know how gbak works but I guess it opens a snapshotExactly right. And the transaction is a read-only transaction. And it doesn't execute any UDFs or create garbage or mess up character sets, as human users and bad application code written by humans can sometimes do.
>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 databaseSome users could crash the server, if they invoked a bad UDF. Databases don't "crash" since they are not executable programs.
>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?Probably most of us. :-)