topic Restoring a SQL Backup using Snap Manager 5.1, with no recovery... in Data Protection https://community.netapp.com/t5/Data-Protection/Restoring-a-SQL-Backup-using-Snap-Manager-5-1-with-no-recovery/m-p/31341#M6979 <HTML><HEAD></HEAD><BODY><P>Wondering if you guys can shed any light on this I am a SQL DBA with a working knowledge of NetApp. I am wanting to backup a database using Snap Manager 5.1 from one server and restore it to a new location on another server so that it can be configured for SQL Mirroring. I have used the GUI within Snap Manager to create the backup, however when trying to restore the backup using Snap Manager, I couldn't find an option to Restore With No Recovery.</P><P></P><P>Is this possible using Snap Manager and if not, please can you advise how to go about setting up SQL Mirroring with a backup taken from and restored using Snap Manager 5.1?</P><P></P><P>Any advice will be much appreciated.</P><P></P><P>Cheers.</P></BODY></HTML> Thu, 05 Jun 2025 06:28:30 GMT alixsqldba 2025-06-05T06:28:30Z Restoring a SQL Backup using Snap Manager 5.1, with no recovery... https://community.netapp.com/t5/Data-Protection/Restoring-a-SQL-Backup-using-Snap-Manager-5-1-with-no-recovery/m-p/31341#M6979 <HTML><HEAD></HEAD><BODY><P>Wondering if you guys can shed any light on this I am a SQL DBA with a working knowledge of NetApp. I am wanting to backup a database using Snap Manager 5.1 from one server and restore it to a new location on another server so that it can be configured for SQL Mirroring. I have used the GUI within Snap Manager to create the backup, however when trying to restore the backup using Snap Manager, I couldn't find an option to Restore With No Recovery.</P><P></P><P>Is this possible using Snap Manager and if not, please can you advise how to go about setting up SQL Mirroring with a backup taken from and restored using Snap Manager 5.1?</P><P></P><P>Any advice will be much appreciated.</P><P></P><P>Cheers.</P></BODY></HTML> Thu, 05 Jun 2025 06:28:30 GMT https://community.netapp.com/t5/Data-Protection/Restoring-a-SQL-Backup-using-Snap-Manager-5-1-with-no-recovery/m-p/31341#M6979 alixsqldba 2025-06-05T06:28:30Z Re: Restoring a SQL Backup using Snap Manager 5.1, with no recovery... https://community.netapp.com/t5/Data-Protection/Restoring-a-SQL-Backup-using-Snap-Manager-5-1-with-no-recovery/m-p/31346#M6980 <HTML><HEAD></HEAD><BODY><P>Hi Alastair ,</P><P></P><P>Select the "Leave the databases operational but unavailable for restoring additional transaction logs " in the Database State pane of SMSQL Restore Wizard.This will perform <SPAN style="font-family: 'Calibri','sans-serif'; font-size: 11pt;">perform a RESTORE DATABASE WITH NORECOVERY </SPAN>.</P><P></P><P>Regards,</P><P>Abhishek</P></BODY></HTML> Wed, 02 May 2012 13:28:51 GMT https://community.netapp.com/t5/Data-Protection/Restoring-a-SQL-Backup-using-Snap-Manager-5-1-with-no-recovery/m-p/31346#M6980 abhisek 2012-05-02T13:28:51Z