Sometimes a tape will be marked as suspect, seemingly for no reason. To resolve this you need to do the follow these instructions to first identify the MediaID of the suspect tape against its Barcode. Then mark it as normal (i.e. not suspect).<\/p>\n\n\n\n
Ensure there is a backup of the SQL database for DPM. In SQL Query analyser:<\/p>\n\n\n\n
First run a query of the tapes to get a list of suspect tapes:<\/p>\n\n\n\n
select MediaId\n\nFROM [DPMDB].[dbo].[tbl_MM_ArchiveMedia]\n\nWHERE IsSuspect = 1\n\nYou can join this with the other table to match up the IsSuspect field:\n\nSELECT [BarcodeValue], [DPMDB].[dbo].[tbl_MM_ArchiveMedia].[MediaID]\n\nFROM [DPMDB].[dbo].[tbl_MM_ArchiveMedia]\n\nLEFT OUTER JOIN [DPMDB].[dbo].[tbl_MM_Media]\n\nON [DPMDB].[dbo].[tbl_MM_ArchiveMedia].[MediaID]=[DPMDB].[dbo].[tbl_MM_Media].[MediaID]\n\nWHERE IsSuspect = 1<\/code><\/pre>\n\n\n\nThis gives you all the suspect tapes. Then to query for that one duff tape by the MediaID.<\/p>\n\n\n\n
select *\n\nFROM [DPMDB].[dbo].[tbl_MM_ArchiveMedia]\n\nWHERE IsSuspect = 1\n\nLets say you want to mark tape mediaID = 6A146B3C-3DC9-4711-AF1D-9E826AF7979C as not suspect. In this case:000209L4 Like this:\n\nselect *\n\nFROM [DPMDB].[dbo].[tbl_MM_ArchiveMedia]\n\nWHERE IsSuspect = 1 AND MediaID = '6A146B3C-3DC9-4711-AF1D-9E826AF7979C'<\/code><\/pre>\n\n\n\nTo double check it. Then update the issuspect <\/strong>field with this:<\/p>\n\n\n\nUPDATE [DPMDB].[dbo].[tbl_MM_ArchiveMedia]\n\nSET IsSuspect = 0\n\nWHERE IsSuspect = 1 AND MediaID = '6A146B3C-3DC9-4711-AF1D-9E826AF7979C'<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"Sometimes a tape will be marked as suspect, seemingly for no reason. To resolve this you need to do the follow these instructions to first identify the MediaID of the suspect tape against its Barcode. Then mark it as normal (i.e. not suspect). Ensure there is a backup of the SQL database for DPM. In … Read more<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-657","post","type-post","status-publish","format-standard","hentry","category-microsoft-dpm"],"_links":{"self":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=657"}],"version-history":[{"count":1,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/657\/revisions"}],"predecessor-version":[{"id":1443,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/657\/revisions\/1443"}],"wp:attachment":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}