I've want to share Powershell script I've designed to address restriction imposed by Recovery Manager for SQL: in order to restore snapshot via RM source sql server has to be on-line.
Basically this script will mount latest snapshot to a DR host and present volumes inside OS. Does exactly the same stuff as RM. I've only tested it with Windows 2008 R2. There is a lot of diskpart parsing as some data is not available via WMI (blame Microsoft).
RM-SQL Recovery script
RM-SQL Recovery script
- Attachments
-
RM_Recovery.txt- (10.55 KiB) Downloaded 3908 times
-
johanmark25
- Posts: 1
- Joined: Wed Apr 29, 2015 4:34 am
Re: RM-SQL Recovery script
I will suggest you to use Kernel for SQL Recovery Software to recover corrupt and delete SQL Database file and MDF file. Software solve all database issue in few steps. Download free trial version from - http://www.sqldatabaserecovery.org/
-
Richard Siemers
- Site Admin
- Posts: 1333
- Joined: Tue Aug 18, 2009 10:35 pm
- Location: Dallas, Texas
Re: RM-SQL Recovery script
johanmark25 wrote:I will suggest you to use Kernel for SQL Recovery Software to recover corrupt and delete SQL Database file and MDF file. Software solve all database issue in few steps. Download free trial version from
Johnmark25, unless the software communicates with the HP 3PAR storage and leverages hardware snapshots/replicas to recover the database, then I politely request that you refrain from advertising your software here.
Thank you.
Richard Siemers
The views and opinions expressed are my own and do not necessarily reflect those of my employer.
The views and opinions expressed are my own and do not necessarily reflect those of my employer.