Can't recover SQL database to different SQL instance RRS feed

  • Question

  • Hello,

    I am trying to restore a SQL 2008 R2 database to a different SQL server instance.  When I run the recovery wizard, the only option available to me is to copy to a network folder.  All other options are grayed out.

    I did a tape backup on our primary DPM server or our primary SQL 208 R2 server, shipped the tapes to our secondary DPM server location to be restored on our secondary SQL 2008 R2 server.  The databases are recognized as protected SQL instances under the External DPM Tapes.  I can successfully restore to network.

    Any idea why the option to restore directly to our secondary SQL server in unavailable?

    Thank you!

    - Brian

    Thursday, May 19, 2011 9:54 PM

All replies

  • Hi bntringa1.

    When you import a tape to another DPM server you won't have the hability to restore its content to the original SQL instance or alternate SQL instance. This behavior happens to any protected data source that resides in an imported tape, this is not specific to SQL.



    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Thursday, May 19, 2011 11:08 PM
  • Hello,

    In our case, the DPM backed up the data straight from the SQL Server and the [Recover to any instance of SQL Server" option is grayed out even though there are two other SQL Servers available and one also has the DPM agent installed.   We just moved to DPM 2016 and no change on status.  Also, the only option available to select is [Recover to original instance of SQL Server (Overwrite database.) All other options are grayed out and I have not found any reference as to why or how to fix this.....so far

    DBA & Web Administration

    Friday, January 13, 2017 7:36 PM