SQL server express on-prem to AWS RDS sql server

Question

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.

Answer 1

Hi @Narayan S ,

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.

1.Before you change the recovery model from Simple to Full, please make a Full Database Backup for your databases which you need change the recovery model.
2.After you change the recovery model to Full recovery model, immediately take a full or differential database backup to start the log chain. The switch to the full recovery model takes effect only after the first data backup.
3.Schedule regular log backups, and update your restore plan accordingly. Please remember to back up log, if you do not back up the log frequently enough, the transaction log can expand until it runs out of disk space.

Please get more information from View or Change the Recovery Model of a Database (SQL Server)

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@CarrinWu-MSFT excelent, i can fix the problem, thank you.