System Center Data Protection Manager 2007: Tape problems

November 25, 2009 at 4:10 pm in Uncategorized by mikeresseler

Hey All,

During one of the implementations of DPM, one of my colleagues got into problems with the recognition of a tape library.  Although the tape library worked during the staging phase, when it got into production, it stopped working.  There were 20 tapes in the library, but DPM didn’t recognize them, and after you ran a fast recovery, you got the following error:

 

Connection to the DPM service has been lost.

DPM service could be running in recovery mode, which was initiated by the DpmSync tool. If DpmSync is not running and the DPM service is still in recovery mode, then run DpmSync again.

 

After having multiple steps with the Microsoft support team, they finally found a solution.  Because I thought the process of troubleshooting was interesting, I thought I posted it here.

1) Try the obvious

– Make sure that you have run the DPMDriveMappingTool.exe

2) If you want to log a call with MS Support:

– Run a DPM MPS report, the tool can be downloaded @ http://www.microsoft.com/downloads/details.aspx?FamilyID=14392186-6707-45a5-8987-29665abbd6f5&displaylang=en

 

Out of the reports that we have sent to them, they saw that “More than one mediapool reported for same media”.

Apparently, this can happen each time the DPM database has incorrect information about the tape drives, which can be caused when OEM drivers are updated when the vendorID’s and productID’s change.

Now to solve this one, you need to run a query that will reset the tables.  They gave us two procedures for that, depending on whether the tape library is shared or not.

Here they are:

 

PROCEDURE-1) STANDALONE (non-shared) TAPE LIBRARY CONFIGURATION REPAIR STEPS
===============================================================================
1) Close DPM UI
2) Backup the DPMDB by running dpmbackup -db from command prompt.
3) Open sql server management studio in context of DPMDB database instance. Make
sure you are admin on the machine
4) Select DPMDB. Right click -> New Query
5) Open the Query.txt file and copy paste its content in the query window
6) Execute the query.
7) Make sure query has succeeded.
8) Close SQL management studio
9) Open DPM UI
10) Go to library management tab
11) Do rescan
12) Let this rescan succeed. This rescan will detect libraries and will run Fast
inventory on the library.

PROCEDURE-2) SHARED LIBRARY CONFIGURATION REPAIR STEPS
===========================================================
(step i) On Library DPM server :
1) Close DPM UI
2) Backup the DPMDB by running dpmbackup -db from command prompt.
3) Open sql server management studio in context of DPMDB database instance. Make
sure you are admin on the machine
4) Select DPMDB. Right click -> New Query
5) Open the Query.txt file and copy paste its content in the query window
6) Execute the query.
7) Make sure query has succeeded.
8) Close SQL management studio
(step ii) On Client DPM server :
1) Close DPMUI
2) Backup the DPMDB by running dpmbackup -db from command prompt.
3) Open sql server management studio in context of DPMDB database instance. Make
sure you are admin on the machine
4) Select DPMDB. Right click -> New Query
5) Open Query.txt file and copy paste its content in the query window
6) Execute the query.
7) Make sure query has succeeded.
8) Close SQL management studio
9) Now run SetSharedDPMDatabase tool with parameter as the library server instance
name (if this does not succeed then reboot the machine and again retry running the
tool)
IE: SetSharedDPMdatabase -Instancename
<dpmservername-hosting-Global-SQL-Server>\MS$DPM2007$
(step iii) on Library DPM server
1) Open DPM UI and then on Client DPM Server.
2) Go to library management tab
3) Do rescan
4) Let this rescan succeed. This rescan will detect libraries and will run Fast
inventory on the library. Let this finish before going to next step
(step iv) on Client DPM server
1) Open DPM UI and then on Client DPM Server.
2) Go to library management tab
3) Do rescan

 

And finally, of course, you need the query.  Because it is way too long to upload the text here, I’ll ask the site owners to upload the query to the media library on scug.be

// Update, just found out that you can attach something to a post.  So here it is… query.txt :-)

Cheers,

Mike