Subject RE: [firebird-support] Database backup test restore
Author Rick Debay
>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