topic change sql clone from full to simple recovery mode in Data Protection https://community.netapp.com/t5/Data-Protection/change-sql-clone-from-full-to-simple-recovery-mode/m-p/5227#M6196 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Hi,</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">We need to regularly rebuild an index on a clone, and as it stands it uses the source’s full recovery mode, complete with extensive logging. We’d like to change the recovery mode of the clone so as to avoid unnecessary logging and hopefully speed up the index rebuild on the clone.</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Would setting the recovery to simple on the clone affect the source?</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P></BODY></HTML> Thu, 05 Jun 2025 06:10:04 GMT FREDITSI 2025-06-05T06:10:04Z change sql clone from full to simple recovery mode https://community.netapp.com/t5/Data-Protection/change-sql-clone-from-full-to-simple-recovery-mode/m-p/5227#M6196 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Hi,</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">We need to regularly rebuild an index on a clone, and as it stands it uses the source’s full recovery mode, complete with extensive logging. We’d like to change the recovery mode of the clone so as to avoid unnecessary logging and hopefully speed up the index rebuild on the clone.</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Would setting the recovery to simple on the clone affect the source?</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P></BODY></HTML> Thu, 05 Jun 2025 06:10:04 GMT https://community.netapp.com/t5/Data-Protection/change-sql-clone-from-full-to-simple-recovery-mode/m-p/5227#M6196 FREDITSI 2025-06-05T06:10:04Z Re: change sql clone from full to simple recovery mode https://community.netapp.com/t5/Data-Protection/change-sql-clone-from-full-to-simple-recovery-mode/m-p/5232#M6197 <HTML><HEAD></HEAD><BODY><P>Change database recovery mode on the clone database will not effect production database.</P></BODY></HTML> Mon, 18 Feb 2013 03:31:32 GMT https://community.netapp.com/t5/Data-Protection/change-sql-clone-from-full-to-simple-recovery-mode/m-p/5232#M6197 spat 2013-02-18T03:31:32Z