Solved

DPM 2010 Tape List

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now