SQL Server: Change SQL recovery model from Simple to Full

If you change the recovery model for a SQL Server database from Simple to Full, log shipping will not kick in automatically.

To allow logshipping to start, you must take a full backup of the database.  This initiates the backup chain and allows incremental data logs to be produced.

 

 

Comments are closed