We're thinking about integrating SQL Virtual Restore into our nightly process where we automatically restore database backups that live on a remote share. I've tested this with SQL Virtual Restore and it seems to work well. However, I'm not sure if this is a "worst practice" or if anyone has any real-world experience with doing this. I guess the thing I'm most concerned about is there being a bunch of network traffic generated between the database server and the server hosting the file share after the restore has been completed. If so, we might need to alter our process to drop the database after the restore and DBCC checkdb have been completed.
thanks in advance