Problem

Change the database recovery model to full to allow restoration to a point in time

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_database_recovery_model.sql

Based on

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server?view=sql-server-ver16