I would like to force SQL Server database to go in recovery mode when restoring from disk image snapshot. Any suggestions to force a single or group of databases in recovery so that additional transactional logs can be applied?
Not possible. Recovery mode means that redo was performed but not undo i.e., you need a prior restore operation.
A snapshot backup can be used as a base for restoring log backups (Veeam does it) but I don't think it is possible outside the VDI API.
There is no T-SQL API to attach a database with
NORECOVERY. Vote for the feature here.