> 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.

You missed a key point from Rick's post ... After backup we do a ***test restore***

Obviously, Rick is double checking that the backup is valid.

As for "-use_all_space " option:

1 - the restore will use less disk space
2 - I suspect that Rick believes that the restore will run faster, since more data will be on each page, thus less disk IO. (Personally, I have never tested the performance)


Sean