question

NarayanS-2290 avatar image
0 Votes"
NarayanS-2290 asked Teko-7898 published

SQL server express on-prem to AWS RDS sql server

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.

sql-server-migration
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NarayanS-2290, we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @NarayanS-2290,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Teko-7898 avatar image
0 Votes"
Teko-7898 answered Teko-7898 published

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.