I have an existing database, that i want to restore from a backup by overriding the existing database.
at the moment I have
I thought that would be enough to restore the db. However when i try i get the error
User does not have permission to RESTORE database 'XY'
Is this achievable just with granting database roles (and without granting server role and fine tuning permissions?)