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