Yeah, tried with all the online help sites (including the one stated by Steve above). The issue is while changing the extension to ,ndf, the type still remains as primary...

It worked, thanks. 🙂

Can we get the datetime () and user login details as well from the EventData()?

Does not work

why database is not part of the parameter list?

This restore needs to be run from master or from other DB. If someone is already there in that DB  and trying to restore will throw an error msg. But...