none
Restore failed DPM server RRS feed

  • Question

  • What is the procedure in case I haven't backed up the database in a file.bak?

    All backups are in the storage, including full backup of the DPM server and SQL databases. Except that I had never succeeded in having the Bare Metal option for the backup of DPM server itself (only C and systemstate).

    I also have copies of the .mdf/ldf Sql available before failure, and they are in the DPM storage as well. How to recover them? 

    mardi 15 janvier 2019 14:47

Toutes les réponses

  • Hi

    Unfortunately you will not be able to access DPM storage if you didn't backup your DPM Database to Azure, Tape or used any other third-party backup tool. DPM Database backup is crucial, that is why it is import to plan this correctly, else you need to rebuild the whole DPM server from scratch. I'm sorry, but don't think there is any other options to restore your DPM server if your server is currently down and you do not have any other backups. 

    Check this link for methods on how to backup your DPM server

    https://docs.microsoft.com/en-us/system-center/dpm/back-up-the-dpm-server?view=sc-dpm-1807


    Microsoft Certified Professional

    [If a post helps to resolve your issue, please click the "Mark as Answer" of that post or click Answered "Vote as helpful" button of that post. By marking a post as Answered or Helpful, you help others find the answer faster. ]

    • Proposé comme réponse Leon Laude vendredi 15 février 2019 09:11
    mardi 15 janvier 2019 18:21
  • Hello!

    What version of DPM Are/were you running?

    As Matej previously stated, I'm afraid there is no supported way to get your DPM storage back unless you have a proper backup of the DPM database.

    It is extremely important to backup your DPM database to another location, whether it's on another disk/tape or in the cloud it doesn't matter, as long as you have a backup of the database to another site.

    You could try restoring the SQL database with the .mdf/.ldf files, it should be possible to restore an SQL database, but this is outside of my comfort zone so I will just give you a link to a post here for more information.

    If you are using a DPM version that is older than DPM 2016 (no Modern Backup Storage), you can access the DPM replica data, but it will be difficult to know what is what as it's a bit cryptic but the data is there.

    In previous DPM versions you could occasionally get to the replica data by performing the following steps:

    1. Install a new server the server name must be the same as the damaged DPM server.

    2. Install DPM and make sure the version and build is the exact same as the damaged DPM server.

    3. Present the storage pool to the newly installed DPM server.

    4. Run a DPMSync -Restore within the DPM Shell.

    5. Run a DPMSync -Sync within the DPM Shell.

    6. If this works, then all the replicas will be in an inconsistent state, but you should be able to access your data.


    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Proposé comme réponse Leon Laude vendredi 15 février 2019 09:12
    mardi 15 janvier 2019 19:49
  • Wow! I must have skipped some reading.

    I am on 1801 version. But my database in on another Server! No use?

    So how do I backup the database on a regular basis? With something else but the same DPM server i guess? 

    https://social.technet.microsoft.com/Forums/en-US/404ca1a2-7703-4cff-8c59-b8b2ae4adc7c/data-protection-manager-2012high-availability?forum=dataprotectionmanager

    If I need a .bak file for restore should an automatic backup produce it as a sheduled task ?

    Here they mention an .mdf, will it be worth to try?

    https://backupdirect.onlinebackup.com/Help/tsk/rs_recoveringdpm_database.html

    For example: 
    DpmSync.exe -RestoreDb -DbLoc C:\RestoredDB\DPMDB2007RTM.mdf 


    • Modifié lonbluster mercredi 16 janvier 2019 22:42
    mercredi 16 janvier 2019 22:41
  • You can backup the DPM database for example with the following methods:

    1. By installing a secondary DPM server that backs up the primary DPM server.
    2. Use native SQL backups (SQL dumps) to a remote storage.
    3. Have a third party backup software to backup your DPM database.

    In your case, an easy way would be to go with the so called SQL dumps, schedule and backup natively by using the SQL Management Studio.

    >> Create a Full Database Backup (SQL Server) <<

    As I stated earlier, an SQL Server can be restored with .mdf file(s), so it might be worth giving it a shot.


    Blog: https://thesystemcenterblog.com LinkedIn:

    mercredi 16 janvier 2019 23:00
  • Actually I had uninstalled the DPM server, it hadn't failed. 

    But when reinstalling it was failing to use the Sql domain account it was using before. I tried to set the permissions, but failed, then reinstalled with a Domain admin, and it created a new empty database. 

    So now, with all DPM services stopped, if try dpmsync i get

    dpmsync.exe -restoredb -dbloc '.\MSDPM2012$DPMDB_ONVPN.mdf' -instancename scom18\dpm18

    DpmSync 2.0 - DPM database synchronization command-line toolCopyright (c) 2013 Microsoft Corporation. All rights reserved.Copying file from '\\scom18\c$\Program Files\Microsoft SQL Server\MSSQL13.DPM18\MSSQL\DATA\msdpm2012$dpmdb_onvpn.mdf' to 'C:\Program Files\Microsoft SQL Server\MSSQL13.DPM18\MSSQL\DATA\MSDPM2012$DPMDB_ONVPN34394783_d4d5_46ca_ab30_52d929d1c14c.mdf.recovered'Error ID: 466Unable to copy database files to C:\Program Files\Microsoft SQL Server\MSSQL13.DPM18\MSSQL\DATA\MSDPM2012$DPMDB_ONVPN34394783_d4d5_46ca_ab30_52d929d1c14c.mdf.recovered. Review the error details and try again.

    Detailed Error: The process cannot access the file '\\scom18\c$\Program Files\Microsoft SQL Server\MSSQL13.DPM18\MSSQL\DATA\msdpm2012$dpmdb_onvpn.mdf' because it is being used by another process.



    • Modifié lonbluster samedi 19 janvier 2019 11:26
    samedi 19 janvier 2019 11:26
  • Have you checked that no process is using the .mdf file? try manually copying it to your DPM server and then run the dpmsync.exe to point to the local (copied) .mdf file.

    Blog: https://thesystemcenterblog.com LinkedIn:

    samedi 19 janvier 2019 12:15
  • If i put the database offline i get

    Error ID: 454
    DpmSync failed to connect to the specified SQL Server instance. Make sure that you have specified a valid SQL server instance associated with DPM and you are logged on as a user with administrator privileges.

    Detailed Error: Cannot open database "DPMDB_ONVPN34394783_d4d5_46ca_ab30_52d929d1c14c" requested by the login. The login failed.
    Login failed for user 'xxx\xxx'.

    But now I can't event uninstall...failed connection to Sql. And I have no bare metal to restore. ok, I think i know Dpm better and will plan accordingly on a new install/config...

    Thanks for your help.

    • Modifié lonbluster samedi 19 janvier 2019 14:10
    samedi 19 janvier 2019 14:05
  • If you reinstalled the DPM server, firstly make sure the version is exactly the same as it was previously (even rollups).

    Are you running the dpmsync as an administrator and with an account that has access to the database?

    Try for example with an account that had access to the DPM database previously.

    Here's also an article about the Error ID 454:

    https://support.microsoft.com/en-us/help/3047774/the-system-cannot-find-the-file-specified-error-when-you-use-data-prot


    Blog: https://thesystemcenterblog.com LinkedIn:

    samedi 19 janvier 2019 14:15
  • Still, if the guide says I need a .bak file to restore dpmsync, why isn't it available when is needed? Why doens't it get created when I uninstall? I think the restore capabilities of DPM are proved a bit wanting here.


    Can you confirm I need to manually create a .bak file database backup task off-server, even if my database is on another machine? (with uninstall option:Keep data, or with dpm machine failure)




    • Modifié lonbluster samedi 19 janvier 2019 14:55
    samedi 19 janvier 2019 14:38
  • The .bak file is created when you use the native SQL backup (for example backup in SQL Management Studio).

    This is a supported way of backing up the DPM database server, by backing up and restoring with .bak files.


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Proposé comme réponse Leon Laude dimanche 27 janvier 2019 13:17
    samedi 19 janvier 2019 14:53
  • Hello!

    Do you have any update on your issue?

    (Please don't forget to mark as answer)


    Blog: https://thesystemcenterblog.com LinkedIn:

    vendredi 15 février 2019 09:12