You can accomplish this by following the KB article below.
With our SQL agent you will need to restore and detach the database from SQL as a different name \ path so it does not affect the production DB.
The SQL agent can not restore the database to a flat file it must always be restored to SQL but can easily be detached.
Let me know if this answers your question.
CommVault Messaging Support