Hello
I am trying to migrate an SQL express server on-prem to AWS RDS sql server using native backup and restore. Now the error being thrown to us is "exception: Restore database failed as the recovery model of the database being restored is not full: SIMPLE. Please update the recovery model and try again!"
When on analyzing the RDS and sql server the recovery model supported by RDS is 'Full' while SQL server on prem is now in 'SIMPLE'. If we change the on-prem recovery model to 'Full' do we have to perform any pre-requisite steps and whether it will affect the existing sql on-prem server logs in anyway.
Please provide your inputs and if any of you have done the same before, please let us know the challenges faced and best approach to be taken to complete the migration.