Hello, Sean!

Monday, March 4, 2013, 11:42:44 PM, you wrote:

LS> You missed a key point from Rick's post ... After backup we do a ***test restore***
LS> Obviously, Rick is double checking that the backup is valid.

missed nothing. Test restore does not differ from usual restore.

LS> As for "-use_all_space " option:

I know what it does, thank you.

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

I tested restore performance, but not with that flag. Yes, no_reserve
may be faster and yes, the database has smaller size. But the
gain depends of the size of the database.

--
Dmitry Kuzmenko, www.ib-aid.com