none
Restore failed DPM server RRS feed

  • Pergunta

  • 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? 

    terça-feira, 15 de janeiro de 2019 14:47

Todas as Respostas

  • 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. ]

    • Sugerido como Resposta Leon Laude sexta-feira, 15 de fevereiro de 2019 09:11
    terça-feira, 15 de janeiro de 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:

    • Sugerido como Resposta Leon Laude sexta-feira, 15 de fevereiro de 2019 09:12
    terça-feira, 15 de janeiro de 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 


    • Editado lonbluster quarta-feira, 16 de janeiro de 2019 22:42
    quarta-feira, 16 de janeiro de 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:

    quarta-feira, 16 de janeiro de 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.



    • Editado lonbluster sábado, 19 de janeiro de 2019 11:26
    sábado, 19 de janeiro de 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:

    sábado, 19 de janeiro de 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.

    • Editado lonbluster sábado, 19 de janeiro de 2019 14:10
    sábado, 19 de janeiro de 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:

    sábado, 19 de janeiro de 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)




    • Editado lonbluster sábado, 19 de janeiro de 2019 14:55
    sábado, 19 de janeiro de 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:

    • Sugerido como Resposta Leon Laude domingo, 27 de janeiro de 2019 13:17
    sábado, 19 de janeiro de 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:

    sexta-feira, 15 de fevereiro de 2019 09:12