Data Backup and Recovery Discussions

Restoring a SQL Backup using Snap Manager 5.1, with no recovery...

alixsqldba

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.

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?

Any advice will be much appreciated.

Cheers.

1 REPLY 1

abhisek

Hi Alastair ,

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 perform a RESTORE DATABASE WITH NORECOVERY .

Regards,

Abhishek

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public