locked
How to Manually Restore SharePoint Content Database from DPM Backup to Alternative Farm RRS feed

  • Question

  • I have restored a content database of a site collection from a DPM backup, and the result is the MDF and LDF files of the database in a directory I specified in the restored wizard in DPM.

    In my other SharePoint farm (a test environment) simply trying to attach these files in the target farm's SQL server produces an error as follows:

    "Paths that begin with \\?\GlobalRoot are internal to the kernel and should not be opened by managed applications. (mscorlib) "

    Given I have the DPM restored database, on an alternative farm, how can I manually restore this content database? What are the required steps?

    Thanks,
    Richard

    Friday, May 16, 2014 1:20 AM

Answers

  • Hi,

    Manually copy the restored files to another location and try mount them again.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    • Marked as answer by Richard MM Wednesday, May 21, 2014 10:34 PM
    Wednesday, May 21, 2014 7:59 PM

All replies

  • Hi,

    Manually copy the restored files to another location and try mount them again.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    • Marked as answer by Richard MM Wednesday, May 21, 2014 10:34 PM
    Wednesday, May 21, 2014 7:59 PM
  • Thanks.

    As you suggest, copying them to a location that is different from where the files would have been backed up from (even if it is a different server), did the trick.

    I could then attach them and after that rename the database. Following this I could then create a new web application using this this database.

    Wednesday, May 21, 2014 10:34 PM
  • Hi

    Gr8 - don't ask me to explain, somehow SQL caches the backup location which is from a snapshot starting with \\?\GlobalRoot and copying them discards that so they can me mounted.

    Glad that resolved your issue.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, May 21, 2014 11:03 PM