>I wonder that you >- use -use_all_space for test database. You see real speedup?
It requires less space for the test. >- delete restored database. Why you keep backup, that needed to be restored again at some reasons? Instead, better keep database, delete backup. The backup is written to tape. > The end of gbak is the final disconnect. OK. If my coworkers can prove otherwise, I'll file a bug report. -----Original Message----- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Dmitry Kuzmenko Sent: Monday, March 04, 2013 2:34 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Database backup test restore 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 RD> to 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 they think that Firebird is RD> still using the database after gbak exits, and deleting the file at RD> 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 ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links