Solved

DPM 2010 Tape List

Posted on 2011-03-22
4
2,756 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

623 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