Showing posts with label DPM. Show all posts
Showing posts with label DPM. Show all posts

Tuesday, February 27, 2018

DPM 2012–Event ID 3184 Owner DPM Server

Recently I had an incident on the DPM 2012.  It’s the ActiveOwner issue.

image

I’m going to share with you how I done it.

The ActiveOwner files are located in "c:\program files\Microsoft Data Protection Manage\dpm\activeowner" on the server hosting the databases (SQL server being backed up). In my case it is one of the SQL server the DPM is protecting.  These ActiveOwner are used to manage ownership of databases, important for ensuring multiple DPM servers aren't attempting to backup/restore resources at the same period of time.


image

In the Protected Server that is running the SQL, from the Windows Explorer, drill to the location of:
C:\Program Files\Microsoft Data Protection Manager\DPM\ActiveOwner .

Rename all the files that is 0 KB. e.g. rename with the extention of .old

image

Next launch the Command Prompt in Administrator.

image

Change the directory to : C:\Program Files\Microsoft Data Protection Manager\DPM\bin in the Protected server (not DPM)

Key in as follow :
SetDPMServer.exe –DPMServerName DPMServerName

Note : Replace the DPMServerName with your DPM Server.  The rest of the syntax stays the same.


Rerun the Synchronization in your DPM Console.  It should resolved.

image

keywords : DPM, DPM 2012, DPM 2012 R2, Owner DPM Server ID 3184 The file or directory is corrupted and unreadable (0x80070570), DPM could not run backup/recovery job for the data source it is owned by a different DPM Server, Take data source ownership



Monday, March 13, 2017

SCDPM 2016 Storage Setup – Modern Backup Storage

In the System Center Data Protection Manager 2016 (SCDPM 2016), there’s improvement of which type of data to be stored into specific LUN.  I have in the sample are 2 LUNs from NetApps presented the volume to SCDPM 2016 for the Storage Pool.

By configuring this, I’ll have it as Application-aware backup for my SCDPM 2016

In the predecessors (SCDPM 2010, SCDPM 2012), the whole storage pool is mixed together with SQL,VM Backups etc.

However in the SCDPM I can have something like this :

 image

In order to have the above, I’ll share the steps of how it was done.

Once the LUN is presented to the SCDPM 2016, open up the Disk Manager.  I’m going to use Disk 4 and add into the Storage Pool.  This LUN I’m going to use it for SQL type of backups.  This Disk 4 LUN storage was presented from NetApps.  In the later steps I use a friendly name to distinguish in the Storage Pool.

image

I’m going create it as a New Simple Volume (Right-click – Select New Simple Volume)

image

In the Welcome to the New Simple Volume Wizard, click Next.

image

In the Specify Volume Size, click Next (selection to use entire volume for this backup)

In the Assign Drive Letter or Path display, click the Assign the following drive letter, select letter, then click Next

SNAGHTML63274d

In the Format Partition display, click Do not format this volume, then click Next.

image

In the Completing the New Simple Volume Wizard, click Finish

(Below is just a sample)

image

It will something like a sample below in the Disk Management, once the above activity has completed carry out.

image

Switch back to SCDPM 2016 console.

Click ManagementDisk Storage – then click Add at the ribbon menu.

image

In the Add Disk Storage display, click the Add button. 

image

A warning is displayed, click Yes  to continue

image

Once selected and added, key in a friendly name (as mentioned earlier in this blog) to distinguish.  Click OK.

image

Double click on the DPM Management Shell to launch the specific PowerShell commands for SCDPM (Note that this is different set of commands from the normal Windows PowerShell)

Once the DPM Management PowerShell is launch type the following :

$vol = Get-DPMDiskStorage –Volumes

$vol

image

In the next command key, this is going to change the particular pool for Application-aware backup as shown below :

Update-DPMDiskStorage –Volume $vol[3] –FriendlyName “SQL-NetApps” – DataSourceType SQL

Note : Change the ones in Pink in the above syntax  The rest of it stays.

image

DatasourceType supported are :

  • Client
  • SQL
  • SharePoint
  • Exchange
  • SystemProtection
  • HyperV
  • VMWare
  • Other
  • All

Remember to use a unique Volume number.  Usually my Practice is using Disk # – 1  (Disk Number minus 1, refer to the Disk Management)

image

Once the Update-DPMDiskDiskStorage shell command is done, navigate back to your DPM ConsoleManagementDisk Storage to see the Preferred Datasource Types has been changed

image

When the Protection Group is created, you can then select the appropriate storage for the kind of backup.  With this Workload Aware Storage, it will help to reduce storage costs.  

Hope this helps.

keywords : Application-aware backup, SCDPM 2016, System Center Data Protection Manager 2016, modern backup storage

Sunday, September 11, 2016

SCDPM – Protecting SQL 2012 & above.

To protect SQL Server 2012 or SQL Server 2014, the following must be done.

  • Login to SQL Server Management Studio

SNAGHTML1b7de7

  • Add the system account NTAuthority\System to the Sysadmin group on SQL Server
  • DPM cannot protect databases that are stored on remote SMB stores
  • Availability group replicas are configured as read-only
  • When you perform an alternate location recovery for a partially contained database, you must ensure that the target SQL instance has the Contained Databases feature enabled

Hope the above illustration helps

 

 

Wednesday, July 13, 2016

SCDPM–Job Failed to Cancel or Hung or Stuck BUT Cannot be remove

Environment
SCDPM 2012 SP1

It’s been hours the job has been cancelled but couldn’t be remove from the DPM job.  Can’t execute the next job due to the job is still in progress to cancel.   However, found the issue is with the SQL Database that is holding the job from being release. 

In the SCDPM console, it displays as below :

SNAGHTML6facbe

The following steps were carried out :

  • Launch the SQL Server Management Studio (<right-click> run as Administrator)

Once it’s launched, ensure DPM DB is connected

Copy the script below :

USE DPMDB

BEGIN TRAN

-- mark replica as invalid if there was some operation happening on that replica

UPDATE tbl_PRM_LogicalREplica

SET Validity = 1 -- Invalid

WHERE OwnerTaskIdLock IS NOT NULL AND

Validity <> 5 AND -- ProtectionStopped

Validity <> 6 -- Inactive

-- Release all the locks held

UPDATE tbl_PRM_LogicalREplica

SET OwnerTaskIdLock = null,

Status=8

if (select COUNT(name) from tbl_AM_Agent where Name like 'DPM RA v2%') > 0

begin

exec sp_executesql N'UPDATE tbl_RM_ShadowCopy

SET ArchivetaskId = NULL,

RecoveryJobId = NULL'

end

UPDATE tbl_ARM_Datasource

SET Status = 0,

OwnerLockId = NULL

DELETE tbl_RM_DatasourceServerlock

DELETE tbl_RM_ShadowCopyLocks

-- Set All running tasks and jobs to failed

UPDATE tbl_TE_TaskTrail

SET ExecutionState = 3,

LastStateName = 'Failure',

StoppedDateTime = GetUtcDate()

WHERE ExecutionState NOT IN (2,3)

UPDATE tbl_JM_JobTrail

SET JobState= 'Failed',

EndDateTime = GetUtcDate()

WHERE jobstate= 'Execute' OR jobstate= 'Retire'

-- unreserve resources held

UPDATE tbl_MM_Global_Media

SET ReservationLevel = 0,

ReservationOwnerMMId = null

UPDATE tbl_MM_Global_Drive

SET ReservationLevel = 0,

ReservationOwnerMMId = null

UPDATE tbl_MM_Global_IEPortResource

SET ReservationLevel = 0,

ReservationOwnerMMId = null

COMMIT TRAN

 

  • Click on New Query
  • Paste the Script into the Query Column
  • Click Execute

SNAGHTML8c5e05

  • Check on the OUTPUT column below
  • Close the SCDPM console and open it back.  It should clear the status and be able to execute whatever job that is outstanding.

Hope this helps.   Works on SCDPM 2012 R2 too. 

Resource of the script is from here.

Thank you.

keywords : SCDPM, Data protection manager 2012 SP1, SCDPM 2012 SP1, SCDPM 2012 R2, Job cancel but hang, cancel job failed

Friday, March 11, 2016

DPM 2012 Reporting Issue (ID : 220)

After upgrading from SCDPM 2012 SP1 to SCDPM 2012 R2, I hit the issue when I tried to configure the Reporting to be send out periodically in the Report Module of SCDPM 2012 R2.

image

The steps taken was the following :

  • Launch the Reporting Services Manager (in my example is SQL 2008 R2, since it’s upgraded gradually from SCDPM 2012 SP1 to SCDPM 2012 R2)
  • Ensure to the correct database that I’m pointing to  (e.g. MSDPM2012)
  • Navigate to E-Mail Settings.
  • Key in the valid Sender Address and SMTP Server.
  • Click Apply

SNAGHTML5532c4a

  • Launch the SCDPM 2012 R2 – Reporting
  • Configure the schedule reporting with emails, tested with no issues.keywords : SCDPM 2012, DPM cannot enable e-mail subscription for reports unless SMTP details are configured in the remote SQL Server Reporting Service Installation. SMTP details need to be configured manually when an existing SQL Server is chosen to be used for DPM during DPM setup.  Please enter the SMTP server name, SMTP port number and SMTP From address manually in the SQL Server Reporting Services configuration File.
    Configuration file path : c:\Program Files\Microsoft DPM\SQL\MSRS10.MSDPM2010\Reporting Services\ReportServer\RSReportServer.config
    The SMTP Server  details on the SMTP Servers tab in the Options dialog enables only DPM alert notifications. For more details, see DPM Help (ID : 220)
    SCDPM Report error, Systems Center Data Protection Manager Report Error, cannot configure email distribution in DPM report

Thursday, October 8, 2015

DPM Reporting – An error has occurred during report processing

I hit an issue on launching the DPM reporting.  The DPM is functioning well except the reporting.  It’s the issue of the SQL Reporting settings.

image

It stated as :

An error has occurred during report processing. (rsProcessingAborted).
Query execution failed for dataset ‘DataSet2’. (rsErrorExecutingCommand)
Invalid object name ‘vw_DPM_Replica’.

Steps taken to resolve :

  • Launch the Reporting Services Configuration Manager in the DPM
image
  • Select the Report Manager URL on the left panel
  • Click on the URL on the right panel

image

  • Double-click on the DPMReporterDataSource
image
  • The Connection string is missing.
  • Minimize this screen

image

  • Create a file call dbtest.udl on the desktop (it’s a build in Windows)
  • Double click on it.

image

  • Once the Data Link Properties launch, Select the server name (using the drop down)
  • Use the Windows NT integrated security for the credential
  • Select the database (using the drop down)
  • Click Test Connection

image

  • Click OK once it’s successful

image

  • Right-click on the dbtest.udl and open with notepad

image

  • Copy the text from “Intergrated ….. “till the end of the line

image

  • Maximize the DPMReporterDataSource
  • Paste the copied text into the Connection string.
  • Click on Test Connection (may request to key in password again)
  • Once successful, click Apply.

Launch the DPM reporting with no issue occurred.

keyword : DPM, SQL, SRSS, Reporting Services, rsErrorExecutingCommand, rsProcessingAborted, dataset, query execution failed, invalid object name

Thursday, August 13, 2015

Azure Recovery Services–backup increased to 54TB limit

Earlier last month I shared on how to configure the DPM 2012 R2 with Azure Recovery (Backup Vault)

Microsoft Azure recovery Services team has officially released the backup per protection group from 1.7TB limit and now to 54TB limit on 12th Aug 2015.

You need to have the Azure Recovery Services Agent 2.0.8715.0 or higher in order for the backup to exceed the limitation of 1.7TB.

image

The news release is here.

keynote : Azure limit, ASR, Azure Recovery Services, DPM, SCDPM, storage limit.backup limit

Friday, July 31, 2015

Class 20409B - Server Virtualization with Windows Server Hyper-V and System Center

 

Just finished conducting a 5-days class on Server Virtualization using Hyper-V and System Center.  During class, I shared real life scenarios on how it was implemented, what are the obstacles they will face if planning were not done properly in the first place before rolling out.

Feeling happy that the students went back with knowledge.

keywords : 20409, Hyper-V, virtualization, backup, protection, VMM, virtual machine manager, dpm, azure, cloud, vmmlibrary,

Wednesday, July 29, 2015

System Center Virtual Labs

 

Let’s get our hands ‘dirty’ and I want to share the “Virtual Labs” that I found especially lots and lots of Systems Center labs.

image

The Website is in this link.

Let’s get started !!

 

keywords : systems center, virtualization, virtual, hyper-v, virtual machine, data protection, monitoring, SCOM, SCCM, Service Manager

Tuesday, July 14, 2015

DPM 2012 R2 with Azure Recovery (Backup Vault)

I would like to share my experience on how to configure DPM 2012 R2 with Azure Recovery.  Which means I’ve already had a Disk to Disk backup in place in the DPM.  I would like to extend my backup to the Azure.

Firstly the DPM 2012 R2 needs to patch with at least UR5 and the Hotfix for UR5

The Download Links are as follow :

UR5

http://catalog.update.microsoft.com/v7/site/search.aspx?q=3021791

Hotfix for UR5

http://www.microsoft.com/en-in/download/details.aspx?id=45914

 

The blog will cover the following :

  • Creation in Azure Recovery (Backup Vault)
  • Register DPM into Azure Recovery
  • Manage Certificate
  • Install Microsoft Azure Backup Agent (MARS)
  • Attach Vault Credential to DPM

Azure Recovery

image

 

image
  • Key in the Name (must be unique) and select the region
  • Click Create Vault to finish it.

image

  • Should have the screen something like the above.

Manage Certificate

In the DPM Server, launch the command prompt in elevated mode

C:\>makecert.exe -r -pe -n CN=ICG-AP-SCDPM01 -ss my -sr localmachine -eku 1.3.6.1.5.5.7.3.2 -len 2048 -e 01/01/2017 ICG-AP-SCDPM01.cer

Change the values in pink and yellow only.  The rest of the syntax stays.

Pink = The DPM server that will be register into the Backup Vault
Yellow = Not more than 3 years for the validity of the certificate.

image

It should look something like the above in the DPM Server command prompt.

Next must upload the certificate to the Windows Azure backup vault.  Launch the Windows Azure Management Portal.

image

  • Click on the Recovery Services | Select the backup vault | Click on Manage Certificate

 

image

  • In the Manage Certificate, click Browse for the certificate file that was created using the command prompt of makecert.
  • Click on the Tick to confirm

image

  • Progress will show it has been successfully uploaded.

Install Microsoft Azure Backup Agent

image

  • Still in the manage Windows Azure Portal, click on the Download Agent for the DPM. Left click on it.

image

  • Click Save or Run (according to your preference)
  • If Save, then double-click on the file and execute it.

image

  • Click Next

image

  • Click Next if not using Proxy.
  • Then click Install .

image

  • Click Close once it’s completed.

Attach Vault Credential to DPM

The next step is to attach the Backup Vault for the DPM.

From Windows Manage Azure Portal | Recovery Services | the specific backup vault.

image

  • Click on the Download vault credentials.image

 

  • Save the File

Then back to the DPM Console

image

  • Click on the Management | then click on Register

 

image

  • Click Next.

image

  • Next is Backup vault  section, click Browse
  • Next in the following of the Backup Vault, click Browse
  • Select the certificate file and click Next.

image

  • Once it’s done, click Next.

image

  • Next is the Throttling Setting, input the necessary badwidth allocated, else click Next.

image

  • In the Recovery Folder Settings, key in or browse the Restore Folder assigned to the DPM server, then click Next.

image

  • In the Encryption section, click Generate passphrase (or you can key in your own)
  • Click Copy to clipboard
  • Open Notepad, then paste and save the file.
  • Then the Encryption Setting, click Register.

image

  • Click Close once the Register Server for Azure Backup is completed.

image

  • Click on Management in the left panel.
  • In the Online, verify it is registered,

Hopefully the above steps helps.

keys : System Center Data Protection, DPM, SCDPM, Azure Backup, Azure Recovery, Backup vault, Cloud backup, disk to disk to cloud.