topic SQL Mirror and Snapmirror in ONTAP Discussions https://community.netapp.com/t5/ONTAP-Discussions/SQL-Mirror-and-Snapmirror/m-p/79825#M18629 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>My customer would like to use MS-SQL 2005 mirroring ability to perform data migration from one site to the other and to reduce downtime to 0 due to the criticality of the system.</P><P></P><P>The usuall way to do so is by using SQL backup and restore in non recovery mode. </P><P></P><P>We want to utilize snapmirror to transfer the baseline of the data from one site to the other. </P><P></P><P>Does anyone have the procedure in steps how this should be done ? According to the customer DBAs there is no known method to attache the databases in the 2nd site in non recoverymode to be able to sync the mirror.</P><P></P><P>Thanks </P></BODY></HTML> Thu, 05 Jun 2025 07:27:30 GMT hmarko 2025-06-05T07:27:30Z SQL Mirror and Snapmirror https://community.netapp.com/t5/ONTAP-Discussions/SQL-Mirror-and-Snapmirror/m-p/79825#M18629 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>My customer would like to use MS-SQL 2005 mirroring ability to perform data migration from one site to the other and to reduce downtime to 0 due to the criticality of the system.</P><P></P><P>The usuall way to do so is by using SQL backup and restore in non recovery mode. </P><P></P><P>We want to utilize snapmirror to transfer the baseline of the data from one site to the other. </P><P></P><P>Does anyone have the procedure in steps how this should be done ? According to the customer DBAs there is no known method to attache the databases in the 2nd site in non recoverymode to be able to sync the mirror.</P><P></P><P>Thanks </P></BODY></HTML> Thu, 05 Jun 2025 07:27:30 GMT https://community.netapp.com/t5/ONTAP-Discussions/SQL-Mirror-and-Snapmirror/m-p/79825#M18629 hmarko 2025-06-05T07:27:30Z Re: SQL Mirror and Snapmirror https://community.netapp.com/t5/ONTAP-Discussions/SQL-Mirror-and-Snapmirror/m-p/79829#M18630 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The TR-3604 document is your place:</P><P><A href="http://www.netapp.com/us/library/technical-reports/tr-3604.html" target="_blank">http://www.netapp.com/us/library/technical-reports/tr-3604.html</A></P><P></P><P>Basically they are honest &amp; upfront with recovery times which for asynchronous SM are stated as 17 minutes (5 minutes for synchronous SM).</P><P></P><P>Good doc as it also describes native SQL 2005 tools for HA/DR</P><P></P><P>Regards,</P><P>Radek</P></BODY></HTML> Sun, 14 Jun 2009 19:53:18 GMT https://community.netapp.com/t5/ONTAP-Discussions/SQL-Mirror-and-Snapmirror/m-p/79829#M18630 radek_kubka 2009-06-14T19:53:18Z