> 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
