How to access revisions to roll back?

When you copy only the Database you will lose all your resources, because they are in the filesystem.

Not directly. You can use a filesystem Sync and then create a script which then make the git stuff on a sheduled base.

For Backups take a look into the Simple Backup Plugin also take a look into Restoring Deleted Notes