question

Marcus-9726 avatar image
0 Votes"
Marcus-9726 asked ·

Is there any downtime or services interruption if changing database from SIMPLE to FULL recovery mode?

I have two databases with around 100GB of size for each db, I am about to change the recovery mode from SIMPLE to FULL for always on availability group setup purposes. As there are users who still using this db, may I know if I just change the mode will it causes any downtime or interruption to the db? How long would it take to complete the changes?

sql-server-generalsql-server-transact-sqlsql-server-migration
10 |1000 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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered ·

Hi MarcusWong-9726,

Changing database from SIMPLE to FULL recovery model will not cause any downtime or interruption. And it will complete the changes immediately.
In addition, after switching from SIMPLE to FULL recovery model, please remember to take database full backup to start the log chain and perform transaction log backup regularly. Please refer to this doc for more details.

Best Regards,
Amelia


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.


·
10 |1000 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.

NavneetAgarwal avatar image
0 Votes"
NavneetAgarwal answered ·

No, Changing the recovery mode from SIMPLE to FULL never breaks anything or causes downtime. As mentioned by AmeliaGu, it's recommended to take full backup of database just after changing recovery model from SIMPLE to FULL otherwise consecutive transaction log backup will start failing.

·
10 |1000 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.