We handle this a bit differently, and it depends on your space allowance... We take a backup every night of said database, and then restore it to databaseName_dayOfWeek. We then have 7 days of backups that are "live." If we ever need to rollback to a specific day, we simply take a backup, rename the current prod database, and then rename the one we want restored. Of course, if there is other transactional data in the database that is used, this will not be beneficial to you. However, for us, the application only reads from the database and does not write to it. You also have to be allowed the seconds of downtime for the switch. Just another approach that may or may not work depending on your requirements.