Subject | Re: [firebird-support] Database backup test restore |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2013-03-04T19:33:59Z |
Hello, Rick!
Monday, March 4, 2013, 11:07:12 PM, you wrote:
RD> After backup we do a test restore:
RD> gbak -v -se server_name:service_mgr -use_all_space -r backup.fbk
RD> test.fdb
RD> Normally we just delete the file after gbak completes, but I'd like to
RD> be nicer to the database server.
I wonder that you
- use -use_all_space for test database. You see real speedup?
- delete restored database. Why you keep backup, that needed to be
restored again at some reasons? Instead, better keep database, delete backup.
RD> Some coworkers have also been saying
RD> they think that Firebird is still using the database after gbak exits,
RD> and deleting the file at that point is logging errors.
I also wonder why Firebird need to be interested in the database?
It has been restored, so, if noone connects to it, FB does not care about
this database anymore.
The end of gbak is the final disconnect.
RD> After gbak completes, should I run an isql script and drop the database?
RD> Should I shutdown the database? Or just continue deleting the file
RD> after the restore completes?
No, just delete it (if you still wish to do that). There is no reason to shutdown, run scripts, etc.
--
Dmitry Kuzmenko, www.ib-aid.com
Monday, March 4, 2013, 11:07:12 PM, you wrote:
RD> After backup we do a test restore:
RD> gbak -v -se server_name:service_mgr -use_all_space -r backup.fbk
RD> test.fdb
RD> Normally we just delete the file after gbak completes, but I'd like to
RD> be nicer to the database server.
I wonder that you
- use -use_all_space for test database. You see real speedup?
- delete restored database. Why you keep backup, that needed to be
restored again at some reasons? Instead, better keep database, delete backup.
RD> Some coworkers have also been saying
RD> they think that Firebird is still using the database after gbak exits,
RD> and deleting the file at that point is logging errors.
I also wonder why Firebird need to be interested in the database?
It has been restored, so, if noone connects to it, FB does not care about
this database anymore.
The end of gbak is the final disconnect.
RD> After gbak completes, should I run an isql script and drop the database?
RD> Should I shutdown the database? Or just continue deleting the file
RD> after the restore completes?
No, just delete it (if you still wish to do that). There is no reason to shutdown, run scripts, etc.
--
Dmitry Kuzmenko, www.ib-aid.com