Solved

DPM 2010 Tape List

Posted on 2011-03-22
4
2,721 Views
Last Modified: 2013-06-10
I have a DPM 2010 server that i have recently recreated almost all of the protection groups on. The issue I am having is that there is not a report that gives me a list of all tapes and their expiry dates. Basically the problem i have is that many of the tapes that are currently in my offsite are good working tapes that have expired data but DPM will never tell me to bring those back because i deleted their protection groups.

In short, i need a list of all the tapes that DPM is currently using for my current protection group, that way i can take any tapes its NOT currently using back to be used again. Im hoping this can be done using an SQL query or Powershell script

Thanks!
0
Comment
Question by:rhenry-ez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 7

Expert Comment

by:PowerToTheUsers
ID: 35198033
When you deleted the protection groups, did you select to expire the recovery points on tape? If so those tapes should be "over due", and you can list them: On the reporting tab, go to Tape management report and let it generate. On the first page(s) there's the list with off-site ready tapes, but on the next pages you should see a list with "over due tapes": those tapes contain expired backups.

If you didn't check the option to delete the recovery points on tape, you have two options:
* Retain those recovery points on tape. Tapes that still contain recovery points won't be listed in the Over Due-list.
* Expire them now: go to the protection tab, at the bottom is the list with "recovery points for previously protected data". Righclick on the items to delete recovery points and select expire recovery points on tape.
0
 
LVL 1

Author Comment

by:rhenry-ez
ID: 35198248
PowerToTheUsers,
I did expire the recovery points when i deleted the protection group. However, my Tape Management Report shows no overdue tapes at all, it is only showing the ready for offsite tapes and tapes due in the next 1 week (as expected of the current protection groups).
0
 
LVL 7

Accepted Solution

by:
PowerToTheUsers earned 500 total points
ID: 35198468
Ah, to get the question right:
"many of the tapes that are currently in my offsite are good working tapes that have expired data but DPM will never tell me to bring those back because i deleted their protection groups."

So off-site you have a bunch of old, expired tapes from the old protection groups, mixed with a bunch of (expired and non-expired) tapes of the current protection groups? And you want a list of the first ones?
In the DPMDB, take a look at table tbl_MM_Media, I guess that will be part of your solution: in tht table are all tapes.
0
 
LVL 1

Author Closing Comment

by:rhenry-ez
ID: 35198659
Knowing the right table to look in gave me my answer. Thanks!
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I have a large data set and a SSIS package. How can I load this file in multi threading?
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question